Hive
  1. Hive
  2. HIVE-6901

Explain plan doesn't show operator tree for the fetch operator

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 0.12.0
    • Fix Version/s: 0.14.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      Explaining a simple select query that involves a MR phase doesn't show processor tree for the fetch operator.

      hive> explain select d from test;
      OK
      STAGE DEPENDENCIES:
        Stage-1 is a root stage
        Stage-0 is a root stage
      
      STAGE PLANS:
        Stage: Stage-1
          Map Reduce
            Map Operator Tree:
      ...
        Stage: Stage-0
          Fetch Operator
            limit: -1
      

      It would be nice if the operator tree is shown even if there is only one node.

      Please note that in local execution, the operator tree is complete:

      hive> explain select * from test;
      OK
      STAGE DEPENDENCIES:
        Stage-0 is a root stage
      
      STAGE PLANS:
        Stage: Stage-0
          Fetch Operator
            limit: -1
            Processor Tree:
              TableScan
                alias: test
                Statistics: Num rows: 8 Data size: 34 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: d (type: int)
                  outputColumnNames: _col0
                  Statistics: Num rows: 8 Data size: 34 Basic stats: COMPLETE Column stats: NONE
                  ListSink
      
      1. HIVE-6901.patch
        1 kB
        Xuefu Zhang
      2. HIVE-6901.9.patch
        557 kB
        Xuefu Zhang
      3. HIVE-6901.8.patch
        621 kB
        Xuefu Zhang
      4. HIVE-6901.7.patch
        557 kB
        Xuefu Zhang
      5. HIVE-6901.6.patch
        563 kB
        Xuefu Zhang
      6. HIVE-6901.5.patch
        536 kB
        Xuefu Zhang
      7. HIVE-6901.4.patch
        494 kB
        Xuefu Zhang
      8. HIVE-6901.3.patch
        445 kB
        Xuefu Zhang
      9. HIVE-6901.2.patch
        446 kB
        Szehon Ho
      10. HIVE-6901.1.patch
        447 kB
        Xuefu Zhang
      11. HIVE-6109.10.patch
        529 kB
        Xuefu Zhang

        Issue Links

          Activity

            People

            • Assignee:
              Xuefu Zhang
              Reporter:
              Xuefu Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development