You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-zh@flink.apache.org by 王 outlook <de...@outlook.com> on 2020/07/06 09:06:47 UTC

Flink SQL 关键字 user？

我发现我创建表 字段名为 user会报错。 user是关键字吗，还是其他原因


"CREATE TABLE ods_foo (\n" +
"    id INT,\n" +
"    user ARRAY<ROW<name STRING>>\n" +
") WITH (

Exception in thread "main" org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "user" at line 3, column 5.
Was expecting one of:

Re: Flink SQL 关键字 user？

Posted by Benchao Li <li...@apache.org>.

是的，user是关键字，关键字列表可以参考[1].

如果遇到关键字，可以使用 ` 来处理，比如：
CREATE TABLE `user` (...) WITH (...);

[1]
https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/#reserved-keywords

王 outlook <de...@outlook.com> 于2020年7月6日周一 下午5:07写道：

> 我发现我创建表 字段名为 user会报错。 user是关键字吗，还是其他原因
>
>
> "CREATE TABLE ods_foo (\n" +
> "    id INT,\n" +
> "    user ARRAY<ROW<name STRING>>\n" +
> ") WITH (
>
> Exception in thread "main" org.apache.flink.table.api.SqlParserException:
> SQL parse failed. Encountered "user" at line 3, column 5.
> Was expecting one of:
>
>
>
>

-- 

Best,
Benchao Li

Re: Flink SQL 关键字 user？

Posted by Leonard Xu <xb...@gmail.com>.

Hi，
是的，用`user`转义处理下，
完整的保留关键字参考[1]

Best,
Leonard
[1] https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/ <https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/>

> 在 2020年7月6日，17:06，王 outlook <de...@outlook.com> 写道：
> 
> "CREATE TABLE ods_foo (\n" +
> "    id INT,\n" +
> "    user ARRAY<ROW<name STRING>>\n" +
> ") WITH (