无法创建视图。未知的TVF：myFunc [英] Failed to create view. Unknown TVF: myFunc

问题描述

我试图在BigQuery中创建一个包含javascript UDF（myFunc）的视图。在控制台中运行时，查询可以正常工作，UDF内联或在Google云端存储中引用URI。但是，当试图使用任何引用将查询保存为视图时，我会收到错误消息：

I am trying to create a view in BigQuery that contains a javascript UDF (myFunc). The query works fine when run in the console with either the UDF inline or referencing a URI in Google Cloud Storage. However, when trying to save the query as a view using either reference I get the error:

Failed to create view. Unknown TVF: myFunc

有什么方法可以在使用UDF的BigQuery中保存视图？我没有使用过REST API，但似乎可能根据 documentation。

Is there any way to save a view in BigQuery that uses a UDF? I haven't used the REST API, but it appears it may be possible to include both a view.query and externalDataConfiguration.sourceUris[] property in the request based on the data structure in the documentation.

推荐答案

修改：已修复！请参阅Thomas的答案（ https://stackoverflow.com/a/34300525/1375400 ）。

Edit: Fixed! See Thomas's answer (https://stackoverflow.com/a/34300525/1375400).

目前无法创建使用UDF的视图。我们希望在未来增加对此功能的支持。

Currently it's not possible to create a view that uses a UDF. We'd like to add support for this functionality in the future though.

这篇关于无法创建视图。未知的TVF：myFunc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！