[
https://issues.apache.org/jira/browse/DRILL-1707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanifi Gunes updated DRILL-1707:
--------------------------------
Assignee: Aman Sinha (was: Hanifi Gunes)
> 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
> Assignee: Aman Sinha
> Priority: Blocker
> Fix For: 0.7.0
>
> Attachments: drillstack.txt
>
>
> #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)
