input_partitions:描述一段SQL依赖的数据来源表分区,里面存储的是分区名的列表,如果整段SQL包含的所有表都是非分区表,则显示为空。 input_tables:描述一段SQL依赖的数据来源表,里面存储的是Hive表名的列表。 使用explain dependency查看SQL查询非分区普通表,在 hive cli 中输入以下命令: explain dependency select s_...
keys:分组的字段,如果没有分组,则没有此字段 outputColumnNames:聚合之后输出列名 Statistics: 表统计信息,包含分组聚合之后的数据条数,数据大小等 Reduce Output Operator:输出到reduce操作,常见属性: sort order:值为空 不排序;值为 + 正序排序,值为 - 倒序排序;值为 +- 排序的列为两列,第一列为正序,第二...
input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink 看完以上内容有什么感受,是不是感觉都...
input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0FetchOperator limit:-1Processor Tree: ListSink 2.2 执行计划最外层 stage dependencies: 各个...
(type: boolean) | Statistics: Num rows: 121336 Data size: 970689 Basic stats: COMPLETE Column stats: NONE | Select Operator | expressions: id (type: bigint) | outputColumnNames: _col0 || Statistics: Num rows: 121336 Data size: 970689 Basic stats: COMPLETE Column stats: NONE | Group ...
input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ...
Processor Tree: TableScan alias: emp Statistics: Num rows: 2 Data size: 659 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: empno (type: int), ename (type: string), job (type: string), mgr (type: int), hiredate (type: string), sal (type: double), comm (type...
| | 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: 10 | | Processor Tree: | ...
output format:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormatserde:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDeStage:Stage-0Fetch Operatorlimit:-1Processor Tree:ListSink 看完以上内容有什么感受,是不是感觉都看不懂,不要着急,下面将会详细讲解每个参数,相信你学完下面的内容之后再看 expla...
<Processor>/<id>The processor and processor ID used to read data into the SQL execution engine. A processor is a component that takes streams of input rows, processes them according to a specification, and outputs one stream of rows. For example, aTableReaderprocessor reads in data, and an...