hive sql 执行计划实例2

hive> explain select a.type,a.news_id from hot_news a distribute by a.type sort by a.news_id;

OK

该sql的执行计划如下：

STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1


STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: a
            Statistics: Num rows: 2767 Data size: 553707 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: type (type: string), news_id (type: string)
              outputColumnNames: _col0, _col1
              Statistics: Num rows: 2767 Data size: 553707 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col1 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
                Statistics: Num rows: 2767 Data size: 553707 Basic stats: COMPLETE Column stats: NONE

                value expressions: _col0 (type: string)

      Reduce Operator Tree:
        Select Operator
          expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: string)
          outputColumnNames: _col0, _col1
          Statistics: Num rows: 2767 Data size: 553707 Basic stats: COMPLETE Column stats: NONE
          File Output Operator
            compressed: false
            Statistics: Num rows: 2767 Data size: 553707 Basic stats: COMPLETE Column stats: NONE
            table:
                input format: org.apache.hadoop.mapred.TextInputFormat
                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe


  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink