Apache Drill
  1. Apache Drill
  2. DRILL-1183

TPCH query 14 on top of text files is resulting in a batch read error

    Details

      Description

      git.commit.id.abbrev=e5c2da0

      The below query is resulting in an error

      select
      100.00 * sum(case
      when p.p_type like 'PROMO%'
      then l.l_extendedprice * (1 - l.l_discount)
      else l.l_discount
      end) / sum(l.l_extendedprice * (1 - l.l_discount)) as promo_revenue
      from
      lineitem l,
      part p
      where
      l.l_partkey = p.p_partkey
      and l.l_shipdate >= date '1994-08-01'
      and l.l_shipdate < date '1994-08-01' + interval '1' month

      message: "Failure while running fragment. < IllegalStateException:[ You tried to do a batch data read operation when you were in a state of STOP. You can only do this type of operation when you are in a state of OK or OK_NEW_SCHEMA.

      However the query runs when we get rid of the last 2 filter conditions, the query runs. I attached the views used on top of text files along with the error log

      1. error.log
        6 kB
        Rahul Challapalli
      2. views.txt
        2 kB
        Rahul Challapalli

        Activity

        Rahul Challapalli created issue -
        Hide
        Rahul Challapalli added a comment -

        Let me know if you need more information.

        Show
        Rahul Challapalli added a comment - Let me know if you need more information.
        Rahul Challapalli made changes -
        Field Original Value New Value
        Attachment error.log [ 12657477 ]
        Attachment views.txt [ 12657478 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Timothy Chen made changes -
        Assignee Timothy Chen [ tnachen ]
        Hide
        Timothy Chen added a comment -

        I tried running the tpch14 from TestDistributedQuery and seems to pass, is this still a issue?

        Show
        Timothy Chen added a comment - I tried running the tpch14 from TestDistributedQuery and seems to pass, is this still a issue?
        Hide
        Rahul Challapalli added a comment -

        I believe this has been fixed with other another issue. I will validate and
        get back to you

        Show
        Rahul Challapalli added a comment - I believe this has been fixed with other another issue. I will validate and get back to you
        Jacques Nadeau made changes -
        Fix Version/s 0.5.0 [ 12324880 ]
        Fix Version/s 0.4.0 [ 12324963 ]
        Jacques Nadeau made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12877407 ] Drill workflow [ 12933813 ]
        Hide
        Rahul Challapalli added a comment -

        Verified! Below is the test case

        Functional/Passing/tpch0.01/text_double/14.q

        Show
        Rahul Challapalli added a comment - Verified! Below is the test case Functional/Passing/tpch0.01/text_double/14.q
        Rahul Challapalli made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        21d 20h 39m 1 Jacques Nadeau 14/Aug/14 20:29
        Resolved Resolved Closed Closed
        260d 2h 30m 1 Rahul Challapalli 01/May/15 23:00

          People

          • Assignee:
            Timothy Chen
            Reporter:
            Rahul Challapalli
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development