[HIVE-7097] The Support for REGEX Column Broken in HIVE 0.13

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Sun Rui
• Created: 20/May/14 06:47
• Updated: 27/Jun/14 14:52
• Resolved: 27/Jun/14 14:52

Description

The Support for REGEX Column is OK in HIVE 0.12, but is broken in HIVE 0.13.
For example:

select `key.*` from src limit 1;

will fail in HIVE 0.13 with the following error from SemanticAnalyzer:

FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or column reference 'key.*': (possible column names are: key, value)

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.

Issue Links

• is related to: HIVE-6013 Supporting Quoted Identifiers in Column Names
• is related to: HIVE-6037 Synchronize HiveConf with hive-default.xml.template and support show conf