You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/03/26 01:05:51 UTC
[jira] Resolved: (HIVE-261) union all query hangs
[ https://issues.apache.org/jira/browse/HIVE-261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain resolved HIVE-261.
-----------------------------
Resolution: Duplicate
Assignee: Namit Jain (was: Ashish Thusoo)
duplicate of jira 318
> union all query hangs
> ---------------------
>
> Key: HIVE-261
> URL: https://issues.apache.org/jira/browse/HIVE-261
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Hao Liu
> Assignee: Namit Jain
>
> we have this query:
> SELECT a.u, b.id FROM (
> SELECT a1.u, a1.id as id FROM t_1 a1 WHERE a1.date = '2009-01-01' UNION ALL
> SELECT a2.u, a2.id as id FROM t_2 a2 WHERE a2.date = '2009-01-01' UNION ALL
> ...
> SELECT aN.u, aN.id as id FROM t_N an WHERE aN.date = '2009-01-01'
> ) a
> JOIN t b ON a.id = b.id WHERE b.date='2009-01-01'
> GROUP BY a.u, b.id
> When we union more than 20 tables, the query will hang. It looks like something wrong in the compiler.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.