You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Eva Mariam (Jira)" <ji...@apache.org> on 2021/04/08 02:14:00 UTC

[jira] [Commented] (HIVE-6013) Supporting Quoted Identifiers in Column Names

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

Eva Mariam commented on HIVE-6013:
----------------------------------

Views cannot be created over tables having columns with special characters.

> 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
>            Priority: Major
>             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
(v8.3.4#803005)