You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "S. Alex Smith (JIRA)" <ji...@apache.org> on 2009/01/10 03:02:02 UTC
[jira] Created: (HIVE-221) select * fails on tables without alias
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.
[jira] Updated: (HIVE-221) select * fails on subqueries without
alias
Posted by "S. Alex Smith (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (HIVE-221) select * fails on subqueries without
alias
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ 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.