Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6901

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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
      

        Attachments

        1. HIVE-6901.patch
          1 kB
          Xuefu Zhang
        2. HIVE-6901.1.patch
          447 kB
          Xuefu Zhang
        3. HIVE-6901.2.patch
          446 kB
          Szehon Ho
        4. HIVE-6901.3.patch
          445 kB
          Xuefu Zhang
        5. HIVE-6901.4.patch
          494 kB
          Xuefu Zhang
        6. HIVE-6901.5.patch
          536 kB
          Xuefu Zhang
        7. HIVE-6901.6.patch
          563 kB
          Xuefu Zhang
        8. HIVE-6901.7.patch
          557 kB
          Xuefu Zhang
        9. HIVE-6901.8.patch
          621 kB
          Xuefu Zhang
        10. HIVE-6901.9.patch
          557 kB
          Xuefu Zhang
        11. HIVE-6109.10.patch
          529 kB
          Xuefu Zhang

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: