Uploaded image for project: '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

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: