hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sumit Kumar (JIRA)" <>
Subject [jira] [Commented] (HIVE-7097) The Support for REGEX Column Broken in HIVE 0.13
Date Thu, 26 Jun 2014 19:39:25 GMT


Sumit Kumar commented on HIVE-7097:

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


In short the functionality is still there but you need to set
to none to get the pre-0.13 behavior. I was able to run my query after
hive> set;

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

> The Support for REGEX Column Broken in HIVE 0.13
> ------------------------------------------------
>                 Key: HIVE-7097
>                 URL:
>             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 "",
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:
> I would argue backward compatibility is more important.

This message was sent by Atlassian JIRA

View raw message