Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1707

Regression: Mondrian query5843.q hangs

    XMLWordPrintableJSON

    Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              amansinha100 Aman Sinha
              Reporter:
              cchang@maprtech.com Chun Chang
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: