什么是"SQL启动器中的错误"?表示何时使用Dataflow SQL UI? [英] What is "Error in SQL Launcher" means when using Dataflow SQL UI?

问题描述

我试图使用Dataflow SQL UI创建一个Dataflow作业.我遵循了使用Dataflow SQL教程和该作业正常运行.我将数据源更改为BigQuery表.我的计划是:

I tried to create a Dataflow job using the Dataflow SQL UI. I followed the Using Dataflow SQL Tutorial and the job ran properly. I changed the data source to a BigQuery table. My plan is:

1. 从BigQuery表中查询
2. 将结果保存回BigQuery表.

当我创建数据流作业时，收到错误消息: SQL Launcer中的错误

When I creating the dataflow job, I got the error message: Error in SQL Launcer

错误是什么意思?感谢您的帮助！

What does the error mean? Thanks for your help!

推荐答案

数据流SQL尚不支持DATE类型(SQL验证程序中存在一个未能捕获该错误的错误).选择具有DATE类型的字段将导致该NPE错误消息，而解决方法是仅选择受支持.

Dataflow SQL does not yet support the DATE type (there was a bug in the SQL Validator that didn't catch that). Selecting a field with DATE type will cause that NPE error message, and the fix is to only select fields that are supported.

这篇关于什么是"SQL启动器中的错误"?表示何时使用Dataflow SQL UI?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！