hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hao Liu (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-261) union all query hangs
Date Thu, 29 Jan 2009 23:59:59 GMT
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


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.


Mime
View raw message