[
https://issues.apache.org/jira/browse/HIVE-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13046327#comment-13046327
]
Bochun Bai commented on HIVE-1458:
----------------------------------
Current trunk does not have this problem.
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
