[18/21] hive git commit: HIVE-20985: If select operator inputs are temporary columns vectorization may reuse some of them as output (Zoltan Haindrich reviewed by Teddy Choi)

kgyrtkirk Thu, 06 Dec 2018 03:19:14 -0800
http://git-wip-us.apache.org/repos/asf/hive/blob/8b968c7e/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 cad499a..3b2b7ba 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
@@ -139,8 +139,8 @@ STAGE PLANS:
                     Select Vectorization:
                         className: VectorSelectOperator
                         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
+                        projectedOutputColumnNums: [2, 9, 12, 15, 18, 21, 24, 
27, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48, 50, 52, 54, 56, 58, 60, 62]
+                        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 10:interval_year_month, col 
11:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 10:interval_year_month, CastStringToIntervalYearMonth(col 2:string) -> 
11:interval_year_month) -> 12:boolean, LongColLessEqualLongColumn(col 
13:interval_year_month, col 14:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 13:interval_year_month, 
CastStringToIntervalYearMonth(col 3:string) -> 14:interval_year_month) -> 
15:boolean, LongColLessLongColumn(col 16:interval_year_month, col 
17:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 16:interval_year_month, CastStringToIntervalYearMonth(col 3:string) -> 
17:inte
 rval_year_month) -> 18:boolean, LongColGreaterEqualLongColumn(col 
19:interval_year_month, col 20:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 19:interval_year_month, 
CastStringToIntervalYearMonth(col 2:string) -> 20:interval_year_month) -> 
21:boolean, LongColGreaterEqualLongColumn(col 22:interval_year_month, col 
23:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 22:interval_year_month, CastStringToIntervalYearMonth(col 2:string) -> 
23:interval_year_month) -> 24:boolean, LongColGreaterLongColumn(col 
25:interval_year_month, col 26:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 3:string) -> 25:interval_year_month, 
CastStringToIntervalYearMonth(col 2:string) -> 26:interval_year_month) -> 
27:boolean, LongColNotEqualLongColumn(col 28:interval_year_month, col 
29:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 28:interval_year_month, CastStringToIntervalYearMonth(col 3:string) -> 2
 9:interval_year_month) -> 30:boolean, 
IntervalYearMonthColEqualIntervalYearMonthScalar(col 31:interval_year_month, 
val 14)(children: CastStringToIntervalYearMonth(col 2:string) -> 
31:interval_year_month) -> 32:boolean, 
IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 
33:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
2:string) -> 33:interval_year_month) -> 34:boolean, 
IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 
35:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col 
2:string) -> 35:interval_year_month) -> 36:boolean, 
IntervalYearMonthColLessIntervalYearMonthScalar(col 37:interval_year_month, val 
15)(children: CastStringToIntervalYearMonth(col 2:string) -> 
37:interval_year_month) -> 38:boolean, 
IntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col 
39:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
2:string) -> 39:interval_year_month) -> 40:boolean, 
IntervalYearMonthColGreaterEqualInterval
 YearMonthScalar(col 41:interval_year_month, val 14)(children: 
CastStringToIntervalYearMonth(col 3:string) -> 41:interval_year_month) -> 
42:boolean, IntervalYearMonthColGreaterIntervalYearMonthScalar(col 
43:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
3:string) -> 43:interval_year_month) -> 44:boolean, 
IntervalYearMonthColNotEqualIntervalYearMonthScalar(col 45:interval_year_month, 
val 15)(children: CastStringToIntervalYearMonth(col 2:string) -> 
45:interval_year_month) -> 46:boolean, 
IntervalYearMonthScalarEqualIntervalYearMonthColumn(val 14, col 
47:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 47:interval_year_month) -> 48:boolean, 
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col 
49:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 49:interval_year_month) -> 50:boolean, 
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col 
51:interval_year_month)(children: CastStri
 ngToIntervalYearMonth(col 3:string) -> 51:interval_year_month) -> 52:boolean, 
IntervalYearMonthScalarLessIntervalYearMonthColumn(val 14, col 
53:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 53:interval_year_month) -> 54:boolean, 
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 14, col 
55:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 55:interval_year_month) -> 56:boolean, 
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 15, col 
57:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 57:interval_year_month) -> 58:boolean, 
IntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 15, col 
59:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 59:interval_year_month) -> 60:boolean, 
IntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col 
61:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 61:interval_year_mon
 th) -> 62:boolean
                     Statistics: Num rows: 2 Data size: 366 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       key expressions: _col0 (type: string)
@@ -349,8 +349,8 @@ STAGE PLANS:
                     Select Vectorization:
                         className: VectorSelectOperator
                         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
+                        projectedOutputColumnNums: [2, 9, 12, 15, 18, 21, 23, 
25, 27, 29, 31, 33, 35, 37, 39, 41]
+                        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 10:interval_year_month, col 
11:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 10:interval_year_month, CastStringToIntervalYearMonth(col 3:string) -> 
11:interval_year_month) -> 12:boolean, LongColGreaterLongColumn(col 
13:interval_year_month, col 14:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 13:interval_year_month, 
CastStringToIntervalYearMonth(col 3:string) -> 14:interval_year_month) -> 
15:boolean, LongColLessEqualLongColumn(col 16:interval_year_month, col 
17:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 16:interval_year_month, CastStringToIntervalYearMonth(col 2:string) -
 > 17:interval_year_month) -> 18:boolean, LongColLessLongColumn(col 
 > 19:interval_year_month, col 20:interval_year_month)(children: 
 > CastStringToIntervalYearMonth(col 3:string) -> 19:interval_year_month, 
 > CastStringToIntervalYearMonth(col 2:string) -> 20:interval_year_month) -> 
 > 21:boolean, IntervalYearMonthColNotEqualIntervalYearMonthScalar(col 
 > 22:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
 > 2:string) -> 22:interval_year_month) -> 23:boolean, 
 > IntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col 
 > 24:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col 
 > 2:string) -> 24:interval_year_month) -> 25:boolean, 
 > IntervalYearMonthColGreaterIntervalYearMonthScalar(col 
 > 26:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col 
 > 2:string) -> 26:interval_year_month) -> 27:boolean, 
 > IntervalYearMonthColLessEqualIntervalYearMonthScalar(col 
 > 28:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
 > 3:string) -> 28:interva
 l_year_month) -> 29:boolean, 
IntervalYearMonthColLessIntervalYearMonthScalar(col 30:interval_year_month, val 
14)(children: CastStringToIntervalYearMonth(col 3:string) -> 
30:interval_year_month) -> 31:boolean, 
IntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col 
32:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 32:interval_year_month) -> 33:boolean, 
IntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 14, col 
34:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 34:interval_year_month) -> 35:boolean, 
IntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 14, col 
36:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 36:interval_year_month) -> 37:boolean, 
IntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 15, col 
38:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 38:interval_year_month) -> 39:boolean, IntervalYearMonthScalarLessIntervalY
 earMonthColumn(val 15, col 40:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 40:interval_year_month) -> 
41:boolean
                     Statistics: Num rows: 2 Data size: 318 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       key expressions: _col0 (type: string)
@@ -559,8 +559,8 @@ STAGE PLANS:
                     Select Vectorization:
                         className: VectorSelectOperator
                         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
+                        projectedOutputColumnNums: [4, 9, 12, 15, 18, 21, 24, 
27, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48, 50, 52, 54, 56, 58, 60, 62]
+                        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 10:interval_day_time, col 
11:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) -> 
10:interval_day_time, CastStringToIntervalDayTime(col 4:string) -> 
11:interval_day_time) -> 12:boolean, 
IntervalDayTimeColLessEqualIntervalDayTimeColumn(col 13:interval_day_time, col 
14:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) -> 
13:interval_day_time, CastStringToIntervalDayTime(col 5:string) -> 
14:interval_day_time) -> 15:boolean, 
IntervalDayTimeColLessIntervalDayTimeColumn(col 16:interval_day_time, col 
17:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) -> 
16:interval_day_time, CastString
 ToIntervalDayTime(col 5:string) -> 17:interval_day_time) -> 18:boolean, 
IntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 19:interval_day_time, 
col 20:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) 
-> 19:interval_day_time, CastStringToIntervalDayTime(col 4:string) -> 
20:interval_day_time) -> 21:boolean, 
IntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 22:interval_day_time, 
col 23:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) 
-> 22:interval_day_time, CastStringToIntervalDayTime(col 4:string) -> 
23:interval_day_time) -> 24:boolean, 
IntervalDayTimeColGreaterIntervalDayTimeColumn(col 25:interval_day_time, col 
26:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) -> 
25:interval_day_time, CastStringToIntervalDayTime(col 4:string) -> 
26:interval_day_time) -> 27:boolean, 
IntervalDayTimeColNotEqualIntervalDayTimeColumn(col 28:interval_day_time, col 
29:interval_day_time)(children: CastStringToIntervalDayTime(col
  4:string) -> 28:interval_day_time, CastStringToIntervalDayTime(col 5:string) 
-> 29:interval_day_time) -> 30:boolean, 
IntervalDayTimeColEqualIntervalDayTimeScalar(col 31:interval_day_time, val 1 
02:03:04.000000000)(children: CastStringToIntervalDayTime(col 4:string) -> 
31:interval_day_time) -> 32:boolean, 
IntervalDayTimeColLessEqualIntervalDayTimeScalar(col 33:interval_day_time, val 
1 02:03:04.000000000)(children: CastStringToIntervalDayTime(col 4:string) -> 
33:interval_day_time) -> 34:boolean, 
IntervalDayTimeColLessEqualIntervalDayTimeScalar(col 35:interval_day_time, val 
1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) -> 
35:interval_day_time) -> 36:boolean, 
IntervalDayTimeColLessIntervalDayTimeScalar(col 37:interval_day_time, val 1 
02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) -> 
37:interval_day_time) -> 38:boolean, 
IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 39:interval_day_time, 
val 1 02:03:04.000000000)(children: Ca
 stStringToIntervalDayTime(col 4:string) -> 39:interval_day_time) -> 
40:boolean, IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 
41:interval_day_time, val 1 02:03:04.000000000)(children: 
CastStringToIntervalDayTime(col 5:string) -> 41:interval_day_time) -> 
42:boolean, IntervalDayTimeColGreaterIntervalDayTimeScalar(col 
43:interval_day_time, val 1 02:03:04.000000000)(children: 
CastStringToIntervalDayTime(col 5:string) -> 43:interval_day_time) -> 
44:boolean, IntervalDayTimeColNotEqualIntervalDayTimeScalar(col 
45:interval_day_time, val 1 02:03:05.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 45:interval_day_time) -> 
46:boolean, IntervalDayTimeScalarEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 47:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 47:interval_day_time) -> 
48:boolean, IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 49:interval_day_time)(children: 
CastStringToIntervalDayTime(col 
 4:string) -> 49:interval_day_time) -> 50:boolean, 
IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1 02:03:04.000000000, 
col 51:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) 
-> 51:interval_day_time) -> 52:boolean, 
IntervalDayTimeScalarLessIntervalDayTimeColumn(val 1 02:03:04.000000000, col 
53:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) -> 
53:interval_day_time) -> 54:boolean, 
IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 55:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 55:interval_day_time) -> 
56:boolean, IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 57:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 57:interval_day_time) -> 
58:boolean, IntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 59:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 59:in
 terval_day_time) -> 60:boolean, 
IntervalDayTimeScalarNotEqualIntervalDayTimeColumn(val 1 02:03:04.000000000, 
col 61:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) 
-> 61:interval_day_time) -> 62:boolean
                     Statistics: Num rows: 2 Data size: 374 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       key expressions: _col0 (type: string)
@@ -769,8 +769,8 @@ STAGE PLANS:
                     Select Vectorization:
                         className: VectorSelectOperator
                         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
+                        projectedOutputColumnNums: [4, 9, 12, 15, 18, 21, 23, 
25, 27, 29, 31, 33, 35, 37, 39, 41]
+                        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 10:interval_day_time, 
col 11:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) 
-> 10:interval_day_time, CastStringToIntervalDayTime(col 5:string) -> 
11:interval_day_time) -> 12:boolean, 
IntervalDayTimeColGreaterIntervalDayTimeColumn(col 13:interval_day_time, col 
14:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) -> 
13:interval_day_time, CastStringToIntervalDayTime(col 5:string) -> 
14:interval_day_time) -> 15:boolean, 
IntervalDayTimeColLessEqualIntervalDayTimeColumn(col 16:interval_day_time, col 
17:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) -> 
16:interval_day_time, C
 astStringToIntervalDayTime(col 4:string) -> 17:interval_day_time) -> 
18:boolean, IntervalDayTimeColLessIntervalDayTimeColumn(col 
19:interval_day_time, col 20:interval_day_time)(children: 
CastStringToIntervalDayTime(col 5:string) -> 19:interval_day_time, 
CastStringToIntervalDayTime(col 4:string) -> 20:interval_day_time) -> 
21:boolean, IntervalDayTimeColNotEqualIntervalDayTimeScalar(col 
22:interval_day_time, val 1 02:03:04.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 22:interval_day_time) -> 
23:boolean, IntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 
24:interval_day_time, val 1 02:03:05.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 24:interval_day_time) -> 
25:boolean, IntervalDayTimeColGreaterIntervalDayTimeScalar(col 
26:interval_day_time, val 1 02:03:05.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 26:interval_day_time) -> 
27:boolean, IntervalDayTimeColLessEqualIntervalDayTimeScalar(col 
28:interval_day_time, val 1 0
 2:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string) -> 
28:interval_day_time) -> 29:boolean, 
IntervalDayTimeColLessIntervalDayTimeScalar(col 30:interval_day_time, val 1 
02:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string) -> 
30:interval_day_time) -> 31:boolean, 
IntervalDayTimeScalarNotEqualIntervalDayTimeColumn(val 1 02:03:04.000000000, 
col 32:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) 
-> 32:interval_day_time) -> 33:boolean, 
IntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 34:interval_day_time)(children: 
CastStringToIntervalDayTime(col 5:string) -> 34:interval_day_time) -> 
35:boolean, IntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 36:interval_day_time)(children: 
CastStringToIntervalDayTime(col 5:string) -> 36:interval_day_time) -> 
37:boolean, IntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 38:interval_day_time)(childr
 en: CastStringToIntervalDayTime(col 4:string) -> 38:interval_day_time) -> 
39:boolean, IntervalDayTimeScalarLessIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 40:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 40:interval_day_time) -> 41:boolean
                     Statistics: Num rows: 2 Data size: 326 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       key expressions: _col0 (type: string)
@@ -964,7 +964,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 
9:interval_year_month, col 10:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 9:interval_year_month, 
CastStringToIntervalYearMonth(col 3:string) -> 10:interval_year_month), 
FilterLongColLessEqualLongColumn(col 11:interval_year_month, col 
12:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 11:interval_year_month, CastStringToIntervalYearMonth(col 3:string) -> 
12:interval_year_month), FilterLongColLessLongColumn(col 
13:interval_year_month, col 14:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 2:string) -> 13:interval_year_month, 
CastStringToIntervalYearMonth(col 3:string) 
 -> 14:interval_year_month), FilterLongColGreaterEqualLongColumn(col 
15:interval_year_month, col 16:interval_year_month)(children: 
CastStringToIntervalYearMonth(col 3:string) -> 15:interval_year_month, 
CastStringToIntervalYearMonth(col 2:string) -> 16:interval_year_month), 
FilterLongColGreaterLongColumn(col 17:interval_year_month, col 
18:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 17:interval_year_month, CastStringToIntervalYearMonth(col 2:string) -> 
18:interval_year_month), 
FilterIntervalYearMonthColEqualIntervalYearMonthScalar(col 
19:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
2:string) -> 19:interval_year_month), 
FilterIntervalYearMonthColNotEqualIntervalYearMonthScalar(col 
20:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col 
2:string) -> 20:interval_year_month), 
FilterIntervalYearMonthColLessEqualIntervalYearMonthScalar(col 
21:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(
 col 2:string) -> 21:interval_year_month), 
FilterIntervalYearMonthColLessIntervalYearMonthScalar(col 
22:interval_year_month, val 15)(children: CastStringToIntervalYearMonth(col 
2:string) -> 22:interval_year_month), 
FilterIntervalYearMonthColGreaterEqualIntervalYearMonthScalar(col 
23:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
3:string) -> 23:interval_year_month), 
FilterIntervalYearMonthColGreaterIntervalYearMonthScalar(col 
24:interval_year_month, val 14)(children: CastStringToIntervalYearMonth(col 
3:string) -> 24:interval_year_month), 
FilterIntervalYearMonthScalarEqualIntervalYearMonthColumn(val 14, col 
25:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 25:interval_year_month), 
FilterIntervalYearMonthScalarNotEqualIntervalYearMonthColumn(val 14, col 
26:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 26:interval_year_month), 
FilterIntervalYearMonthScalarLessEqualIntervalYearMonthColumn(val 14, col
  27:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 27:interval_year_month), 
FilterIntervalYearMonthScalarLessIntervalYearMonthColumn(val 14, col 
28:interval_year_month)(children: CastStringToIntervalYearMonth(col 3:string) 
-> 28:interval_year_month), 
FilterIntervalYearMonthScalarGreaterEqualIntervalYearMonthColumn(val 15, col 
29:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 29:interval_year_month), 
FilterIntervalYearMonthScalarGreaterIntervalYearMonthColumn(val 15, col 
30:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 30: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: 214 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Select Operator
@@ -1163,7 +1163,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 
9:interval_day_time, col 10:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 9:interval_day_time, 
CastStringToIntervalDayTime(col 5:string) -> 10:interval_day_time), 
FilterIntervalDayTimeColLessEqualIntervalDayTimeColumn(col 
11:interval_day_time, col 12:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 11:interval_day_time, 
CastStringToIntervalDayTime(col 5:string) -> 12:interval_day_time), 
FilterIntervalDayTimeColLessIntervalDayTimeColumn(col 13:interval_day_time, col 
14:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) -> 
13:interval_day_time, 
 CastStringToIntervalDayTime(col 5:string) -> 14:interval_day_time), 
FilterIntervalDayTimeColGreaterEqualIntervalDayTimeColumn(col 
15:interval_day_time, col 16:interval_day_time)(children: 
CastStringToIntervalDayTime(col 5:string) -> 15:interval_day_time, 
CastStringToIntervalDayTime(col 4:string) -> 16:interval_day_time), 
FilterIntervalDayTimeColGreaterIntervalDayTimeColumn(col 17:interval_day_time, 
col 18:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) 
-> 17:interval_day_time, CastStringToIntervalDayTime(col 4:string) -> 
18:interval_day_time), FilterIntervalDayTimeColEqualIntervalDayTimeScalar(col 
19:interval_day_time, val 1 02:03:04.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 19:interval_day_time), 
FilterIntervalDayTimeColNotEqualIntervalDayTimeScalar(col 20:interval_day_time, 
val 1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) 
-> 20:interval_day_time), 
FilterIntervalDayTimeColLessEqualIntervalDayTimeScalar(col 
 21:interval_day_time, val 1 02:03:05.000000000)(children: 
CastStringToIntervalDayTime(col 4:string) -> 21:interval_day_time), 
FilterIntervalDayTimeColLessIntervalDayTimeScalar(col 22:interval_day_time, val 
1 02:03:05.000000000)(children: CastStringToIntervalDayTime(col 4:string) -> 
22:interval_day_time), 
FilterIntervalDayTimeColGreaterEqualIntervalDayTimeScalar(col 
23:interval_day_time, val 1 02:03:04.000000000)(children: 
CastStringToIntervalDayTime(col 5:string) -> 23:interval_day_time), 
FilterIntervalDayTimeColGreaterIntervalDayTimeScalar(col 24:interval_day_time, 
val 1 02:03:04.000000000)(children: CastStringToIntervalDayTime(col 5:string) 
-> 24:interval_day_time), 
FilterIntervalDayTimeScalarEqualIntervalDayTimeColumn(val 1 02:03:04.000000000, 
col 25:interval_day_time)(children: CastStringToIntervalDayTime(col 4:string) 
-> 25:interval_day_time), 
FilterIntervalDayTimeScalarNotEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 26:interval_day_time)(children: CastStringToInter
 valDayTime(col 5:string) -> 26:interval_day_time), 
FilterIntervalDayTimeScalarLessEqualIntervalDayTimeColumn(val 1 
02:03:04.000000000, col 27:interval_day_time)(children: 
CastStringToIntervalDayTime(col 5:string) -> 27:interval_day_time), 
FilterIntervalDayTimeScalarLessIntervalDayTimeColumn(val 1 02:03:04.000000000, 
col 28:interval_day_time)(children: CastStringToIntervalDayTime(col 5:string) 
-> 28:interval_day_time), 
FilterIntervalDayTimeScalarGreaterEqualIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 29:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 29:interval_day_time), 
FilterIntervalDayTimeScalarGreaterIntervalDayTimeColumn(val 1 
02:03:05.000000000, col 30:interval_day_time)(children: 
CastStringToIntervalDayTime(col 4:string) -> 30: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: 222 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Select Operator
@@ -1352,7 +1352,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 10:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, col 
9:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) -> 
9:interval_year_month) -> 10:date), FilterDateScalarGreaterEqualDateColumn(val 
11747, col 12:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, col 
11:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 11:interval_year_month) -> 12:date), FilterDateColEqualDateScalar(col 
14:date, val 11747)(children: DateColAddIntervalYearMonthColumn(col 1:date, col 
13:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 13:interval_year_month)
  -> 14:date), FilterDateColLessEqualDateScalar(col 16:date, val 
11747)(children: DateColAddIntervalYearMonthColumn(col 1:date, col 
15:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 15:interval_year_month) -> 16:date), FilterDateColGreaterEqualDateScalar(col 
18:date, val 11747)(children: DateColAddIntervalYearMonthColumn(col 1:date, col 
17:interval_year_month)(children: CastStringToIntervalYearMonth(col 2:string) 
-> 17:interval_year_month) -> 18:date), FilterLongColNotEqualLongColumn(col 
1:date, col 20:date)(children: DateColAddIntervalYearMonthColumn(col 1:date, 
col 19:interval_year_month)(children: CastStringToIntervalYearMonth(col 
2:string) -> 19:interval_year_month) -> 20:date), 
FilterDateScalarEqualDateColumn(val 11747, col 21:date)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 21:date), 
FilterDateScalarLessEqualDateColumn(val 11747, col 22:date)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 22:date), Fil
 terDateScalarGreaterEqualDateColumn(val 11747, col 23:date)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 23:date), 
FilterDateColEqualDateScalar(col 24:date, val 11747)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 24:date), 
FilterDateColLessEqualDateScalar(col 25:date, val 11747)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 25:date), 
FilterDateColGreaterEqualDateScalar(col 26:date, val 11747)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 26:date), 
FilterLongColNotEqualLongColumn(col 1:date, col 27:date)(children: 
DateColAddIntervalYearMonthScalar(col 1:date, val 1-2) -> 27: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: 183 Basic stats: 
COMPLETE Column stats: COMPLETE
                     Select Operator
@@ -1541,7 +1541,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 8:timestamp)(children: 
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) -> 
8:timestamp), FilterTimestampScalarGreaterEqualTimestampColumn(val 2002-03-01 
01:02:03, col 9:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 
0:timestamp, val 1-2) -> 9:timestamp), 
FilterTimestampScalarNotEqualTimestampColumn(val 2002-04-01 01:02:03, col 
10:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, 
val 1-2) -> 10:timestamp), FilterTimestampScalarLessTimestampColumn(val 
2002-02-01 01:02:03, col 11:timestamp)(children: 
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) -> 
11:timestamp), FilterTimestampScalarGreate
 rTimestampColumn(val 2002-04-01 01:02:03, col 12:timestamp)(children: 
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) -> 
12:timestamp), FilterTimestampColEqualTimestampScalar(col 13:timestamp, val 
2002-03-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 
0:timestamp, val 1-2) -> 13:timestamp), 
FilterTimestampColGreaterEqualTimestampScalar(col 14:timestamp, val 2002-03-01 
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 
1-2) -> 14:timestamp), FilterTimestampColLessEqualTimestampScalar(col 
15:timestamp, val 2002-03-01 01:02:03)(children: 
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-2) -> 
15:timestamp), FilterTimestampColNotEqualTimestampScalar(col 16:timestamp, val 
2002-04-01 01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 
0:timestamp, val 1-2) -> 16:timestamp), 
FilterTimestampColGreaterTimestampScalar(col 17:timestamp, val 2002-02-01 
01:02:03)(children: TimestampColAddIntervalYearMonthScal
 ar(col 0:timestamp, val 1-2) -> 17:timestamp), 
FilterTimestampColLessTimestampScalar(col 18:timestamp, val 2002-04-01 
01:02:03)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 
1-2) -> 18:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, 
col 19:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 
0:timestamp, val 0-0) -> 19:timestamp), 
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col 
20:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, 
val 1-0) -> 20:timestamp), FilterTimestampColLessEqualTimestampColumn(col 
0:timestamp, col 21:timestamp)(children: 
TimestampColAddIntervalYearMonthScalar(col 0:timestamp, val 1-0) -> 
21:timestamp), FilterTimestampColLessTimestampColumn(col 0:timestamp, col 
22:timestamp)(children: TimestampColAddIntervalYearMonthScalar(col 0:timestamp, 
val 1-0) -> 22:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col 
0:timestamp, col 23:timestamp)(children: TimestampCo
 lSubtractIntervalYearMonthScalar(col 0:timestamp, val 1-0) -> 23:timestamp), 
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col 
24:timestamp)(children: TimestampColSubtractIntervalYearMonthScalar(col 
0:timestamp, val 1-0) -> 24: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: COMPLETE
                     Select Operator
@@ -1740,7 +1740,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 
8:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 8:timestamp), 
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col 
9:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 9:timestamp), 
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col 
10:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 10:timestamp), 
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col 
11:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 11:timestamp
 ), FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col 
12:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 12:timestamp), 
FilterTimestampColEqualTimestampScalar(col 13:timestamp, val 2001-01-01 
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 13:timestamp), 
FilterTimestampColNotEqualTimestampScalar(col 14:timestamp, val 2001-01-01 
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 14:timestamp), 
FilterTimestampColGreaterEqualTimestampScalar(col 15:timestamp, val 2001-01-01 
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 15:timestamp), 
FilterTimestampColGreaterTimestampScalar(col 16:timestamp, val 2001-01-01 
01:02:03)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 16:timestamp), 
FilterTimestampColLessEqualTimestampScalar(col 17:timestamp, val 2001-01
 -01 01:02:03)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 17:timestamp), FilterTimestampColLessTimestampScalar(col 
18:timestamp, val 2001-01-01 01:02:03)(children: 
DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 01:02:04.000000000) -> 
18:timestamp), FilterTimestampColEqualTimestampColumn(col 0:timestamp, col 
19:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 19:timestamp), 
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col 
20:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 20:timestamp), 
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col 
21:timestamp)(children: DateColAddIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 21:timestamp), FilterTimestampColLessTimestampColumn(col 
0:timestamp, col 22:timestamp)(children: DateColAddIntervalDayTimeScalar(col 
1:date, val 0 01:02:04.000000000) -> 22:timestamp), Fi
 lterTimestampColGreaterEqualTimestampColumn(col 0:timestamp, col 
23:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 
01:02:03.000000000) -> 23:timestamp), 
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col 
24:timestamp)(children: DateColSubtractIntervalDayTimeScalar(col 1:date, val 0 
01:02:04.000000000) -> 24: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: COMPLETE
                     Select Operator
@@ -1939,7 +1939,7 @@ STAGE PLANS:
                     Filter Vectorization:
                         className: VectorFilterOperator
                         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))
+                        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 
8:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 1 00:00:00.000000000) -> 8:timestamp), 
FilterTimestampScalarLessEqualTimestampColumn(val 2001-01-01 01:02:03, col 
9:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 1 00:00:00.000000000) -> 9:timestamp), 
FilterTimestampScalarLessTimestampColumn(val 2001-01-01 01:02:03, col 
10:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 1 00:00:00.000000000) -> 10:timestamp), 
FilterTimestampScalarGreaterEqualTimestampColumn(val 2001-01-01 01:02:03, col 
11:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col 0:ti
 mestamp, val 1 00:00:00.000000000) -> 11:timestamp), 
FilterTimestampScalarGreaterTimestampColumn(val 2001-01-01 01:02:03, col 
12:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col 
0:timestamp, val 1 00:00:00.000000000) -> 12:timestamp), 
FilterTimestampColEqualTimestampScalar(col 13:timestamp, val 2001-01-01 
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 0 
00:00:00.000000000) -> 13:timestamp), 
FilterTimestampColNotEqualTimestampScalar(col 14:timestamp, val 2001-01-01 
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.000000000) -> 14:timestamp), 
FilterTimestampColGreaterEqualTimestampScalar(col 15:timestamp, val 2001-01-01 
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.000000000) -> 15:timestamp), 
FilterTimestampColGreaterTimestampScalar(col 16:timestamp, val 2001-01-01 
01:02:03)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.0
 00000000) -> 16:timestamp), FilterTimestampColLessEqualTimestampScalar(col 
17:timestamp, val 2001-01-01 01:02:03)(children: 
TimestampColSubtractIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.000000000) -> 17:timestamp), FilterTimestampColLessTimestampScalar(col 
18:timestamp, val 2001-01-01 01:02:03)(children: 
TimestampColSubtractIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.000000000) -> 18:timestamp), 
FilterTimestampColEqualTimestampColumn(col 0:timestamp, col 
19:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 0 00:00:00.000000000) -> 19:timestamp), 
FilterTimestampColNotEqualTimestampColumn(col 0:timestamp, col 
20:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 1 00:00:00.000000000) -> 20:timestamp), 
FilterTimestampColLessEqualTimestampColumn(col 0:timestamp, col 
21:timestamp)(children: TimestampColAddIntervalDayTimeScalar(col 0:timestamp, 
val 1 00:00:00.000000000) -> 21:timestamp), FilterTimestampColLessT
 imestampColumn(col 0:timestamp, col 22:timestamp)(children: 
TimestampColAddIntervalDayTimeScalar(col 0:timestamp, val 1 00:00:00.000000000) 
-> 22:timestamp), FilterTimestampColGreaterEqualTimestampColumn(col 
0:timestamp, col 23:timestamp)(children: 
TimestampColSubtractIntervalDayTimeScalar(col 0:timestamp, val 1 
00:00:00.000000000) -> 23:timestamp), 
FilterTimestampColGreaterTimestampColumn(col 0:timestamp, col 
24:timestamp)(children: TimestampColSubtractIntervalDayTimeScalar(col 
0:timestamp, val 1 00:00:00.000000000) -> 24: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: COMPLETE
                     Select Operator
[18/21] hive git commit: HIVE-20985: If select operator inputs are temporary columns vectorization may reuse some of them as output (Zoltan Haindrich reviewed by Teddy Choi)

Reply via email to
