Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. sqlalchemy.exc.ProgrammingError: (snowflake.connector.errors.ProgrammingError) 100130 (53200): Out of memory error caused by LIMIT and/or OFFSET clause. Try reducing the number of rows requested. [SQL: "\n SELECT\n date_pulled AS date,\n json_data::string AS json\n FROM spring_ods.spring_hotel_inventory\n WHERE date_pulled::date >= DATEADD(months, -3, CURRENT_DATE())\n AND date_pulled > '2018-11-21T05:04:45'::timestamp\n ORDER BY date_pulled ASC\n LIMIT 1000000\n ;\n "] (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement