google bigquery - How can I specify Standard SQL in a Talend tBigQueryInput query? -


i have tried specifying standard sql using query prefix syntax bigquery seems ignore directive:

"#standardsql  \r\n select column1 `mydataset.myview`" 

but error:

running query : #standardsql   select column1 mydataset.myview ---> reason: invalidquery message: cannot reference sql view in legacy sql query. 

i got work removing space between "#standardsql , \r\n.

works:

"#standardsql\r\n 

doesn't work:

"#standardsql \r\n 

rtfm:

"must separated query newline character" 

my update fm:

"must separated query newline character" 

Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -