drill-issues 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,

SELECT  cust.custAddress, 
      SELECT cast(c_custkey AS bigint) AS custkey, 
             c_address                 AS custAddress 
      FROM   cp.`tpch/customer.parquet` ) cust 
    SELECT DISTINCT l_linenumber, 
             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, 
ORDER BY  cust.custAddress, 

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

View raw message