[
https://issues.apache.org/jira/browse/HIVE-221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zheng Shao resolved HIVE-221.
-----------------------------
Resolution: Won't Fix
In MySQL, the sub query alias is required.
> 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.
