Invalid/unsupported arguments for SQL job launch: Query uses unsupported SQL features:

[ricjhill]

OVERVIEW

I am using dataflow, SQL workspace to build a pipeline which extracts data from bigquery. The dataflow SQL editor shows the SQL query is valid. However, the dataflow job fails to complete and gives the error.

ERROR

Invalid/unsupported arguments for SQL job launch: Query uses unsupported SQL features: Only support column reference or struct field access in conjunction clause

QUESTIONS

• What does the error mean?
• Which object supports column reference or struct field access in conjunction clause?
• Why does the query validate in the dataflow SQL editor but throw an error when the job runs?
• Why does the query run OK in big-query and not a dataflow job? Are different SQL parsers used?
• Where can I learn more about why this error occurred?
• Where can I log a bug report if needed

SQL QUERYSELECT

  DISTINCT title,
  url,date
  textbody,
  files.path AS filepath,
  o.text AS text
FROM
  bigquery.table.myproject.mydataset.mytable,
  UNNEST( files ) files
INNER JOIN
  bigquery.table.bigquery.table.myproject.mydataset.extractedtext AS o
ON
  files.path = SUBSTRING(o.uri,18)
WHERE
  files.extractedtext IS null

[comaro]

Your project would need to be inspected by support.

This can be done over a support case under a valid business justification.