http://git-wip-us.apache.org/repos/asf/hive/blob/aed21d0b/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out
b/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out
index d9e701a..ca07200 100644
--- a/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_inner_join.q.out
@@ -32,16 +32,12 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__2
POSTHOOK: Output: default@orc_table_2a
POSTHOOK: Lineage: orc_table_2a.c EXPRESSION
[(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.a from orc_table_2a t2 join orc_table_1a t1 on t1.a = t2.c where
t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.a from orc_table_2a t2 join orc_table_1a t1 on t1.a = t2.c where
t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -59,23 +55,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: c (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -83,13 +68,6 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0]
- className: VectorMapJoinInnerBigOnlyLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [0]
outputColumnNames: _col1
input vertices:
1 Map 2
@@ -97,16 +75,9 @@ STAGE PLANS:
Select Operator
expressions: _col1 (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -114,66 +85,25 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 1
- includeColumns: [0]
- dataColumns: c:int
- partitionColumnCount: 0
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: a (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 4 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 4 Basic stats:
COMPLETE Column stats: NONE
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 1
- includeColumns: [0]
- dataColumns: a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -192,16 +122,12 @@ POSTHOOK: Input: default@orc_table_1a
POSTHOOK: Input: default@orc_table_2a
#### A masked pattern was here ####
3
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t2.c from orc_table_2a t2 left semi join orc_table_1a t1 on t1.a = t2.c
where t2.c > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t2.c from orc_table_2a t2 left semi join orc_table_1a t1 on t1.a = t2.c
where t2.c > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -219,23 +145,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: c (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -243,23 +158,12 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col0 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0]
- bigTableValueColumns: [0]
- className: VectorMapJoinLeftSemiLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [0]
outputColumnNames: _col0
input vertices:
1 Map 2
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 3 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -267,49 +171,19 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 1
- includeColumns: [0]
- dataColumns: c:int
- partitionColumnCount: 0
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE
Column stats: NONE
Select Operator
expressions: a (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 4 Basic stats:
COMPLETE Column stats: NONE
Group By Operator
- Group By Vectorization:
- className: VectorGroupByOperator
- vectorOutput: true
- keyExpressions: col 0
- native: false
- projectedOutputColumns: []
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
@@ -318,26 +192,9 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 4 Basic stats:
COMPLETE Column stats: NONE
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 1
- includeColumns: [0]
- dataColumns: a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -392,16 +249,12 @@ POSTHOOK: Input: default@values__tmp__table__4
POSTHOOK: Output: default@orc_table_2b
POSTHOOK: Lineage: orc_table_2b.c EXPRESSION
[(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
POSTHOOK: Lineage: orc_table_2b.v2 SIMPLE
[(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2,
type:string, comment:), ]
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.v1, t1.a from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c
where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.v1, t1.a from orc_table_2b t2 join orc_table_1b t1 on t1.a = t2.c
where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -419,23 +272,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int)
outputColumnNames: _col0
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -443,14 +285,6 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col1 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [2, 0]
- smallTableMapping: [2]
outputColumnNames: _col1, _col2
input vertices:
1 Map 2
@@ -458,16 +292,9 @@ STAGE PLANS:
Select Operator
expressions: _col1 (type: string), _col2 (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [2, 0]
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -475,68 +302,26 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -555,16 +340,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
three 3
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.v1, t1.a, t2.c, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on
t1.a = t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.v1, t1.a, t2.c, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on
t1.a = t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -582,71 +363,32 @@ STAGE PLANS:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Map 2
Map Operator Tree:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -654,24 +396,12 @@ STAGE PLANS:
keys:
0 _col1 (type: int)
1 _col0 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [0, 1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [2, 0, 0, 1]
- smallTableMapping: [2]
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
0 Map 1
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -679,20 +409,6 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Stage: Stage-0
Fetch Operator
@@ -711,16 +427,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
three 3 3 THREE
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.v1, t1.a*2, t2.c*5, t2.v2 from orc_table_2b t2 join orc_table_1b t1
on t1.a = t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.v1, t1.a*2, t2.c*5, t2.v2 from orc_table_2b t2 join orc_table_1b t1
on t1.a = t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -738,23 +450,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -762,15 +463,6 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col1 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [0, 1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [0, 1, 2, 0]
- smallTableMapping: [2]
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
1 Map 2
@@ -778,17 +470,9 @@ STAGE PLANS:
Select Operator
expressions: _col2 (type: string), (_col3 * 2)
(type: int), (_col0 * 5) (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [2, 3, 4, 1]
- selectExpressions: LongColMultiplyLongScalar(col
0, val 2) -> 3:long, LongColMultiplyLongScalar(col 0, val 5) -> 4:long
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -796,68 +480,26 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String, bigint, bigint
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -876,16 +518,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
three 6 15 THREE
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.v1, t2.v2, t2.c from orc_table_2b t2 join orc_table_1b t1 on t1.a =
t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.v1, t2.v2, t2.c from orc_table_2b t2 join orc_table_1b t1 on t1.a =
t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -903,23 +541,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -927,15 +554,6 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col1 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [0, 1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [0, 1, 2]
- smallTableMapping: [2]
outputColumnNames: _col0, _col1, _col2
input vertices:
1 Map 2
@@ -943,16 +561,9 @@ STAGE PLANS:
Select Operator
expressions: _col2 (type: string), _col1 (type:
string), _col0 (type: int)
outputColumnNames: _col0, _col1, _col2
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [2, 1, 0]
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -960,68 +571,26 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -1040,16 +609,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
three THREE 3
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.a, t1.v1, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a =
t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.a, t1.v1, t2.v2 from orc_table_2b t2 join orc_table_1b t1 on t1.a =
t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1067,23 +632,12 @@ STAGE PLANS:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -1091,15 +645,6 @@ STAGE PLANS:
keys:
0 _col0 (type: int)
1 _col1 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [1, 2, 0]
- smallTableMapping: [2]
outputColumnNames: _col1, _col2, _col3
input vertices:
1 Map 2
@@ -1107,16 +652,9 @@ STAGE PLANS:
Select Operator
expressions: _col3 (type: int), _col2 (type:
string), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 2, 1]
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1124,68 +662,26 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Map 2
Map Operator Tree:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Stage: Stage-0
Fetch Operator
@@ -1204,16 +700,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
3 three THREE
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.v1, t2.v2, t2.c from orc_table_1b t1 join orc_table_2b t2 on t1.a =
t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.v1, t2.v2, t2.c from orc_table_1b t1 join orc_table_2b t2 on t1.a =
t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1231,71 +723,32 @@ STAGE PLANS:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Map 2
Map Operator Tree:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -1303,15 +756,6 @@ STAGE PLANS:
keys:
0 _col1 (type: int)
1 _col0 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [0, 1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [2, 0, 1]
- smallTableMapping: [2]
outputColumnNames: _col0, _col2, _col3
input vertices:
0 Map 1
@@ -1319,16 +763,9 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col3 (type:
string), _col2 (type: int)
outputColumnNames: _col0, _col1, _col2
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [2, 1, 0]
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1336,20 +773,6 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Stage: Stage-0
Fetch Operator
@@ -1368,16 +791,12 @@ POSTHOOK: Input: default@orc_table_1b
POSTHOOK: Input: default@orc_table_2b
#### A masked pattern was here ####
three THREE 3
-PREHOOK: query: explain vectorization detail
+PREHOOK: query: explain
select t1.a, t1.v1, t2.v2 from orc_table_1b t1 join orc_table_2b t2 on t1.a =
t2.c where t1.a > 2
PREHOOK: type: QUERY
-POSTHOOK: query: explain vectorization detail
+POSTHOOK: query: explain
select t1.a, t1.v1, t2.v2 from orc_table_1b t1 join orc_table_2b t2 on t1.a =
t2.c where t1.a > 2
POSTHOOK: type: QUERY
-PLAN VECTORIZATION:
- enabled: true
- enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1395,71 +814,32 @@ STAGE PLANS:
TableScan
alias: t1
Statistics: Num rows: 4 Data size: 364 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 1, val 2) -> boolean
predicate: (a > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: v1 (type: string), a (type: int)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Reduce Sink Vectorization:
- className: VectorReduceSinkLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, Not ACID UPDATE or DELETE IS true, No buckets IS
true, No TopN IS true, Uniform Hash IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: true
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: v1:string, a:int
- partitionColumnCount: 0
Map 2
Map Operator Tree:
TableScan
alias: t2
Statistics: Num rows: 5 Data size: 456 Basic stats: COMPLETE
Column stats: NONE
- TableScan Vectorization:
- native: true
- projectedOutputColumns: [0, 1]
Filter Operator
- Filter Vectorization:
- className: VectorFilterOperator
- native: true
- predicateExpression:
FilterLongColGreaterLongScalar(col 0, val 2) -> boolean
predicate: (c > 2) (type: boolean)
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Select Operator
expressions: c (type: int), v2 (type: string)
outputColumnNames: _col0, _col1
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 1]
Statistics: Num rows: 1 Data size: 91 Basic stats:
COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -1467,15 +847,6 @@ STAGE PLANS:
keys:
0 _col1 (type: int)
1 _col0 (type: int)
- Map Join Vectorization:
- bigTableKeyColumns: [0]
- bigTableRetainedColumns: [0, 1]
- bigTableValueColumns: [1]
- className: VectorMapJoinInnerLongOperator
- native: true
- nativeConditionsMet:
hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS
true, Supports Key Types IS true, Not empty key IS true, When Fast Hash Table,
then requires no Hybrid Hash Join IS true, Small table vectorizes IS true
- projectedOutputColumns: [2, 0, 1]
- smallTableMapping: [2]
outputColumnNames: _col0, _col1, _col3
input vertices:
0 Map 1
@@ -1483,16 +854,9 @@ STAGE PLANS:
Select Operator
expressions: _col1 (type: int), _col0 (type:
string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumns: [0, 2, 1]
Statistics: Num rows: 1 Data size: 100 Basic stats:
COMPLETE Column stats: NONE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
Statistics: Num rows: 1 Data size: 100 Basic
stats: COMPLETE Column stats: NONE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -1500,20 +864,6 @@ STAGE PLANS:
serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized, llap
LLAP IO: all inputs
- Map Vectorization:
- enabled: true
- enabledConditionsMet:
hive.vectorized.use.vectorized.input.format IS true
- groupByVectorOutput: true
- inputFileFormats:
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 2
- includeColumns: [0, 1]
- dataColumns: c:int, v2:string
- partitionColumnCount: 0
- scratchColumnTypeNames: String
Stage: Stage-0
Fetch Operator
