Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-9243

bigqueryio for Go is doesn't support standard SQL

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Triage Needed
    • Priority: P3
    • Resolution: Unresolved
    • Affects Version/s: 2.18.0
    • Fix Version/s: None
    • Component/s: io-go-gcp
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sdotz Stephen Dotz
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: