[
https://issues.apache.org/jira/browse/HIVE-7097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sun Rui updated HIVE-7097:
--------------------------
Description:
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.
was:
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:sql}
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.
> 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)
