(DEPRECATED) Apache Flink User Mailing List archive.

Using double quotes for SQL identifiers

Classic

List

Threaded

4 messages Options

Gyula Fóra

Using double quotes for SQL identifiers

Hi All!

Is it possible in any way to configure the Table environments to allow double quotes (") to be used for identifiers instead of backticks (`).

Thank you!

Gyula

Sebastian Liu

Re: Using double quotes for SQL identifiers

Hi Gyula,

AFAIK, except the sql-dialect, table API does not expose any parser related configuration to the user.

But we still can change the config of quoting identifiers in parser with some code changing.

You can reference this test class: org.apache.flink.sql.parser.FlinkDDLDataTypeTest.TestFactory.

Gyula Fóra <[hidden email]> 于2021年1月26日周二下午8:42写道：

Hi All!

Is it possible in any way to configure the Table environments to allow double quotes (") to be used for identifiers instead of backticks (`).

Thank you!
Gyula

With kind regards
------------------------------------------------------------
Sebastian Liu 刘洋
Institute of Computing Technology, Chinese Academy of Science
Mobile\WeChat: +86—15201613655
E-mail: [hidden email]
QQ: 3239559

Timo Walther

Re: Using double quotes for SQL identifiers

Hi Gyula,

the TableEnvironment.getConfig offers a setPlannerConfig. And
org.apache.flink.table.planner.calcite.CalciteConfigBuilder helps in
creating an object that implements this interface. You should be able to
influence the Calcite parser config with this.

However, I'm not sure how well this config is passed through the stack.

Regards,
Timo

On 26.01.21 17:38, Sebastian Liu wrote:

> Hi Gyula,
>
> AFAIK, except the sql-dialect, table API does not expose any parser
> related configuration to the user.
> But we still can change the config of quoting identifiers in parser with
> some code changing.
> You can reference this test class:
> org.apache.flink.sql.parser.FlinkDDLDataTypeTest.TestFactory.
>
>
> Gyula Fóra <[hidden email] <mailto:[hidden email]>> 于2021年
> 1月26日周二下午8:42写道：
>
> Hi All!
>
> Is it possible in any way to configure the Table environments to
> allow double quotes (") to be used for identifiers instead of
> backticks (`).
>
> Thank you!
> Gyula
>
>
>
> --
>
> *With kind regards
> ------------------------------------------------------------ Sebastian
> Liu 刘洋 Institute of Computing Technology, Chinese Academy of Science
> Mobile\WeChat: +86—15201613655 E-mail: [hidden email]
> <mailto:[hidden email]> QQ: 3239559*
>

Gyula Fóra

Re: Using double quotes for SQL identifiers

Thanks guys for the pointers, I will give it a try!

Gyula

On Tue, Jan 26, 2021 at 5:53 PM Timo Walther <[hidden email]> wrote:

Hi Gyula,

the TableEnvironment.getConfig offers a setPlannerConfig. And
org.apache.flink.table.planner.calcite.CalciteConfigBuilder helps in
creating an object that implements this interface. You should be able to
influence the Calcite parser config with this.

However, I'm not sure how well this config is passed through the stack.

Regards,
Timo

On 26.01.21 17:38, Sebastian Liu wrote:
> Hi Gyula,
>
> AFAIK, except the sql-dialect, table API does not expose any parser
> related configuration to the user.
> But we still can change the config of quoting identifiers in parser with
> some code changing.
> You can reference this test class:
> org.apache.flink.sql.parser.FlinkDDLDataTypeTest.TestFactory.
>
>
> Gyula Fóra <[hidden email] <mailto:[hidden email]>> 于2021年
> 1月26日周二下午8:42写道：
>
> Hi All!
>
> Is it possible in any way to configure the Table environments to
> allow double quotes (") to be used for identifiers instead of
> backticks (`).
>
> Thank you!
> Gyula
>
>
>
> --
>
> *With kind regards
> ------------------------------------------------------------ Sebastian
> Liu 刘洋 Institute of Computing Technology, Chinese Academy of Science
> Mobile\WeChat: +86—15201613655 E-mail: [hidden email]
> <mailto:[hidden email]> QQ: 3239559*
>