hive sql 执行计划实例2
来源:互联网 发布:php源码分析弱类型 编辑:程序博客网 时间:2024/06/08 07:37
hive> explain select a.type,a.news_id from hot_news a distribute by a.type sort by a.news_id;
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
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
OK
该sql的执行计划如下:
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)
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
0 0
- hive sql 执行计划实例2
- Hive sql 执行计划实例1
- hive sql执行计划
- hive sql执行计划
- hive sql执行计划树解析
- Hive SQL执行计划深度解析
- Hive SQL执行计划深度解析
- Hive SQL执行计划深度解析
- Hive SQL执行计划深度解析
- Hive SQL执行计划深度解析
- Hive SQL执行计划深度解析
- Hive 之 SQL执行计划深度解析
- HIVE SQL执行计划深度解析
- hive 执行计划
- hive执行计划EXPLAIN
- Hive SQL解析/执行计划生成流程分析
- Hive SQL解析/执行计划生成流程分析
- Hive SQL解析/执行计划生成流程分析
- android studio 学习遗留问题和学习总结
- sdut 3258 Square Number(山东声第六届ACM程序设计竞赛)
- 网站开发进阶(六)JSP两种声明变量的区别
- MacVim安装与配置
- [c] ★ 宏和函数的区别
- hive sql 执行计划实例2
- hdu 4640 Island and study-sister(最短路+状压dp)
- iOS之MBProgressHUD用法总结
- Spiral Matrix II
- JDBC-实现操作:增、删、改(DML)
- Spring中的字符编码过滤器
- TOJ 1547. To and Fro【栈和队列】
- Intellij IDE 使用集锦(更新中...)
- hdu 4642 Fliping game(博弈)