Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 26 Jun 2014 19:39:25 +0000 (UTC)
From: "Sumit Kumar (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12715374.1400568466143.56326.1403811565165@arcas>
In-Reply-To: <JIRA.12715374.1400568466143@arcas>
References: <JIRA.12715374.1400568466143@arcas>
Subject: [jira] [Commented] (HIVE-7097) The Support for REGEX Column Broken
 in HIVE 0.13
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Sumit Kumar commented on HIVE-7097:
-----------------------------------

[~sunrui] I hit this today and found following references useful:

# https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn
# https://issues.apache.org/jira/secure/attachment/12618321/QuotedIdentifier.html

In short the functionality is still there but you need to set hive.support.quoted.identifiers to none to get the pre-0.13 behavior. I was able to run my query after
{code:actionscript}
hive> set hive.support.quoted.identifiers=none;
{code}

My query was something like:
{code:actionscript}
hive> select `(col1|col2|col3)?+.+` from testTable1;
{code}


> The Support for REGEX Column Broken in HIVE 0.13
> ------------------------------------------------
>
>                 Key: HIVE-7097
>                 URL: https://issues.apache.org/jira/browse/HIVE-7097
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.13.0
>            Reporter: Sun Rui
>
> The Support for REGEX Column is OK in HIVE 0.12, but is broken in HIVE 0.13.
> For example:
> {code:sql}
> select `key.*` from src limit 1;
> {code}
> will fail in HIVE 0.13 with the following error from SemanticAnalyzer:
> {noformat}
> FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or column reference 'key.*': (possible column names are: key, value)
> {noformat}
> This issue is related to HIVE-6037. When set "hive.support.quoted.identifiers=none", the issue will be gone.
> I am not sure the configuration was intended to break regex column. But at least the documentation needs to be updated: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-REGEXColumnSpecification
> I would argue backward compatibility is more important.


--
This message was sent by Atlassian JIRA
(v6.2#6252)