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