Skip to main content
Question

BigQuery Reader SQL with regexp_contains fails before execution

  • July 7, 2021
  • 1 reply
  • 30 views

jbradfor
Contributor
Forum|alt.badge.img+7

I have a SQL statement that contains a regexp_contains.  It works fine in BigQuery SQL Editor, but FME chokes on it before it even executes it in BiqQuery.  Even if I comment out the statement it still throws the same error unless I remove it completely.

regexp_contains(table1.col1, '^[[:digit:]]+$')

Do I have to escape this somehow?

 

Error :

Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module GOOGLEBIGQUERY to read data

Google BigQuery: Using billing project xxx

java.lang.IllegalArgumentException: Illegal group reference

1 reply

jbradfor
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • 35 replies
  • July 7, 2021

This attempt was via SQLExecuter > Format: Google BigQuery

 

I switched over to GoogleBigQueryConnector and the error went away.