Skip to main content
Question

BigQuery Reader SQL with regexp_contains fails before execution

  • July 7, 2021
  • 1 reply
  • 22 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
  • July 7, 2021

This attempt was via SQLExecuter > Format: Google BigQuery

 

I switched over to GoogleBigQueryConnector and the error went away.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings