lgbo-ustc opened a new issue, #7051: URL: https://github.com/apache/incubator-gluten/issues/7051
### Backend CH (ClickHouse) ### Bug description [Expected behavior] and [actual behavior]. Problematic queries ```sql select *, cast(timewatch/1000.0 as BIGINT) timewatch, cast(duration/1000.0 as BIGINT) duration, if( (cast(duration/1000.0 as BIGINT)<=10 and cast(timewatch/1000.0 as BIGINT)>=5) or (cast(duration/1000.0 as BIGINT)>10 and cast(duration/1000.0 as BIGINT)<=15 and cast(timewatch/1000.0 as BIGINT)>=6) or (cast(duration/1000.0 as BIGINT)>15 and cast(duration/1000.0 as BIGINT)<=25 and cast(timewatch/1000.0 as BIGINT)>=7) or (cast(duration/1000.0 as BIGINT)>25 and cast(duration/1000.0 as BIGINT)<=40 and cast(timewatch/1000.0 as BIGINT)>=8) or (cast(duration/1000.0 as BIGINT)>40 and cast(duration/1000.0 as BIGINT)<=60 and cast(timewatch/1000.0 as BIGINT)>=10) or (cast(duration/1000.0 as BIGINT)>60 and cast(timewatch/1000.0 as BIGINT)>=12), 1, 0) eff_watch_cnt from t ```  The projection step is realy slow. ### Spark version None ### Spark configurations _No response_ ### System information _No response_ ### Relevant logs ```bash The actions dag for the projections. 0 : INPUT () (no column) Nullable(Int64) rtime 1 : INPUT () (no column) Nullable(Int64) uid 2 : INPUT () (no column) Nullable(Int64) poster_uid 3 : INPUT () (no column) String module 4 : INPUT () (no column) Nullable(Int64) like_cnt 5 : INPUT () (no column) Nullable(Int64) comment_cnt 6 : INPUT () (no column) Nullable(Int64) share_cnt 7 : INPUT () (no column) Nullable(Int64) timewatch 8 : INPUT () (no column) Nullable(Int64) end_times 9 : INPUT () (no column) Nullable(Int64) duration 10 : INPUT () (no column) Nullable(String) day 11 : COLUMN () Const(String) String Nullable(D_2 12 : FUNCTION (7, 11) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_2) [CAST] 13 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_3 14 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_4 15 : FUNCTION (12, 14) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_2),Nullable(Decimal(44, 23))_4) [CAST] 16 : FUNCTION (15, 13) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_2),Nullable(Decimal(44, 23))_4),1000_3) [sparkDivideDecimal] 17 : COLUMN () Const(Int32) Int32 27_5 18 : COLUMN () Const(Int32) Int32 6_6 19 : FUNCTION (16, 17, 18) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_2),Nullable(Decimal(44, 23))_4),1000_3),27_5,6_6) [checkDecimalOverflowSparkOrNull] 20 : COLUMN () Const(String) String Nullable(I_7 21 : FUNCTION (19, 20) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_2),Nullable(Decimal(44, 23))_4),1000_3),27_5,6_6),Nullable(I_7) [CAST] 22 : ALIAS (21) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_2),Nullable(Decimal(44, 23))_4),1000_3),27_5,6_6),Nullable(I_7) 23 : COLUMN () Const(String) String Nullable(D_8 24 : FUNCTION (9, 23) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_8) [CAST] 25 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_9 26 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_10 27 : FUNCTION (24, 26) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_8),Nullable(Decimal(44, 23))_10) [CAST] 28 : FUNCTION (27, 25) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_8),Nullable(Decimal(44, 23))_10),1000_9) [sparkDivideDecimal] 29 : COLUMN () Const(Int32) Int32 27_11 30 : COLUMN () Const(Int32) Int32 6_12 31 : FUNCTION (28, 29, 30) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_8),Nullable(Decimal(44, 23))_10),1000_9),27_11,6_12) [checkDecimalOverflowSparkOrNull] 32 : COLUMN () Const(String) String Nullable(I_13 33 : FUNCTION (31, 32) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_8),Nullable(Decimal(44, 23))_10),1000_9),27_11,6_12),Nullable(I_13) [CAST] 34 : ALIAS (33) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_8),Nullable(Decimal(44, 23))_10),1000_9),27_11,6_12),Nullable(I_13) 35 : COLUMN () Const(String) String Nullable(D_14 36 : FUNCTION (9, 35) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_14) [CAST] 37 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_15 38 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_16 39 : FUNCTION (36, 38) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16) [CAST] 40 : FUNCTION (39, 37) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15) [sparkDivideDecimal] 41 : COLUMN () Const(Int32) Int32 27_17 42 : COLUMN () Const(Int32) Int32 6_18 43 : FUNCTION (40, 41, 42) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18) [checkDecimalOverflowSparkOrNull] 44 : COLUMN () Const(String) String Nullable(I_19 45 : FUNCTION (43, 44) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19) [CAST] 46 : COLUMN () Const(Int64) Int64 10_20 47 : FUNCTION (45, 46) (no column) Nullable(UInt8) lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20) [lessOrEquals] 48 : COLUMN () Const(String) String Nullable(D_21 49 : FUNCTION (7, 48) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_21) [CAST] 50 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_22 51 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_23 52 : FUNCTION (49, 51) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23) [CAST] 53 : FUNCTION (52, 50) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22) [sparkDivideDecimal] 54 : COLUMN () Const(Int32) Int32 27_24 55 : COLUMN () Const(Int32) Int32 6_25 56 : FUNCTION (53, 54, 55) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25) [checkDecimalOverflowSparkOrNull] 57 : COLUMN () Const(String) String Nullable(I_26 58 : FUNCTION (56, 57) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26) [CAST] 59 : COLUMN () Const(Int64) Int64 5_27 60 : FUNCTION (58, 59) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27) [greaterOrEquals] 61 : FUNCTION (47, 60) (no column) Nullable(UInt8) and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)) [and] 62 : COLUMN () Const(String) String Nullable(D_28 63 : FUNCTION (9, 62) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_28) [CAST] 64 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_29 65 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_30 66 : FUNCTION (63, 65) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30) [CAST] 67 : FUNCTION (66, 64) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29) [sparkDivideDecimal] 68 : COLUMN () Const(Int32) Int32 27_31 69 : COLUMN () Const(Int32) Int32 6_32 70 : FUNCTION (67, 68, 69) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32) [checkDecimalOverflowSparkOrNull] 71 : COLUMN () Const(String) String Nullable(I_33 72 : FUNCTION (70, 71) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33) [CAST] 73 : COLUMN () Const(Int64) Int64 10_34 74 : FUNCTION (72, 73) (no column) Nullable(UInt8) greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34) [greater] 75 : COLUMN () Const(String) String Nullable(D_35 76 : FUNCTION (9, 75) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_35) [CAST] 77 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_36 78 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_37 79 : FUNCTION (76, 78) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37) [CAST] 80 : FUNCTION (79, 77) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36) [sparkDivideDecimal] 81 : COLUMN () Const(Int32) Int32 27_38 82 : COLUMN () Const(Int32) Int32 6_39 83 : FUNCTION (80, 81, 82) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39) [checkDecimalOverflowSparkOrNull] 84 : COLUMN () Const(String) String Nullable(I_40 85 : FUNCTION (83, 84) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40) [CAST] 86 : COLUMN () Const(Int64) Int64 15_41 87 : FUNCTION (85, 86) (no column) Nullable(UInt8) lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41) [lessOrEquals] 88 : FUNCTION (74, 87) (no column) Nullable(UInt8) and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)) [and] 89 : COLUMN () Const(String) String Nullable(D_42 90 : FUNCTION (7, 89) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_42) [CAST] 91 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_43 92 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_44 93 : FUNCTION (90, 92) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44) [CAST] 94 : FUNCTION (93, 91) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43) [sparkDivideDecimal] 95 : COLUMN () Const(Int32) Int32 27_45 96 : COLUMN () Const(Int32) Int32 6_46 97 : FUNCTION (94, 95, 96) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46) [checkDecimalOverflowSparkOrNull] 98 : COLUMN () Const(String) String Nullable(I_47 99 : FUNCTION (97, 98) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47) [CAST] 100 : COLUMN () Const(Int64) Int64 6_48 101 : FUNCTION (99, 100) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48) [greaterOrEquals] 102 : FUNCTION (88, 101) (no column) Nullable(UInt8) and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48)) [and] 103 : FUNCTION (61, 102) (no column) Nullable(UInt8) or(and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48))) [or] 104 : COLUMN () Const(String) String Nullable(D_49 105 : FUNCTION (9, 104) (no column) Nullable(Decimal(21, 1 106 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_50 107 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_51 108 : FUNCTION (105, 107) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51) [CAST] 109 : FUNCTION (108, 106) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50) [sparkDivideDecimal] 110 : COLUMN () Const(Int32) Int32 27_52 111 : COLUMN () Const(Int32) Int32 6_53 112 : FUNCTION (109, 110, 111) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53) [checkDecimalOverflowSparkOrNull] 113 : COLUMN () Const(String) String Nullable(I_54 114 : FUNCTION (112, 113) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54) [CAST] 115 : COLUMN () Const(Int64) Int64 15_55 116 : FUNCTION (114, 115) (no column) Nullable(UInt8) greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55) [greater] 117 : COLUMN () Const(String) String Nullable(D_56 118 : FUNCTION (9, 117) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_56) [CAST] 119 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_57 120 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_58 121 : FUNCTION (118, 120) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58) [CAST] 122 : FUNCTION (121, 119) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57) [sparkDivideDecimal] 123 : COLUMN () Const(Int32) Int32 27_59 124 : COLUMN () Const(Int32) Int32 6_60 125 : FUNCTION (122, 123, 124) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60) [checkDecimalOverflowSparkOrNull] 126 : COLUMN () Const(String) String Nullable(I_61 127 : FUNCTION (125, 126) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61) [CAST] 128 : COLUMN () Const(Int64) Int64 25_62 129 : FUNCTION (127, 128) (no column) Nullable(UInt8) lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62) [lessOrEquals] 130 : FUNCTION (116, 129) (no column) Nullable(UInt8) and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)) [and] 131 : COLUMN () Const(String) String Nullable(D_63 132 : FUNCTION (7, 131) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_63) [CAST] 133 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_64 134 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_65 135 : FUNCTION (132, 134) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65) [CAST] 136 : FUNCTION (135, 133) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64) [sparkDivideDecimal] 137 : COLUMN () Const(Int32) Int32 27_66 138 : COLUMN () Const(Int32) Int32 6_67 139 : FUNCTION (136, 137, 138) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67) [checkDecimalOverflowSparkOrNull] 140 : COLUMN () Const(String) String Nullable(I_68 141 : FUNCTION (139, 140) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68) [CAST] 142 : COLUMN () Const(Int64) Int64 7_69 143 : FUNCTION (141, 142) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69) [greaterOrEquals] 144 : FUNCTION (130, 143) (no column) Nullable(UInt8) and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69)) [and] 145 : FUNCTION (103, 144) (no column) Nullable(UInt8) or(or(and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48))),and(and(greater(CAST(checkDecimalOverf lowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69))) [or] 146 : COLUMN () Const(String) String Nullable(D_70 147 : FUNCTION (9, 146) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_70) [CAST] 148 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_71 149 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_72 150 : FUNCTION (147, 149) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72) [CAST] 151 : FUNCTION (150, 148) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71) [sparkDivideDecimal] 152 : COLUMN () Const(Int32) Int32 27_73 153 : COLUMN () Const(Int32) Int32 6_74 154 : FUNCTION (151, 152, 153) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74) [checkDecimalOverflowSparkOrNull] 155 : COLUMN () Const(String) String Nullable(I_75 156 : FUNCTION (154, 155) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75) [CAST] 157 : COLUMN () Const(Int64) Int64 25_76 158 : FUNCTION (156, 157) (no column) Nullable(UInt8) greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76) [greater] 159 : COLUMN () Const(String) String Nullable(D_77 160 : FUNCTION (9, 159) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_77) [CAST] 161 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_78 162 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_79 163 : FUNCTION (160, 162) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79) [CAST] 164 : FUNCTION (163, 161) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78) [sparkDivideDecimal] 165 : COLUMN () Const(Int32) Int32 27_80 166 : COLUMN () Const(Int32) Int32 6_81 167 : FUNCTION (164, 165, 166) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81) [checkDecimalOverflowSparkOrNull] 168 : COLUMN () Const(String) String Nullable(I_82 169 : FUNCTION (167, 168) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82) [CAST] 170 : COLUMN () Const(Int64) Int64 40_83 171 : FUNCTION (169, 170) (no column) Nullable(UInt8) lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83) [lessOrEquals] 172 : FUNCTION (158, 171) (no column) Nullable(UInt8) and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)) [and] 173 : COLUMN () Const(String) String Nullable(D_84 174 : FUNCTION (7, 173) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_84) [CAST] 175 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_85 176 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_86 177 : FUNCTION (174, 176) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86) [CAST] 178 : FUNCTION (177, 175) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85) [sparkDivideDecimal] 179 : COLUMN () Const(Int32) Int32 27_87 180 : COLUMN () Const(Int32) Int32 6_88 181 : FUNCTION (178, 179, 180) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88) [checkDecimalOverflowSparkOrNull] 182 : COLUMN () Const(String) String Nullable(I_89 183 : FUNCTION (181, 182) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88),Nullable(I_89) [CAST] 184 : COLUMN () Const(Int64) Int64 8_90 185 : FUNCTION (183, 184) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88),Nullable(I_89),8_90) [greaterOrEquals] 186 : FUNCTION (172, 185) (no column) Nullable(UInt8) and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88),Nullable(I_89),8_90)) [and] 187 : COLUMN () Const(String) String Nullable(D_91 188 : FUNCTION (9, 187) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_91) [CAST] 189 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_92 190 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_93 191 : FUNCTION (188, 190) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93) [CAST] 192 : FUNCTION (191, 189) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92) [sparkDivideDecimal] 193 : COLUMN () Const(Int32) Int32 27_94 194 : COLUMN () Const(Int32) Int32 6_95 195 : FUNCTION (192, 193, 194) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95) [checkDecimalOverflowSparkOrNull] 196 : COLUMN () Const(String) String Nullable(I_96 197 : FUNCTION (195, 196) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96) [CAST] 198 : COLUMN () Const(Int64) Int64 40_97 199 : FUNCTION (197, 198) (no column) Nullable(UInt8) greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97) [greater] 200 : COLUMN () Const(String) String Nullable(D_98 201 : FUNCTION (9, 200) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_98) [CAST] 202 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_99 203 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_100 204 : FUNCTION (201, 203) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100) [CAST] 205 : FUNCTION (204, 202) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99) [sparkDivideDecimal] 206 : COLUMN () Const(Int32) Int32 27_101 207 : COLUMN () Const(Int32) Int32 6_102 208 : FUNCTION (205, 206, 207) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102) [checkDecimalOverflowSparkOrNull] 209 : COLUMN () Const(String) String Nullable(I_103 210 : FUNCTION (208, 209) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103) [CAST] 211 : COLUMN () Const(Int64) Int64 60_104 212 : FUNCTION (210, 211) (no column) Nullable(UInt8) lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104) [lessOrEquals] 213 : FUNCTION (199, 212) (no column) Nullable(UInt8) and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)) [and] 214 : COLUMN () Const(String) String Nullable(D_105 215 : FUNCTION (7, 214) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_105) [CAST] 216 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_106 217 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_107 218 : FUNCTION (215, 217) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107) [CAST] 219 : FUNCTION (218, 216) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106) [sparkDivideDecimal] 220 : COLUMN () Const(Int32) Int32 27_108 221 : COLUMN () Const(Int32) Int32 6_109 222 : FUNCTION (219, 220, 221) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109) [checkDecimalOverflowSparkOrNull] 223 : COLUMN () Const(String) String Nullable(I_110 224 : FUNCTION (222, 223) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110) [CAST] 225 : COLUMN () Const(Int64) Int64 10_111 226 : FUNCTION (224, 225) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111) [greaterOrEquals] 227 : FUNCTION (213, 226) (no column) Nullable(UInt8) and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111)) [and] 228 : FUNCTION (186, 227) (no column) Nullable(UInt8) or(and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88),Nullable(I_89),8_90)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverflow SparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111))) [or] 229 : COLUMN () Const(String) String Nullable(D_112 230 : FUNCTION (9, 229) (no column) Nullable(Decimal(21, 1)) CAST(duration,Nullable(D_112) [CAST] 231 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_113 232 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_114 233 : FUNCTION (230, 232) (no column) Nullable(Decimal(44, 23)) CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114) [CAST] 234 : FUNCTION (233, 231) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113) [sparkDivideDecimal] 235 : COLUMN () Const(Int32) Int32 27_115 236 : COLUMN () Const(Int32) Int32 6_116 237 : FUNCTION (234, 235, 236) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116) [checkDecimalOverflowSparkOrNull] 238 : COLUMN () Const(String) String Nullable(I_117 239 : FUNCTION (237, 238) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117) [CAST] 240 : COLUMN () Const(Int64) Int64 60_118 241 : FUNCTION (239, 240) (no column) Nullable(UInt8) greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118) [greater] 242 : COLUMN () Const(String) String Nullable(D_119 243 : FUNCTION (7, 242) (no column) Nullable(Decimal(21, 1)) CAST(timewatch,Nullable(D_119) [CAST] 244 : COLUMN () Const(Decimal128) Decimal(21, 1) 1000_120 245 : COLUMN () Const(String) String Nullable(Decimal(44, 23))_121 246 : FUNCTION (243, 245) (no column) Nullable(Decimal(44, 23)) CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121) [CAST] 247 : FUNCTION (246, 244) (no column) Nullable(Decimal(76, 23)) sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120) [sparkDivideDecimal] 248 : COLUMN () Const(Int32) Int32 27_122 249 : COLUMN () Const(Int32) Int32 6_123 250 : FUNCTION (247, 248, 249) (no column) Nullable(Decimal(27, 6)) checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123) [checkDecimalOverflowSparkOrNull] 251 : COLUMN () Const(String) String Nullable(I_124 252 : FUNCTION (250, 251) (no column) Nullable(Int64) CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124) [CAST] 253 : COLUMN () Const(Int64) Int64 12_125 254 : FUNCTION (252, 253) (no column) Nullable(UInt8) greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125) [greaterOrEquals] 255 : FUNCTION (241, 254) (no column) Nullable(UInt8) and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125)) [and] 256 : FUNCTION (228, 255) (no column) Nullable(UInt8) or(or(and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27_87,6_88),Nullable(I_89),8_90)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverf lowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111))),and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125))) [or] 257 : FUNCTION (145, 256) (no column) Nullable(UInt8) or(or(or(and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48))),and(and(greater(CAST(checkDecimalOv erflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69))),or(or(and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_ 86),1000_85),27_87,6_88),Nullable(I_89),8_90)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111))),and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125)))) [or] 258 : COLUMN () Const(Int64) Int64 1_126 259 : COLUMN () Const(Int64) Int64 0_127 260 : FUNCTION (257, 258, 259) (no column) Int64 if(or(or(or(and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48))),and(and(greater(CAST(checkDecimalOver flowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69))),or(or(and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86 ),1000_85),27_87,6_88),Nullable(I_89),8_90)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111))),and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125)))),1_126,0_127) [if] 261 : ALIAS (260) (no column) Int64 if(or(or(or(and(lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_14),Nullable(Decimal(44, 23))_16),1000_15),27_17,6_18),Nullable(I_19),10_20),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_21),Nullable(Decimal(44, 23))_23),1000_22),27_24,6_25),Nullable(I_26),5_27)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_28),Nullable(Decimal(44, 23))_30),1000_29),27_31,6_32),Nullable(I_33),10_34),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_35),Nullable(Decimal(44, 23))_37),1000_36),27_38,6_39),Nullable(I_40),15_41)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_42),Nullable(Decimal(44, 23))_44),1000_43),27_45,6_46),Nullable(I_47),6_48))),and(and(greater(CAST(checkDecimalOverflowSparkOrNu ll(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_49),Nullable(Decimal(44, 23))_51),1000_50),27_52,6_53),Nullable(I_54),15_55),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_56),Nullable(Decimal(44, 23))_58),1000_57),27_59,6_60),Nullable(I_61),25_62)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_63),Nullable(Decimal(44, 23))_65),1000_64),27_66,6_67),Nullable(I_68),7_69))),or(or(and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_70),Nullable(Decimal(44, 23))_72),1000_71),27_73,6_74),Nullable(I_75),25_76),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_77),Nullable(Decimal(44, 23))_79),1000_78),27_80,6_81),Nullable(I_82),40_83)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_84),Nullable(Decimal(44, 23))_86),1000_85),27 _87,6_88),Nullable(I_89),8_90)),and(and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_91),Nullable(Decimal(44, 23))_93),1000_92),27_94,6_95),Nullable(I_96),40_97),lessOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_98),Nullable(Decimal(44, 23))_100),1000_99),27_101,6_102),Nullable(I_103),60_104)),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_105),Nullable(Decimal(44, 23))_107),1000_106),27_108,6_109),Nullable(I_110),10_111))),and(greater(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(duration,Nullable(D_112),Nullable(Decimal(44, 23))_114),1000_113),27_115,6_116),Nullable(I_117),60_118),greaterOrEquals(CAST(checkDecimalOverflowSparkOrNull(sparkDivideDecimal(CAST(CAST(timewatch,Nullable(D_119),Nullable(Decimal(44, 23))_121),1000_120),27_122,6_123),Nullable(I_124),12_125)))),1_126,0_127) Output nodes: 10 0 1 2 3 4 5 6 8 22 34 261 ``` ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
