[
https://issues.apache.org/jira/browse/HIVE-19064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17091635#comment-17091635
]
Jesus Camacho Rodriguez commented on HIVE-19064:
------------------------------------------------
[~belugabehr], we are aiming at the SQL standard and drop-in replacement for a
large variety of RDBMSs (not only MySQL).
The change that you are proposing is an extension to the SQL standard mode
proposed here. In fact, the ANSI_QUOTES mode in MySQL does not allow double
quotes for the literals, similar to what we are doing here:
{quote}
The ANSI_QUOTES mode causes the server to interpret double-quoted strings as
identifiers. Consequently, when this mode is enabled, string literals must be
enclosed within single quotation marks.
{quote}
That is why it is behind an option in MySQL too, because it is not backwards
compatible. Queries like {{select "col1" from table}} become ambiguous in a
combined mode (in legacy behavior, that should be a literal; in SQL standard,
that should be an identifier).
If it is widely requested that we support backticks for identifiers in the SQL
standard mode, we could consider adding that in a follow-up JIRA (fwiw, after
this JIRA is committed, implementation-wise it should be straightforward).
However, I am not sure why having a 'standard' mode that adheres to the SQL
standard should be a cause of any concern.
> Add mode to support delimited identifiers enclosed within double quotation
> --------------------------------------------------------------------------
>
> Key: HIVE-19064
> URL: https://issues.apache.org/jira/browse/HIVE-19064
> Project: Hive
> Issue Type: Improvement
> Components: Parser, SQL
> Affects Versions: 3.0.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Krisztian Kasa
> Priority: Major
> Attachments: HIVE-19064.01.patch, HIVE-19064.02.patch,
> HIVE-19064.03.patch, HIVE-19064.4.patch, HIVE-19064.5.patch,
> HIVE-19064.6.patch, HIVE-19064.7.patch, HIVE-19064.7.patch
>
>
> As per SQL standard. Hive currently uses `` (backticks). Default will
> continue being backticks, but we will support identifiers within double
> quotation via configuration parameter.
> This issue will also extends support for arbitrary char sequences, e.g.,
> containing {{~ ! @ # $ % ^ & * () , < >}}, in database and table names.
> Currently, special characters are only supported for column names.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
