You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Bochun Bai (JIRA)" <ji...@apache.org> on 2011/06/09 06:08:58 UTC
[jira] [Commented] (HIVE-1458) Table aliases are case sensitive.
[ 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