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

The query with "SELECT *" with "ORDER BY" clause and `planner.slice_target`=1 doesn't preserve column order

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: 1.12.0
    • Component/s: None
    • Labels:

      Description

      Columns ordering doesn't preserve for the star query with sorting when this is planned into multiple fragments.
      Repro steps:
      1)

      alter session set `planner.slice_target`=1;

      2) ORDER BY clause in the query.

      Scenarios:

      0: jdbc:drill:zk=local> alter session reset `planner.slice_target`;
      +-------+--------------------------------+
      |  ok   |            summary             |
      +-------+--------------------------------+
      | true  | planner.slice_target updated.  |
      +-------+--------------------------------+
      1 row selected (0.082 seconds)
      0: jdbc:drill:zk=local> select * from cp.`tpch/nation.parquet` order by n_name limit 1;
      +--------------+----------+--------------+------------------------------------------------------+
      | n_nationkey  |  n_name  | n_regionkey  |                      n_comment                       |
      +--------------+----------+--------------+------------------------------------------------------+
      | 0            | ALGERIA  | 0            |  haggle. carefully final deposits detect slyly agai  |
      +--------------+----------+--------------+------------------------------------------------------+
      1 row selected (0.141 seconds)
      0: jdbc:drill:zk=local> alter session set `planner.slice_target`=1;
      +-------+--------------------------------+
      |  ok   |            summary             |
      +-------+--------------------------------+
      | true  | planner.slice_target updated.  |
      +-------+--------------------------------+
      1 row selected (0.091 seconds)
      0: jdbc:drill:zk=local> select * from cp.`tpch/nation.parquet` order by n_name limit 1;
      +------------------------------------------------------+----------+--------------+--------------+
      |                      n_comment                       |  n_name  | n_nationkey  | n_regionkey  |
      +------------------------------------------------------+----------+--------------+--------------+
      |  haggle. carefully final deposits detect slyly agai  | ALGERIA  | 0            | 0            |
      +------------------------------------------------------+----------+--------------+--------------+
      1 row selected (0.201 seconds)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vitalii Vitalii Diravka
                Reporter:
                prasadns14 Prasad Nagaraj Subramanya
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: