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

Disable ProducerConsumer

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.7.0
    • None
    • None

    Description

      This operator causes incorrect query results:

      0: jdbc:drill:schema=dfs.par100> alter session set `planner.add_producer_consumer` = true;
      ----------------------+

      ok summary

      ----------------------+

      true planner.add_producer_consumer updated.

      ----------------------+
      1 row selected (0.053 seconds)
      0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem;
      ------------

      EXPR$0

      ------------

      600037902

      ------------
      1 row selected (0.212 seconds)
      0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem where 1 = 1;
      ------------

      EXPR$0

      ------------

      569114624

      ------------
      1 row selected (2.163 seconds)
      0: jdbc:drill:schema=dfs.par100> alter session set `planner.add_producer_consumer` = false;
      ----------------------+

      ok summary

      ----------------------+

      true planner.add_producer_consumer updated.

      ----------------------+
      1 row selected (0.046 seconds)
      0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem where 1 = 1;
      ------------

      EXPR$0

      ------------

      600037902

      ------------
      1 row selected (2.657 seconds)

      As an immediate fix, we should disable this operator.

      Attachments

        1. DRILL-1617.patch
          1 kB
          Steven Phillips

        Activity

          People

            Unassigned Unassigned
            sphillips Steven Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: