6

I'm using standardSQL with bigrquery:

library(bigrquery)
project <- "</project-name>"


sql <- "
#standardSQL
SELECT
</sql-query>;"


result <- query_exec(sql, project = project, useLegacySql = FALSE)

When I run the R script I get the following error: 

 "Error: Query text specifies use_legacy_sql:false, while API options specify:true"

Any ideas what might be going on here?

Ric S
  • 9,073
  • 3
  • 25
  • 51
Rory Newton
  • 61
  • 1
  • 2

2 Answers2

2

I think it's use_legacy_sql = FALSE (note the underscores, not camelcase)

See here.

Graham Polley
  • 14,393
  • 4
  • 44
  • 80
-1

You just need to uncheck of "use legacy sql" at the "hide options". Here is the screenshot:

enter image description here

sanyassh
  • 8,100
  • 13
  • 36
  • 70
Kostyantyn Yakymyshyn
  • 67
  • 11