We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
For example when dataset contains tables "event_" and "event_fresh_", the following query may fail.
select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201'
The error message from "bq" command is following:
Exception raised in query operation: Error processing job 'aaa:bbb_1': failed to scan rows: strconv.parseInt: parsing "_fresh_20240101": invalid syntax
Expected the query to return rows contained in event_* table.
Create two tables event_ and event_fresh_, insert data to both (?) run
Command I used in terminal.
bq query --api http://localhost:9050 --project_id test "select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201' limit 10"
The text was updated successfully, but these errors were encountered:
No branches or pull requests
What happened?
For example when dataset contains tables "event_" and "event_fresh_", the following query may fail.
select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201'
The error message from "bq" command is following:
Exception raised in query operation: Error processing job 'aaa:bbb_1': failed to scan rows: strconv.parseInt: parsing "_fresh_20240101": invalid syntax
What did you expect to happen?
Expected the query to return rows contained in event_* table.
How can we reproduce it (as minimally and precisely as possible)?
Create two tables event_ and event_fresh_, insert data to both (?) run
select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201'
Anything else we need to know?
Command I used in terminal.
bq query --api http://localhost:9050 --project_id test "select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201' limit 10"
The text was updated successfully, but these errors were encountered: