标准SQL在bigrquery中 [英] Standard SQL in bigrquery

问题描述

我试图使用R的 bigrquery 包来从BigQuery获取一些数据到R会话中。但是，我的查询是使用BigQuery的标准SQL 而不是其传统的SQL方言编写的。如何让程序包使用标准而不是传统SQL来运行查询？ 请参阅下面的示例

b
$ b

  insert_query_job<  - 函数（query，project，destination_table = NULL，
 default_dataset = NULL，
 create_disposition =CREATE_IF_NEEDED ，
 write_disposition =WRITE_EMPTY，
 useLegacySql = FALSE）
  

I'm trying to use R's bigrquery package to get some data from BigQuery into an R session. However, my query is written in BigQuery's Standard SQL rather than its legacy SQL dialect. How do I tell the package to run the query using Standard rather than legacy SQL?

解决方案

See example below

insert_query_job <- function(query, project, destination_table = NULL,
    default_dataset = NULL,
    create_disposition = "CREATE_IF_NEEDED",
    write_disposition = "WRITE_EMPTY",
    useLegacySql = FALSE)

这篇关于标准SQL在bigrquery中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！