BigQuery: “unexpected LIMIT clause at:” error when using list query job

1
votes

I ran a simple select query (with no LIMIT applied) using the Big Query python api. I also supplied a destination table as the result was too large. When run, the job returned an "unexpected LIMIT clause" error. I used ignore case at the end of the query. There could be a possibility that it might be causing the problem.

Anybody ran into a similar problem?

For reference, my job_id is job_QrkB7t9WFEHqcH5qfsPZZsM476E

1
pythongoogle-bigquery

1 Answers

1
votes

This issue is an artifact of how bigquery does "allow large results" queries interacting poorly with the "ignore case" clause. We're tracking an internal bug on the issue, and hopefully will have a fix soon. The workaround is either to remove the "allow large results" flag or the "ignore case" clause.