[DRILL-4531] Query with filter and aggregate hangs in planning phase

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Jinfeng Ni
• Reviewer: Chun Chang
• Created: 23/Mar/16 22:17
• Updated: 18/May/16 23:16
• Resolved: 25/Mar/16 23:59

Description

For the following query,

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;

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.