Backquote in SQL dialect

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Backquote in SQL dialect

Satyam Shekhar
Hello,

I have been happily using Flink as the SQL engine for running streaming and batch queries. 

I am curious to understand the rationale behind Flink using backticks (`) for quoting purposes instead of standard double quotes ("). Is double-quote reserved for some other usage?

Regards,
Satyam
Reply | Threaded
Open this post in threaded view
|

Re: Backquote in SQL dialect

Timo Walther
Hi Satyam,

this has historical reasons. In the beginning all SQL queries were
embedded in Java programs and thus Java strings. So single quote was
handy for declaring SQL strings in a Java string and backticks for
escaping keywords. But I agree that we should make this configurable.
Feel free to open an issue for this in JIRA.

Regards,
Timo


On 17.09.20 21:14, Satyam Shekhar wrote:

> Hello,
>
> I have been happily using Flink as the SQL engine for running streaming
> and batch queries.
>
> I am curious to understand the rationale behind Flink using backticks
> (`) for quoting purposes instead of standard double quotes ("). Is
> double-quote reserved for some other usage?
>
> Regards,
> Satyam