You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@beam.apache.org by GitBox <gi...@apache.org> on 2022/06/04 20:51:13 UTC

[GitHub] [beam] damccorm opened a new issue, #20996: BigQuery pipelines which query INFORMATION_SCHEMA views can fail to determine a query location

damccorm opened a new issue, #20996:
URL: https://github.com/apache/beam/issues/20996

   Repro steps:
   
   1. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.TABLES` view for a dataset
   2. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.SCHEMATA` view for a region
   3. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.SCHEMATA` view without specifying a region
   
   Expected behavior: all 3 pipelines succeed
   
   Imported from Jira [BEAM-12752](https://issues.apache.org/jira/browse/BEAM-12752). Original Jira may contain additional context.
   Reported by: kjung520.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [beam] rahuliyer95 commented on issue #20996: BigQuery pipelines which query INFORMATION_SCHEMA views can fail to determine a query location

Posted by GitBox <gi...@apache.org>.
rahuliyer95 commented on issue #20996:
URL: https://github.com/apache/beam/issues/20996#issuecomment-1189612156

   We also recently faced a similar issue and managed to work around this by setting the [withQueryLocation](https://beam.apache.org/releases/javadoc/2.40.0/org/apache/beam/sdk/io/gcp/bigquery/BigQueryIO.TypedRead.html#withQueryLocation-java.lang.String-) on `BigQueryIO.read()`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org