hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <>
Subject [jira] [Commented] (HIVE-6013) Supporting Quoted Identifiers in Column Names
Date Sun, 26 Jan 2014 09:11:38 GMT


Lefty Leverenz commented on HIVE-6013:

This needs to be documented in various SELECT sections too.  If backticks are required when 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 |]
* [Querying and Inserting Data |]
* [Select |]

Can wildcards/regex be used when is 'column'?  Presumably
'SELECT * FROM table' is still valid.  Here's the current documentation:

* [REGEX Column Specification |]

> 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