[jira] [Updated] (BEAM-9243) bigqueryio for Go is doesn't support standard SQL

["Kenneth Knowles (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-9243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kenneth Knowles updated BEAM-9243:
----------------------------------
    Status: Open  (was: Triage Needed)

> 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
>    Affects Versions: 2.18.0
>            Reporter: Stephen Dotz
>            Priority: P3
>
> 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.1#820001)