BigQuery函数不起作用 [英] BigQuery Functions Not Working

问题描述

我们的apps脚本中的bigquery函数一直工作得很好，但是从18/06/2013开始， setQuery（）和其他 BigQuery 函数已停止工作。

The bigquery functions in our apps script had been working fine all along but 18/06/2013 onwards setProjectId(), setQuery() and other BigQuery functions have stopped working.

使用这些函数时，变量保持不变未定义，当他们应该理想地填充。

On using these functions, the variables remain undefined when they should ideally be populated.

一个小的示例脚本再现这个问题：

A small sample script which reproduces this issue:

var newJobReference = BigQuery.newJobReference().setProjectId(yourProjectID);
var jobConfig = BigQuery.newJobConfiguration().setQuery(yourJobQueryConfiguration);

任何人都面临同样的问题？什么可能导致这种情况？

Anyone facing the same issue? What might be causing this?

推荐答案

Issue is resolved when I use:

var newJobReference = BigQuery.newJobReference();
newJobReference.setProjectId(yourProjectID);

而不是：

Instead of:

var newJobReference = BigQuery.newJobReference().setProjectId(yourProjectID);

这篇关于BigQuery函数不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！