[DRILL-1707] Regression: Mondrian query5843.q hangs

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Chun Chang
• Created: 13/Nov/14 23:18
• Updated: 03/Dec/14 01:02
• Resolved: 25/Nov/14 21:57

Description

#Thu Nov 13 13:47:45 EST 2014
git.commit.id.abbrev=fd54e71

The following Mondrian query hangs. It was working with previous release.

0: jdbc:drill:schema=dfs>
SELECT time_by_day.the_year AS c0,
time_by_day.quarter AS c1,
store.store_state AS c2,
FACT.warehouse_id AS c3,
Sum(FACT.warehouse_cost) AS m0
FROM time_by_day AS time_by_day,
(SELECT *
FROM inventory_fact_1997 AS FOOBAR) AS FACT,
store AS store
WHERE FACT.time_id = time_by_day.time_id
AND time_by_day.the_year = 1997
AND time_by_day.quarter = 'Q3'
AND FACT.store_id = store.store_id
AND store.store_state = 'WA'
AND FACT.warehouse_id = 2
GROUP BY time_by_day.the_year,
time_by_day.quarter,
store.store_state,
FACT.warehouse_id;

The drillbit handles the query seems active with around 100% CPU usage but the query never returns. The only log message found in drill bit.log is following:

2014-11-13 15:07:14,426 [UserServer-1] WARN o.a.d.exec.work.foreman.QueryStatus - Update running or pending query state : PENDING

Since this is a regression, marked as release blocker.