[
https://issues.apache.org/jira/browse/HIVE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13882239#comment-13882239
]
Lefty Leverenz commented on HIVE-6013:
--------------------------------------
This needs to be documented in various SELECT sections too. If backticks are
required when hive.support.quoted.identifiers is set to 'column' then a lot of
examples in Getting Started, the Tutorial, Language Manual's Select and other
Language Manual docs will need to be changed (or rather, duplicated with a
version note), for example:
* [Example Queries
|https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-ExampleQueries]
* [Querying and Inserting Data
|https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-QueryingandInsertingData]
* [Select
|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select]
Can wildcards/regex be used when hive.support.quoted.identifiers is 'column'?
Presumably 'SELECT * FROM table' is still valid. Here's the current
documentation:
* [REGEX Column Specification
|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-REGEXColumnSpecification]
> Supporting Quoted Identifiers in Column Names
> ---------------------------------------------
>
> Key: HIVE-6013
> URL: https://issues.apache.org/jira/browse/HIVE-6013
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Harish Butani
> Assignee: Harish Butani
> Fix For: 0.13.0
>
> Attachments: HIVE-6013.1.patch, HIVE-6013.2.patch, HIVE-6013.3.patch,
> HIVE-6013.4.patch, HIVE-6013.5.patch, HIVE-6013.6.patch, HIVE-6013.7.patch,
> QuotedIdentifier.html
>
>
> Hive's current behavior on Quoted Identifiers is different from the normal
> interpretation. Quoted Identifier (using backticks) has a special
> interpretation for Select expressions(as Regular Expressions). Have
> documented current behavior and proposed a solution in attached doc.
> Summary of solution is:
> - Introduce 'standard' quoted identifiers for columns only.
> - At the langauage level this is turned on by a flag.
> - At the metadata level we relax the constraint on column names.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
