[
https://issues.apache.org/jira/browse/BEAM-9243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17548475#comment-17548475
]
Danny McCormick commented on BEAM-9243:
---------------------------------------
This issue has been migrated to https://github.com/apache/beam/issues/20107
> bigqueryio for Go is doesn't support standard SQL
> -------------------------------------------------
>
> Key: BEAM-9243
> URL: https://issues.apache.org/jira/browse/BEAM-9243
> Project: Beam
> Issue Type: Improvement
> Components: io-go-gcp
> Reporter: Stephen Dotz
> Priority: P2
>
> It appears that bigqueryio for Go is hardcoded to use legacy SQL, with no way
> to use standard SQL. The BQ API will still reject the request if you use the
> #stardardSQL comment/flag in the query since the sql version is set
> explicitly in the API call.
>
> [https://github.com/apache/beam/blob/master/sdks/go/pkg/beam/io/bigqueryio/bigquery.go#L127]
>
> Seems like we can pass an options param into the Query function to provide
> this setting among others. I will take a look at doing this. LMK if there is
> another stylistic approach to consider.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
