[ 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)