http://git-wip-us.apache.org/repos/asf/hive/blob/9b376a7b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
index a74023f..0c47829 100644
--- a/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_interval_2.q.out
@@ -126,7 +126,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 348 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Select Operator
@@ -137,7 +137,7 @@ STAGE PLANS:
native: true
projectedOutputColumnNums: [2, 9, 10, 11, 12, 13, 14,
15, 16, 8, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31]
selectExpressions: LongColEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 2:string) -> 8:interval_year_month) ->
9:boolean, LongColLessEqualLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 2:string) ->
8:interval_year_month) -> 10:boolean, LongColLessEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 3:string) -> 8:interval_year_month) ->
11:boolean, LongColLessLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 3:string) ->
8:interval_year_mo
nth) -> 12:boolean, LongColGreaterEqualLongColumn(col 7:interval_year_month,
col 8:interval_year_month)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month, CastStringToIntervalYearMonth(col 2:string)
-> 8:interval_year_month) -> 13:boolean, LongColGreaterEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 3:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 2:string) -> 8:interval_year_month) ->
14:boolean, LongColGreaterLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 2:string) ->
8:interval_year_month) -> 15:boolean, LongColNotEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 3:string) -> 8:interval_year_month) -> 16
:boolean, IntervalYearMonthColEqualIntervalYearMonthScalar(col
7:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month) -> 8:boolean,
IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 7:interval_year_month,
val 14)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 17:boolean,
IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 7:interval_year_month,
val 15)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 18:boolean,
IntervalYearMonthColLessIntervalYearMonthScalar(col 7:interval_year_month, val
15)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 19:boolean,
IntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col
7:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month) -> 20:boolean,
IntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col 7:interval_year_mon
th, val 14)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 21:boolean,
IntervalYearMonthColGreaterIntervalYearMonthScalar(col 7:interval_year_month,
val 14)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 22:boolean,
IntervalYearMonthColNotEqualIntervalYearMonthScalar(col 7:interval_year_month,
val 15)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 23:boolean,
IntervalYearMonthScalarEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 24:boolean,
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 25:boolean,
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_
year_month) -> 26:boolean,
IntervalYearMonthScalarLessIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 27:boolean,
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 28:boolean,
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 15, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 29:boolean,
IntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 15, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 30:boolean,
IntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 31:boolean
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 366 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -145,7 +145,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 366 Basic stats:
COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: boolean), _col2 (type:
boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean),
_col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean), _col9
(type: boolean), _col10 (type: boolean), _col11 (type: boolean), _col12 (type:
boolean), _col13 (type: boolean), _col14 (type: boolean), _col15 (type:
boolean), _col16 (type: boolean), _col17 (type: boolean), _col18 (type:
boolean), _col19 (type: boolean), _col20 (type: boolean), _col21 (type:
boolean), _col22 (type: boolean), _col23 (type: boolean), _col24 (type: boolean)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -174,13 +174,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24]
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 366 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 366 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -332,7 +332,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 348 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Select Operator
@@ -343,7 +343,7 @@ STAGE PLANS:
native: true
projectedOutputColumnNums: [2, 9, 10, 11, 12, 13, 8,
14, 15, 16, 17, 18, 19, 20, 21, 22]
selectExpressions: LongColNotEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 2:string) -> 8:interval_year_month) ->
9:boolean, LongColGreaterEqualLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 3:string) ->
8:interval_year_month) -> 10:boolean, LongColGreaterLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 3:string) -> 8:interval_year_month) ->
11:boolean, LongColLessEqualLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 2:string) -> 8:interva
l_year_month) -> 12:boolean, LongColLessLongColumn(col 7:interval_year_month,
col 8:interval_year_month)(children: CastStringToIntervalYearMonth(col
3:string) -> 7:interval_year_month, CastStringToIntervalYearMonth(col 2:string)
-> 8:interval_year_month) -> 13:boolean,
IntervalYearMonthColNotEqualIntervalYearMonthScalar(col 7:interval_year_month,
val 14)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:boolean,
IntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col
7:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month) -> 14:boolean,
IntervalYearMonthColGreaterIntervalYearMonthScalar(col 7:interval_year_month,
val 15)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 15:boolean,
IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 7:interval_year_month,
val 14)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 16:boole
an, IntervalYearMonthColLessIntervalYearMonthScalar(col 7:interval_year_month,
val 14)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 17:boolean,
IntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 18:boolean,
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 19:boolean,
IntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month) -> 20:boolean,
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 15, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 21:boolean,
IntervalYearMonthScalarLessIntervalYearMonthColumn(val 15, col 7:interv
al_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 22:boolean
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 318 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -351,7 +351,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 318 Basic stats:
COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: boolean), _col2 (type:
boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean),
_col7 (type: boolean), _col8 (type: boolean), _col9 (type: boolean), _col10
(type: boolean), _col11 (type: boolean), _col13 (type: boolean), _col14 (type:
boolean), _col15 (type: boolean), _col16 (type: boolean), _col17 (type: boolean)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -380,13 +380,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 1, 6, 7, 8,
9, 10, 6, 11, 12, 13, 14, 15, 11]
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 318 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 318 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -538,7 +538,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 364 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Select Operator
@@ -549,7 +549,7 @@ STAGE PLANS:
native: true
projectedOutputColumnNums: [4, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32]
selectExpressions:
IntervalDayTimeColEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 9:boolean,
IntervalDayTimeColLessEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 10:boolean,
IntervalDayTimeColLessEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 5:string) ->
8:interval_day_time) -> 11:boolean,
IntervalDayTimeColLessIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalD
ayTime(col 5:string) -> 8:interval_day_time) -> 12:boolean,
IntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 7:interval_day_time,
col 8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 13:boolean,
IntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 7:interval_day_time,
col 8:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 14:boolean,
IntervalDayTimeColGreaterIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 15:boolean,
IntervalDayTimeColNotEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_d
ay_time, CastStringToIntervalDayTime(col 5:string) -> 8:interval_day_time) ->
16:boolean, IntervalDayTimeColEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
17:boolean, IntervalDayTimeColLessEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
18:boolean, IntervalDayTimeColLessEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:05.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
19:boolean, IntervalDayTimeColLessIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:05.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
20:boolean, IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 4:strin
g) -> 7:interval_day_time) -> 21:boolean,
IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 7:interval_day_time,
val 1 02:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string)
-> 7:interval_day_time) -> 22:boolean,
IntervalDayTimeColGreaterIntervalDayTimeScalar(col 7:interval_day_time, val 1
02:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time) -> 23:boolean,
IntervalDayTimeColNotEqualIntervalDayTimeScalar(col 7:interval_day_time, val 1
02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 24:boolean,
IntervalDayTimeScalarEqualIntervalDayTimeColumn(val 1 02:03:04.000000000, col
7:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 25:boolean,
IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1 02:03:04.000000000,
col 7:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 26:boolean
, IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
27:boolean, IntervalDayTimeScalarLessIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
28:boolean, IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
29:boolean, IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1
02:03:05.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
30:boolean, IntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1
02:03:05.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
31:boolean, IntervalDayTimeScalarNotEq
ualIntervalDayTimeColumn(val 1 02:03:04.000000000, col
7:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time) -> 32:boolean
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 374 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -557,7 +557,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 374 Basic stats:
COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: boolean), _col2 (type:
boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean),
_col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean), _col9
(type: boolean), _col10 (type: boolean), _col11 (type: boolean), _col12 (type:
boolean), _col13 (type: boolean), _col14 (type: boolean), _col15 (type:
boolean), _col16 (type: boolean), _col17 (type: boolean), _col18 (type:
boolean), _col19 (type: boolean), _col20 (type: boolean), _col21 (type:
boolean), _col22 (type: boolean), _col23 (type: boolean), _col24 (type: boolean)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -586,13 +586,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24]
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 374 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 374 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -744,7 +744,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: vector_interval_2
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 364 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Select Operator
@@ -755,7 +755,7 @@ STAGE PLANS:
native: true
projectedOutputColumnNums: [4, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20, 21, 22, 23]
selectExpressions:
IntervalDayTimeColNotEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 9:boolean,
IntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 7:interval_day_time,
col 8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 5:string) ->
8:interval_day_time) -> 10:boolean,
IntervalDayTimeColGreaterIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 5:string) ->
8:interval_day_time) -> 11:boolean,
IntervalDayTimeColLessEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time, CastStringTo
IntervalDayTime(col 4:string) -> 8:interval_day_time) -> 12:boolean,
IntervalDayTimeColLessIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time) -> 13:boolean,
IntervalDayTimeColNotEqualIntervalDayTimeScalar(col 7:interval_day_time, val 1
02:03:04.000000000)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 14:boolean,
IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 7:interval_day_time,
val 1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string)
-> 7:interval_day_time) -> 15:boolean,
IntervalDayTimeColGreaterIntervalDayTimeScalar(col 7:interval_day_time, val 1
02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 16:boolean,
IntervalDayTimeColLessEqualIntervalDayTimeScalar(col 7:interval_day_time, val 1
02:03:04.000000000)(chil
dren: CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
17:boolean, IntervalDayTimeColLessIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
18:boolean, IntervalDayTimeScalarNotEqualIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time) ->
19:boolean, IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
20:boolean, IntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time) ->
21:boolean, IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1
02:03:05.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(c
ol 4:string) -> 7:interval_day_time) -> 22:boolean,
IntervalDayTimeScalarLessIntervalDayTimeColumn(val 1 02:03:05.000000000, col
7:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time) -> 23:boolean
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 326 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -763,7 +763,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 2 Data size: 736 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 326 Basic stats:
COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: boolean), _col2 (type:
boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean),
_col7 (type: boolean), _col8 (type: boolean), _col9 (type: boolean), _col10
(type: boolean), _col11 (type: boolean), _col13 (type: boolean), _col14 (type:
boolean), _col15 (type: boolean), _col16 (type: boolean), _col17 (type: boolean)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -792,13 +792,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 1, 6, 7, 8,
9, 10, 6, 11, 12, 13, 14, 15, 11]
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 326 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 326 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -937,7 +937,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((CAST( str1 AS INTERVAL YEAR TO MONTH) = CAST(
str1 AS INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO MONTH) <>
CAST( str2 AS INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO
MONTH) <= CAST( str2 AS INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL
YEAR TO MONTH) < CAST( str2 AS INTERVAL YEAR TO MONTH)) and (CAST( str2 AS
INTERVAL YEAR TO MONTH) >= CAST( str1 AS INTERVAL YEAR TO MONTH)) and (CAST(
str2 AS INTERVAL YEAR TO MONTH) > CAST( str1 AS INTERVAL YEAR TO MONTH)) and
(CAST( str1 AS INTERVAL YEAR TO MONTH) = INTERVAL'1-2') and (CAST( str1 AS
INTERVAL YEAR TO MONTH) <> INTERVAL'1-3') and (CAST( str1 AS INTERVAL YEAR TO
MONTH) <= INTERVAL'1-3') and (CAST( str1 AS INTERVAL YEAR TO MONTH) <
INTERVAL'1-3') and (CAST( str2 AS INTERVAL YEAR TO MONTH) >= INTERVAL'1-2') and
(CAST( str2 AS INTERVAL YEAR TO MONTH) > INTERVAL'1-2') and (INTERVAL'1-2' =
CAST( str1 AS INTERVAL YEAR TO MONTH)) and (INTERVAL'1-2' <> CAST( str2 AS INTE
RVAL YEAR TO MONTH)) and (INTERVAL'1-2' <= CAST( str2 AS INTERVAL YEAR TO
MONTH)) and (INTERVAL'1-2' < CAST( str2 AS INTERVAL YEAR TO MONTH)) and
(INTERVAL'1-3' >= CAST( str1 AS INTERVAL YEAR TO MONTH)) and (INTERVAL'1-3' >
CAST( str1 AS INTERVAL YEAR TO MONTH))) (type: boolean)
- Statistics: Num rows: 2 Data size: 816 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 428 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -946,7 +946,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterLongColEqualLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 2:string) ->
8:interval_year_month), FilterLongColNotEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 2:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 3:string) -> 8:interval_year_month),
FilterLongColLessEqualLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 3:string) ->
8:interval_year_month), FilterLongColLessLongColumn(col 7:interval_year_month,
col 8:interval_year_month)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month, CastStringToIntervalYearMonth(col 3:string)
-> 8:inte
rval_year_month), FilterLongColGreaterEqualLongColumn(col
7:interval_year_month, col 8:interval_year_month)(children:
CastStringToIntervalYearMonth(col 3:string) -> 7:interval_year_month,
CastStringToIntervalYearMonth(col 2:string) -> 8:interval_year_month),
FilterLongColGreaterLongColumn(col 7:interval_year_month, col
8:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month, CastStringToIntervalYearMonth(col 2:string) ->
8:interval_year_month),
FilterIntervalYearMonthColEqualIntervalYearMonthScalar(col
7:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month),
FilterIntervalYearMonthColNotEqualIntervalYearMonthScalar(col
7:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month),
FilterIntervalYearMonthColLessEqualIntervalYearMonthScalar(col
7:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:inte
rval_year_month), FilterIntervalYearMonthColLessIntervalYearMonthScalar(col
7:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col
2:string) -> 7:interval_year_month),
FilterIntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col
7:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col
3:string) -> 7:interval_year_month),
FilterIntervalYearMonthColGreaterIntervalYearMonthScalar(col
7:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col
3:string) -> 7:interval_year_month),
FilterIntervalYearMonthScalarEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month),
FilterIntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month),
FilterIntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children:
CastStringToIntervalYearMonth(col 3:string) -> 7:interval_year_month),
FilterIntervalYearMonthScalarLessIntervalYearMonthColumn(val 14, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) ->
7:interval_year_month),
FilterIntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 15, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month),
FilterIntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 15, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month))
predicate: ((CAST( str1 AS INTERVAL YEAR TO MONTH) < CAST(
str2 AS INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO MONTH) <
INTERVAL'1-3') and (CAST( str1 AS INTERVAL YEAR TO MONTH) <= CAST( str2 AS
INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO MONTH) <=
INTERVAL'1-3') and (CAST( str1 AS INTERVAL YEAR TO MONTH) <> CAST( str2 AS
INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO MONTH) <>
INTERVAL'1-3') and (CAST( str1 AS INTERVAL YEAR TO MONTH) = CAST( str1 AS
INTERVAL YEAR TO MONTH)) and (CAST( str1 AS INTERVAL YEAR TO MONTH) =
INTERVAL'1-2') and (CAST( str2 AS INTERVAL YEAR TO MONTH) > CAST( str1 AS
INTERVAL YEAR TO MONTH)) and (CAST( str2 AS INTERVAL YEAR TO MONTH) >
INTERVAL'1-2') and (CAST( str2 AS INTERVAL YEAR TO MONTH) >= CAST( str1 AS
INTERVAL YEAR TO MONTH)) and (CAST( str2 AS INTERVAL YEAR TO MONTH) >=
INTERVAL'1-2') and (INTERVAL'1-2' < CAST( str2 AS INTERVAL YEAR TO MONTH)) and
(INTERVAL'1-2' <= CAST( str2 AS INT
ERVAL YEAR TO MONTH)) and (INTERVAL'1-2' <> CAST( str2 AS INTERVAL YEAR TO
MONTH)) and (INTERVAL'1-2' = CAST( str1 AS INTERVAL YEAR TO MONTH)) and
(INTERVAL'1-3' > CAST( str1 AS INTERVAL YEAR TO MONTH)) and (INTERVAL'1-3' >=
CAST( str1 AS INTERVAL YEAR TO MONTH))) (type: boolean)
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 214 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -954,7 +954,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -962,7 +962,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -990,13 +990,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 408 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 408 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1132,7 +1132,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((CAST( str3 AS INTERVAL DAY TO SECOND) = CAST(
str3 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL DAY TO SECOND) <>
CAST( str4 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL DAY TO
SECOND) <= CAST( str4 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL
DAY TO SECOND) < CAST( str4 AS INTERVAL DAY TO SECOND)) and (CAST( str4 AS
INTERVAL DAY TO SECOND) >= CAST( str3 AS INTERVAL DAY TO SECOND)) and (CAST(
str4 AS INTERVAL DAY TO SECOND) > CAST( str3 AS INTERVAL DAY TO SECOND)) and
(CAST( str3 AS INTERVAL DAY TO SECOND) = INTERVAL'1 02:03:04.000000000') and
(CAST( str3 AS INTERVAL DAY TO SECOND) <> INTERVAL'1 02:03:05.000000000') and
(CAST( str3 AS INTERVAL DAY TO SECOND) <= INTERVAL'1 02:03:05.000000000') and
(CAST( str3 AS INTERVAL DAY TO SECOND) < INTERVAL'1 02:03:05.000000000') and
(CAST( str4 AS INTERVAL DAY TO SECOND) >= INTERVAL'1 02:03:04.000000000') and
(CAST( str4 AS INTERVAL DAY TO SECOND) > INTERVAL'1 02:03:04.000000000'
) and (INTERVAL'1 02:03:04.000000000' = CAST( str3 AS INTERVAL DAY TO SECOND))
and (INTERVAL'1 02:03:04.000000000' <> CAST( str4 AS INTERVAL DAY TO SECOND))
and (INTERVAL'1 02:03:04.000000000' <= CAST( str4 AS INTERVAL DAY TO SECOND))
and (INTERVAL'1 02:03:04.000000000' < CAST( str4 AS INTERVAL DAY TO SECOND))
and (INTERVAL'1 02:03:05.000000000' >= CAST( str3 AS INTERVAL DAY TO SECOND))
and (INTERVAL'1 02:03:05.000000000' > CAST( str3 AS INTERVAL DAY TO SECOND)))
(type: boolean)
- Statistics: Num rows: 2 Data size: 816 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 444 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -1141,7 +1141,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterIntervalDayTimeColEqualIntervalDayTimeColumn(col 7:interval_day_time, col
8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time), FilterIntervalDayTimeColNotEqualIntervalDayTimeColumn(col
7:interval_day_time, col 8:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time,
CastStringToIntervalDayTime(col 5:string) -> 8:interval_day_time),
FilterIntervalDayTimeColLessEqualIntervalDayTimeColumn(col 7:interval_day_time,
col 8:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 5:string) ->
8:interval_day_time), FilterIntervalDayTimeColLessIntervalDayTimeColumn(col
7:interval_day_time, col 8:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time, CastStrin
gToIntervalDayTime(col 5:string) -> 8:interval_day_time),
FilterIntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col
7:interval_day_time, col 8:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time,
CastStringToIntervalDayTime(col 4:string) -> 8:interval_day_time),
FilterIntervalDayTimeColGreaterIntervalDayTimeColumn(col 7:interval_day_time,
col 8:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time, CastStringToIntervalDayTime(col 4:string) ->
8:interval_day_time), FilterIntervalDayTimeColEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time),
FilterIntervalDayTimeColNotEqualIntervalDayTimeScalar(col 7:interval_day_time,
val 1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string)
-> 7:interval_day_time),
FilterIntervalDayTimeColLessEqualIntervalDayTimeScalar(col 7:interval_day_time,
v
al 1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string)
-> 7:interval_day_time), FilterIntervalDayTimeColLessIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:05.000000000)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time),
FilterIntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col
7:interval_day_time, val 1 02:03:04.000000000)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time),
FilterIntervalDayTimeColGreaterIntervalDayTimeScalar(col 7:interval_day_time,
val 1 02:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string)
-> 7:interval_day_time),
FilterIntervalDayTimeScalarEqualIntervalDayTimeColumn(val 1 02:03:04.000000000,
col 7:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) ->
7:interval_day_time),
FilterIntervalDayTimeScalarNotEqualIntervalDayTimeColumn(val 1
02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:int
erval_day_time), FilterIntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val
1 02:03:04.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 5:string) -> 7:interval_day_time),
FilterIntervalDayTimeScalarLessIntervalDayTimeColumn(val 1 02:03:04.000000000,
col 7:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) ->
7:interval_day_time),
FilterIntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1
02:03:05.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time),
FilterIntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1
02:03:05.000000000, col 7:interval_day_time)(children:
CastStringToIntervalDayTime(col 4:string) -> 7:interval_day_time))
predicate: ((CAST( str3 AS INTERVAL DAY TO SECOND) < CAST(
str4 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL DAY TO SECOND) <
INTERVAL'1 02:03:05.000000000') and (CAST( str3 AS INTERVAL DAY TO SECOND) <=
CAST( str4 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL DAY TO
SECOND) <= INTERVAL'1 02:03:05.000000000') and (CAST( str3 AS INTERVAL DAY TO
SECOND) <> CAST( str4 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS INTERVAL
DAY TO SECOND) <> INTERVAL'1 02:03:05.000000000') and (CAST( str3 AS INTERVAL
DAY TO SECOND) = CAST( str3 AS INTERVAL DAY TO SECOND)) and (CAST( str3 AS
INTERVAL DAY TO SECOND) = INTERVAL'1 02:03:04.000000000') and (CAST( str4 AS
INTERVAL DAY TO SECOND) > CAST( str3 AS INTERVAL DAY TO SECOND)) and (CAST(
str4 AS INTERVAL DAY TO SECOND) > INTERVAL'1 02:03:04.000000000') and (CAST(
str4 AS INTERVAL DAY TO SECOND) >= CAST( str3 AS INTERVAL DAY TO SECOND)) and
(CAST( str4 AS INTERVAL DAY TO SECOND) >= INTERVAL'1 02:03:04.000000000
') and (INTERVAL'1 02:03:04.000000000' < CAST( str4 AS INTERVAL DAY TO
SECOND)) and (INTERVAL'1 02:03:04.000000000' <= CAST( str4 AS INTERVAL DAY TO
SECOND)) and (INTERVAL'1 02:03:04.000000000' <> CAST( str4 AS INTERVAL DAY TO
SECOND)) and (INTERVAL'1 02:03:04.000000000' = CAST( str3 AS INTERVAL DAY TO
SECOND)) and (INTERVAL'1 02:03:05.000000000' > CAST( str3 AS INTERVAL DAY TO
SECOND)) and (INTERVAL'1 02:03:05.000000000' >= CAST( str3 AS INTERVAL DAY TO
SECOND))) (type: boolean)
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 222 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -1149,7 +1149,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -1157,7 +1157,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 408 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -1185,13 +1185,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 408 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 408 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1317,7 +1317,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((DATE'2002-03-01' = (dt + CAST( str1 AS
INTERVAL YEAR TO MONTH))) and (DATE'2002-03-01' <= (dt + CAST( str1 AS INTERVAL
YEAR TO MONTH))) and (DATE'2002-03-01' >= (dt + CAST( str1 AS INTERVAL YEAR TO
MONTH))) and ((dt + CAST( str1 AS INTERVAL YEAR TO MONTH)) = DATE'2002-03-01')
and ((dt + CAST( str1 AS INTERVAL YEAR TO MONTH)) <= DATE'2002-03-01') and ((dt
+ CAST( str1 AS INTERVAL YEAR TO MONTH)) >= DATE'2002-03-01') and (dt <> (dt +
CAST( str1 AS INTERVAL YEAR TO MONTH))) and (DATE'2002-03-01' = (dt +
INTERVAL'1-2')) and (DATE'2002-03-01' <= (dt + INTERVAL'1-2')) and
(DATE'2002-03-01' >= (dt + INTERVAL'1-2')) and ((dt + INTERVAL'1-2') =
DATE'2002-03-01') and ((dt + INTERVAL'1-2') <= DATE'2002-03-01') and ((dt +
INTERVAL'1-2') >= DATE'2002-03-01') and (dt <> (dt + INTERVAL'1-2'))) (type:
boolean)
- Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 366 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -1326,7 +1326,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterDateScalarEqualDateColumn(val 11747, col 8:date)(children:
DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterDateScalarLessEqualDateColumn(val
11747, col 8:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterDateScalarGreaterEqualDateColumn(val
11747, col 8:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterDateColEqualDateScalar(col 8:date, val
11747)(children: DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:dat
e), FilterDateColLessEqualDateScalar(col 8:date, val 11747)(children:
DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterDateColGreaterEqualDateScalar(col
8:date, val 11747)(children: DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterLongColNotEqualLongColumn(col 1:date,
col 8:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, col
7:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) ->
7:interval_year_month) -> 8:date), FilterDateScalarEqualDateColumn(val 11747,
col 7:date)(children: DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) ->
7:date), FilterDateScalarLessEqualDateColumn(val 11747, col 7:date)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date),
FilterDateScalarGreaterEqualD
ateColumn(val 11747, col 7:date)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date),
FilterDateColEqualDateScalar(col 7:date, val 11747)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date),
FilterDateColLessEqualDateScalar(col 7:date, val 11747)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date),
FilterDateColGreaterEqualDateScalar(col 7:date, val 11747)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date),
FilterLongColNotEqualLongColumn(col 1:date, col 7:date)(children:
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 7:date))
predicate: (((dt + CAST( str1 AS INTERVAL YEAR TO MONTH))
<= DATE'2002-03-01') and ((dt + CAST( str1 AS INTERVAL YEAR TO MONTH)) =
DATE'2002-03-01') and ((dt + CAST( str1 AS INTERVAL YEAR TO MONTH)) >=
DATE'2002-03-01') and ((dt + INTERVAL'1-2') <= DATE'2002-03-01') and ((dt +
INTERVAL'1-2') = DATE'2002-03-01') and ((dt + INTERVAL'1-2') >=
DATE'2002-03-01') and (DATE'2002-03-01' <= (dt + CAST( str1 AS INTERVAL YEAR TO
MONTH))) and (DATE'2002-03-01' <= (dt + INTERVAL'1-2')) and (DATE'2002-03-01' =
(dt + CAST( str1 AS INTERVAL YEAR TO MONTH))) and (DATE'2002-03-01' = (dt +
INTERVAL'1-2')) and (DATE'2002-03-01' >= (dt + CAST( str1 AS INTERVAL YEAR TO
MONTH))) and (DATE'2002-03-01' >= (dt + INTERVAL'1-2')) and (dt <> (dt + CAST(
str1 AS INTERVAL YEAR TO MONTH))) and (dt <> (dt + INTERVAL'1-2'))) (type:
boolean)
- Statistics: Num rows: 1 Data size: 280 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 183 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -1334,7 +1334,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 280 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -1342,7 +1342,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 280 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -1370,13 +1370,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1502,7 +1502,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((TIMESTAMP'2002-03-01 01:02:03' = (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-02-01 01:02:03' < (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' > (ts + INTERVAL'1-2')) and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') <=
TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') <>
TIMESTAMP'2002-04-01 01:02:03') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03') and ((ts + INTERVAL'1-2') <
TIMESTAMP'2002-04-01 01:02:03') and (ts = (ts + INTERVAL'0-0')) and (ts <> (ts
+ INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts < (ts +
INTERVAL'1-0')) and (ts >= (ts - INTERVAL'1-0')) and (ts > (ts -
INTERVAL'1-0'))) (type: boolean)
- Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -1511,7 +1511,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2002-03-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampScalarLessEqualTimestampColumn(val
2002-03-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarGreaterEqualTimestampColumn(val 2002-03-01
01:02:03, col 7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2002-04-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-2) -> 7:timestamp), FilterTimestampScalarLessTimestampColumn(val
2002-02-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampScalarGreaterTim
estampColumn(val 2002-04-01 01:02:03, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColEqualTimestampScalar(col 7:timestamp, val
2002-03-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2002-03-01
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val
1-2) -> 7:timestamp), FilterTimestampColLessEqualTimestampScalar(col
7:timestamp, val 2002-03-01 01:02:03)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val
2002-04-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col
0:timestamp, val 1-2) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2002-02-01
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timest
amp, val 1-2) -> 7:timestamp), FilterTimestampColLessTimestampScalar(col
7:timestamp, val 2002-04-01 01:02:03)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) ->
7:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 0-0) -> 7:timestamp), FilterTimestampColNotEqualTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) ->
7:timestamp), FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp,
val 1-0) -> 7:timestamp), FilterTimestampColLessTimestampColumn(col
0:timestamp, col 7:timestamp)(children:
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) ->
7:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col 0:timestamp,
col 7:timestamp)(children: TimestampColSubtractIntervalYearMonthS
calar(col 0:timestamp, val 1-0) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalYearMonthScalar(col
0:timestamp, val 1-0) -> 7:timestamp))
predicate: (((ts + INTERVAL'1-2') < TIMESTAMP'2002-04-01
01:02:03') and ((ts + INTERVAL'1-2') <= TIMESTAMP'2002-03-01 01:02:03') and
((ts + INTERVAL'1-2') <> TIMESTAMP'2002-04-01 01:02:03') and ((ts +
INTERVAL'1-2') = TIMESTAMP'2002-03-01 01:02:03') and ((ts + INTERVAL'1-2') >
TIMESTAMP'2002-02-01 01:02:03') and ((ts + INTERVAL'1-2') >=
TIMESTAMP'2002-03-01 01:02:03') and (TIMESTAMP'2002-02-01 01:02:03' < (ts +
INTERVAL'1-2')) and (TIMESTAMP'2002-03-01 01:02:03' <= (ts + INTERVAL'1-2'))
and (TIMESTAMP'2002-03-01 01:02:03' = (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-03-01 01:02:03' >= (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' <> (ts + INTERVAL'1-2')) and
(TIMESTAMP'2002-04-01 01:02:03' > (ts + INTERVAL'1-2')) and (ts < (ts +
INTERVAL'1-0')) and (ts <= (ts + INTERVAL'1-0')) and (ts <> (ts +
INTERVAL'1-0')) and (ts = (ts + INTERVAL'0-0')) and (ts > (ts - INTERVAL'1-0'))
and (ts >= (ts - INTERVAL'1-0'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -1519,7 +1519,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -1527,7 +1527,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -1555,13 +1555,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1697,7 +1697,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((TIMESTAMP'2001-01-01 01:02:03' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (dt -
INTERVAL'0 01:02:04.000000000')) and ((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (ts = (dt + INTERVAL'0 01:02:03.0000
00000')) and (ts <> (dt + INTERVAL'0 01:02:04.000000000')) and (ts <= (dt +
INTERVAL'0 01:02:03.000000000')) and (ts < (dt + INTERVAL'0
01:02:04.000000000')) and (ts >= (dt - INTERVAL'0 01:02:03.000000000')) and (ts
> (dt - INTERVAL'0 01:02:04.000000000'))) (type: boolean)
- Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -1706,7 +1706,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), F
ilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp), FilterTimestampColEqualTimestampScalar(col
7:timestamp, val 2001-01-01 01:02:03)(children:
DateColAddIntervalDayTimeScalar(col 1:date, val 0 01:02:03.000000000) ->
7:timestamp), FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val
2001-01-01 01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val
0 01:02:04.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(c
hildren: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), FilterTimestampColLessTimestampScalar(col
7:timestamp, val 2001-01-01 01:02:03)(children:
DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 01:02:04.000000000) ->
7:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0
01:02:03.000000000) -> 7:timestamp), FilterTimestampColLessTimestampColumn(col
0:timestamp, col 7:timestamp)(children: DateColAddIntervalDayTimeScalar(col
1:date, val 0 01:02:04.000000000) -> 7:timestamp), FilterTimestampColGreaterEqu
alTimestampColumn(col 0:timestamp, col 7:timestamp)(children:
DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 01:02:03.000000000) ->
7:timestamp), FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0
01:02:04.000000000) -> 7:timestamp))
predicate: (((dt + INTERVAL'0 01:02:03.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:03.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((dt + INTERVAL'0 01:02:04.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:03.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((dt - INTERVAL'0 01:02:04.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (TIMESTAMP'2001-01-01 01:02:03' < (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (dt +
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' = (dt +
INTERVAL'0 01:02:03.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (dt -
INTERVAL'0 01:02:04.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (dt -
INTERVAL'0 01:02:03.000000000')) and (ts < (dt + INTERVAL'0 01:02:04.000
000000')) and (ts <= (dt + INTERVAL'0 01:02:03.000000000')) and (ts <> (dt +
INTERVAL'0 01:02:04.000000000')) and (ts = (dt + INTERVAL'0
01:02:03.000000000')) and (ts > (dt - INTERVAL'0 01:02:04.000000000')) and (ts
>= (dt - INTERVAL'0 01:02:03.000000000'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 96 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 96 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -1714,7 +1714,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 96 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -1722,7 +1722,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 96 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -1750,13 +1750,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1892,7 +1892,7 @@ STAGE PLANS:
TableScan
alias: vector_interval_2
filterExpr: ((TIMESTAMP'2001-01-01 01:02:03' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (ts -
INTERVAL'1 00:00:00.000000000')) and ((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and (ts = (ts + INTERVAL'0 00:00:00.0000
00000')) and (ts <> (ts + INTERVAL'1 00:00:00.000000000')) and (ts <= (ts +
INTERVAL'1 00:00:00.000000000')) and (ts < (ts + INTERVAL'1
00:00:00.000000000')) and (ts >= (ts - INTERVAL'1 00:00:00.000000000')) and (ts
> (ts - INTERVAL'1 00:00:00.000000000'))) (type: boolean)
- Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE
Column stats: COMPLETE
TableScan Vectorization:
native: true
Filter Operator
@@ -1901,7 +1901,7 @@ STAGE PLANS:
native: true
predicateExpression: FilterExprAndExpr(children:
FilterTimestampScalarEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarNotEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col 0:times
tamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 0
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1
00:00:00.000000000) ->
7:timestamp), FilterTimestampColLessEqualTimestampScalar(col 7:timestamp, val
2001-01-01 01:02:03)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampScalar(col 7:timestamp, val 2001-01-01
01:02:03)(children: TimestampColSubtractIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 0 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp,
val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColLessTimestampColumn(col 0:tim
estamp, col 7:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterEqualTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp),
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col
7:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col
0:timestamp, val 1 00:00:00.000000000) -> 7:timestamp))
predicate: (((ts + INTERVAL'0 00:00:00.000000000') =
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') <>
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >
TIMESTAMP'2001-01-01 01:02:03') and ((ts + INTERVAL'1 00:00:00.000000000') >=
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <
TIMESTAMP'2001-01-01 01:02:03') and ((ts - INTERVAL'1 00:00:00.000000000') <=
TIMESTAMP'2001-01-01 01:02:03') and (TIMESTAMP'2001-01-01 01:02:03' < (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <= (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' <> (ts +
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' = (ts +
INTERVAL'0 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' > (ts -
INTERVAL'1 00:00:00.000000000')) and (TIMESTAMP'2001-01-01 01:02:03' >= (ts -
INTERVAL'1 00:00:00.000000000')) and (ts < (ts + INTERVAL'1 00:00:00.000
000000')) and (ts <= (ts + INTERVAL'1 00:00:00.000000000')) and (ts <> (ts +
INTERVAL'1 00:00:00.000000000')) and (ts = (ts + INTERVAL'0
00:00:00.000000000')) and (ts > (ts - INTERVAL'1 00:00:00.000000000')) and (ts
>= (ts - INTERVAL'1 00:00:00.000000000'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
expressions: ts (type: timestamp)
outputColumnNames: _col0
@@ -1909,7 +1909,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: timestamp)
sort order: +
@@ -1917,7 +1917,7 @@ STAGE PLANS:
className: VectorReduceSinkObjectHashOperator
native: true
nativeConditionsMet:
hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine
tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true,
BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
- Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats:
COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: all inputs
Map Vectorization:
@@ -1945,13 +1945,13 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0]
- Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: NONE
+ Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE
Column stats: COMPLETE
table:
input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
