hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <>
Subject [jira] [Updated] (HIVE-6013) Supporting Quoted Identifiers in Column Names
Date Fri, 20 Dec 2013 19:42:09 GMT


Harish Butani updated HIVE-6013:

    Release Note: 
The default behavior for quoted identifiers has been changed. Now at the language level any
Column Name that is specified within back-ticks(`) is treated literally. This is inline with
standard sql behavior for quoted identifiers. Within back-tick strings use double back-ticks
to escape. 

To revert to old behavior(that of interpreting back-ticked names as regular expressions) use
the new parameter:; set to the value 'none'.
    Hadoop Flags: Incompatible change

> Supporting Quoted Identifiers in Column Names
> ---------------------------------------------
>                 Key: HIVE-6013
>                 URL:
>             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
> 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

View raw message