You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Paul Yang (JIRA)" <ji...@apache.org> on 2010/07/13 00:08:50 UTC
[jira] Assigned: (HIVE-1458) Table aliases are case sensitive.
[ https://issues.apache.org/jira/browse/HIVE-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Yang reassigned HIVE-1458:
-------------------------------
Assignee: Paul Yang
> Table aliases are case sensitive.
> ---------------------------------
>
> Key: HIVE-1458
> URL: https://issues.apache.org/jira/browse/HIVE-1458
> Project: Hadoop Hive
> Issue Type: Bug
> 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.
-
You can reply to this email to add a comment to the issue online.