hive------几种hive优化方法

hive的优化

1.通过explain或者explain extended来查看执行计划。

explain
select * 
from u3;

//执行结果
------------------------------------------
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: u3
          Statistics: Num rows: 1 Data size: 43 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: id (type: bigint), name (type: string), sex (type: tinyint)
            outputColumnNames: _col0, _col1, _col2
            Statistics: Num rows: 1 Data size: 43 Basic stats: COMPLETE Column stats: NONE
            ListSink
Time taken: 0.457 seconds, Fetched: 17 row(s)

加上extended

explain extended
select * 
from u3;
---------------------------
 
ABSTRACT SYNTAX TREE:
  
TOK_QUERY
   TOK_FROM
      TOK_TABREF
         TOK_T