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

set NO_EXCHANGES=true did not have any effect

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.4.0
    • None
    • None

    Description

      0: jdbc:drill:schema=dfs> alter session set NO_EXCHANGES=true;
      ----------------------+

      ok summary

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

      true disabled exchanges.

      ----------------------+
      1 row selected (0.016 seconds)

      The explain plan for still shows we hash to random exchange:
      0: jdbc:drill:schema=dfs> explain plan for select cast(customer.country as varchar(20)) as c0 from customer as customer where UPPER(cast(customer.country as varchar(20))) = UPPER('USA') group by cast(customer.country as varchar(20));
      ----------------------+

      text json

      ----------------------+
      ....

      },

      { "pop" : "hash-to-random-exchange", "@id" : 5, "child" : 4, "expr" : "hash(`c0`) " }

      , {

      Attachments

        Activity

          People

            Unassigned Unassigned
            cchang@maprtech.com Chun Chang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: