drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4531) Query with filter and aggregate hangs in planning phase
Date Wed, 23 Mar 2016 22:18:25 GMT
Jinfeng Ni created DRILL-4531:
---------------------------------

             Summary: Query with filter and aggregate hangs in planning phase
                 Key: DRILL-4531
                 URL: https://issues.apache.org/jira/browse/DRILL-4531
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Jinfeng Ni
            Assignee: Jinfeng Ni
             Fix For: 1.7.0


For the following query,

{code}
SELECT  cust.custAddress, 
       lineitem.provider 
FROM ( 
      SELECT cast(c_custkey AS bigint) AS custkey, 
             c_address                 AS custAddress 
      FROM   cp.`tpch/customer.parquet` ) cust 
LEFT JOIN 
  ( 
    SELECT DISTINCT l_linenumber, 
           CASE 
             WHEN l_partkey IN (1, 2) THEN 'Store1'
             WHEN l_partkey IN (5, 6) THEN 'Store2'
           END AS provider 
    FROM  cp.`tpch/lineitem.parquet` 
    WHERE ( l_orderkey >=20160101 AND l_partkey <=20160301) 
      AND   l_partkey IN (1,2, 5, 6) ) lineitem
ON        cust.custkey = lineitem.l_linenumber 
WHERE     provider IS NOT NULL 
GROUP BY  cust.custAddress, 
          lineitem.provider 
ORDER BY  cust.custAddress, 
          lineitem.provider;
{code}

When run on today's master branch commit: 79a3c164c1df7a5d7a0b82574316b4a0b1c7593e, query
just hangs there in the planning phase.

Log shows that it stuck in Drill_Logical planning phase. 
 

 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message