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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message