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)
