[
https://issues.apache.org/jira/browse/HIVE-19064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17091564#comment-17091564
]
David Mollitor commented on HIVE-19064:
---------------------------------------
I'll also say that these "modes" add a lot more internal complications. If the
mode is {{standard}} what about {{SHOW CREATE TABLE}}? Will this now be
altered to display the CREATE TABLE statement in a format that will be valid in
each mode? What about error messages that may currently encapsulate the error
information in back ticks, or if I want to use different 3rd party tools that
use different syntax, some may use back ticks and some may use double
quotes,... there is no mode that allows me to interoperate all of these tools
at the same time.
Again, much better to have a way to accept literal values, back tick'ed values,
AND double quotes on top of it.
> 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)
