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
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.
