[
https://issues.apache.org/jira/browse/HIVE-19064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17096531#comment-17096531
]
David Mollitor commented on HIVE-19064:
---------------------------------------
{code:java}
Quotation quotation = Quotation.from(conf);
if (quotation != Quotation.NONE) {
identifier = identifier.replaceAll("`", "``");
}
{code}
The same rule applies for double quotes, not only back ticks.
bq. Identifier quote characters can be included within an identifier if you
quote the identifier. If the character to be included within the identifier is
the same as that used to quote the identifier itself, then you need to double
the character.
bq. A " inside a string quoted with " may be written as "".
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
> 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.10.patch, HIVE-19064.4.patch,
> HIVE-19064.5.patch, HIVE-19064.6.patch, HIVE-19064.7.patch,
> HIVE-19064.7.patch, HIVE-19064.8.patch, HIVE-19064.9.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)
