You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/04/07 18:36:12 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=14483450#comment-14483450 ]
ASF GitHub Bot commented on HIVE-6013:
--------------------------------------
GitHub user Jeffrio opened a pull request:
https://github.com/apache/hive/pull/31
Update HiveDatabaseMetaData.java change the identifierQuoteString
according to this jira https://issues.apache.org/jira/browse/HIVE-6013
hive use the backstick as the quotestring
so, I think the getIdentifierQuoteString() function should return the backstick rather than the space
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Jeffrio/hive patch-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/hive/pull/31.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #31
----
commit 5ac637c83615aa389db49ce169c0df0461619c63
Author: Jeffrio <co...@163.com>
Date: 2015-04-07T16:35:11Z
Update HiveDatabaseMetaData.java change the identifierQuoteString
according to this jira https://issues.apache.org/jira/browse/HIVE-6013
hive use the backstick as the quotestring
so, I think the getIdentifierQuoteString() function should return the backstick rather than the space
----
> 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.3.4#6332)