hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6013) Supporting Quoted Identifiers in Column Names
Date Wed, 18 Dec 2013 18:18:08 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13851982#comment-13851982
] 

Harish Butani commented on HIVE-6013:
-------------------------------------

You mean set hive.support.quoted.identifiers=none; right?
With it is set to 'column' it will treat it as a literal.
And the query would be: select `a.*` from t1;
You need the back-ticks. Otherwise this will not get past the lexer.

Since 'none' is default setting, i thought the exiting test was enough. 


> 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,
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.4#6159)

Mime
View raw message