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

Wrong result for aggregate query with filter on SF100

    XMLWordPrintableJSON

    Details

      Description

      Wrong result on TPCH sf100:

      0: jdbc:drill:zk=10.10.103.32:5181> select max(l_suppkey) from lineitem where l_suppkey = 3872;
      +------------+
      |   EXPR$0   |
      +------------+
      | 991683     |
      +------------+
      1 row selected
      

      Plan looks correct:

      +------------+------------+
      |    text    |    json    |
      +------------+------------+
      | 00-00    Screen
      00-01      StreamAgg(group=[{}], EXPR$0=[MAX($0)])
      00-02        UnionExchange
      01-01          StreamAgg(group=[{}], EXPR$0=[MAX($0)])
      01-02            Filter(condition=[=($0, 3872)])
      01-03              Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/data/parquet/tpch/scale100/lineitem]], selectionRoot=/data/parquet/tpch/scale100/lineitem, numFiles=1, columns=[`l_suppkey`]]])
      

        Attachments

        1. DRILL-3069.patch
          5 kB
          Mehant Baid

          Activity

            People

            • Assignee:
              sphillips Steven Phillips
              Reporter:
              amansinha100 Aman Sinha
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: