Stephen Dotz created BEAM-9243:
----------------------------------
Summary: bigqueryio for Go is hardcoded to use legacy 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
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.3.4#803005)
