[jira] [Created] (DRILL-1707) Regression: Mondrian query5843.q hangs

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-1707:
---------------------------------

             Summary: Regression: Mondrian query5843.q hangs
                 Key: DRILL-1707
                 URL: https://issues.apache.org/jira/browse/DRILL-1707
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.7.0
            Reporter: Chun Chang
            Priority: Blocker


#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.



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