trino: wildcard tables not supported for BigQuery connector

The Presto BigQuery connection doesn’t support wildcard tables statements like below select * from bigquery.bq_schema.ga_sessions_* limit 100

SQL Error [65536]: Query failed: io.grpc.StatusRuntimeException: INVALID_ARGUMENT: request failed: wildcard tables are not supported.

Here is the documentation for more details https://cloud.google.com/bigquery/docs/reference/standard-sql/wildcard-table-reference

About this issue

  • Original URL
  • State: closed
  • Created 4 years ago
  • Reactions: 4
  • Comments: 18 (18 by maintainers)

Most upvoted comments

I am in favor of "table_prefix_*" syntax because

  • it’s BigQuery-specific but at this point the use-case seems BigQuery-specific too
  • it’s most familiar for the users

let’s wait few more days for others @trinodb/maintainers to chime in if they have opinion.

+1
findepi on May 19, 2022
Read more comments on GitHub
← trino: Trino 356 : Deletion of partitions is not happening
WifiWizard2: getConnectedSSID() return unknown ssid in some mobile devices →