[
https://issues.apache.org/jira/browse/HIVE-221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
S. Alex Smith updated HIVE-221:
-------------------------------
Summary: select * fails on subqueries without alias (was: select * fails
on tables without alias)
> select * fails on subqueries 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.
