[ 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)