select * fails on tables without alias
--------------------------------------
Key: HIVE-221
URL: https://issues.apache.org/jira/browse/HIVE-221
Project: Hadoop Hive
Issue Type: Bug
Components: Query Processor
Reporter: S. Alex Smith
Priority: Minor
The following query fails:
SELECT * FROM (SELECT * FROM tmp_asmith);
Additionally, although the error message is frequently "... expected
Identifies", in certain more complicated expressions this is not the case. For
example, in
SELECT * FROM (SELECT * FROM tmp_asmith UNION ALL SELECT * FROM (SELECT * FROM
tmp_asmith)) t;
the error message is "FAILED: Parse Error: line 1:41 mismatched input 'UNION'
expecting )"
(but works fine if (SELECT * FROM tmp_asmith) is given an alias)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
