[
https://issues.apache.org/jira/browse/HIVE-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan resolved HIVE-1458.
------------------------------------
Resolution: Cannot Reproduce
No longer a problem in trunk.
> Table aliases are case sensitive.
> ---------------------------------
>
> Key: HIVE-1458
> URL: https://issues.apache.org/jira/browse/HIVE-1458
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Jonathan Chang
> Assignee: Paul Yang
> Priority: Minor
>
> This query:
> SELECT exploded, COUNT(1)
>
> FROM (
>
> SELECT SPLIT(value, "0") AS value
>
> FROM tmp_jonchang_hive_test
>
> ) B LATERAL VIEW explode(value) C AS exploded
>
> GROUP BY exploded
> produces the error:
> FAILED: Error in semantic analysis: line 7:9 Invalid Table Alias or Column
> Reference exploded
> However, when B is changed to lowercase, the query works as expected:
> SELECT exploded, COUNT(1)
>
> FROM (
>
> SELECT SPLIT(value, "0") AS value
>
> FROM tmp_jonchang_hive_test
>
> ) b LATERAL VIEW explode(value) C AS exploded
>
> GROUP BY exploded
> Table aliases shouldn't be case sensitive AFAIK. And even if they are, I
> can't see the cause for the error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
