http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out b/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out index 3fb3203..1b927f8 100644 --- a/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out +++ b/ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out @@ -1227,56 +1227,56 @@ LIMIT 50 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -51 -51.0 1969-12-31 15:59:43.64 -7196 -1339164819 4992406445232 NULL NULL 7196 -14392 -7196 NULL NULL 51.0 6.4051596E8 -5.157308006568995E-5 51 -1.5598627 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:45.978 -7196 -2128720310 7935869315680 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:47.15 -7196 628698169 -2343786774032 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:57.86 -7196 -26309289 98081029392 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 15:59:58.479 -7196 -1379694191 5143499944048 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 16:00:03.963 -7196 95444104 -355815619712 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -52 -52.0 1969-12-31 16:00:04.518 -7196 -1658319459 6182214943152 NULL NULL 7196 -14392 -7196 NULL NULL 52.0 6.4051596E8 -5.258431692972308E-5 52 -1.5298654 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 15:59:48.882 -7196 -1560660031 5818140595568 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.5010000 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 15:59:57.663 -7196 898472381 -3349505036368 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.5010000 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -53 -53.0 1969-12-31 16:00:11.36 -7196 -1357789899 5061840743472 NULL NULL 7196 -14392 -7196 NULL NULL 53.0 6.4051596E8 -5.359555379375622E-5 53 -1.5010000 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 15:59:53.657 -7196 1476582815 -5504700734320 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:05.688 -7196 1614836149 -6020109163472 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:06.484 -7196 1605976008 -5987078557824 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -54 -54.0 1969-12-31 16:00:11.198 -7196 1650677402 -6153725354656 NULL NULL 7196 -14392 -7196 NULL NULL 54.0 6.4051596E8 -5.4606790657789354E-5 54 -1.4732037 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 15:59:43.932 -7196 1982381637 -7390318742736 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464182 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 16:00:01.138 -7196 888532643 -3312449693104 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464182 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -55 -55.0 1969-12-31 16:00:13.249 -7196 -685064281 2553919639568 NULL NULL 7196 -14392 -7196 NULL NULL 55.0 6.4051596E8 -5.561802752182249E-5 55 -1.4464182 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -56 -56.0 1969-12-31 16:00:02.298 -7196 -1509994296 5629258735488 NULL NULL 7196 -14392 -7196 NULL NULL 56.0 6.4051596E8 -5.6629264385855625E-5 56 -1.4205893 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 15:59:44.539 -7196 1839592407 -6858000493296 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956667 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:04.659 -7196 -1579093262 5886859680736 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956667 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:05.5 -7196 2042351711 -7613887178608 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956667 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -57 -57.0 1969-12-31 16:00:12.626 -7196 248308622 -925694542816 NULL NULL 7196 -14392 -7196 NULL NULL 57.0 6.4051596E8 -5.764050124988876E-5 57 -1.3956667 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 15:59:47.859 -7196 -1770443874 6600214762272 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 15:59:55.857 -7196 -825174557 3076250748496 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -58 -58.0 1969-12-31 16:00:12.065 -7196 1257970504 -4689714038912 NULL NULL 7196 -14392 -7196 NULL NULL 58.0 6.4051596E8 -5.86517381139219E-5 58 -1.3716034 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -59 -59.0 1969-12-31 16:00:13.15 -7196 -1604890000 5983029920000 NULL NULL 7196 -14392 -7196 NULL NULL 59.0 6.4051596E8 -5.966297497795504E-5 59 -1.3483559 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:45.385 -7196 1775867066 -6620432422048 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:52.408 -7196 1516314750 -5652821388000 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 15:59:55.806 -7196 -1802243330 6718763134240 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -60 -60.0 1969-12-31 16:00:10.618 -7196 -68838726 256630770528 NULL NULL 7196 -14392 -7196 NULL NULL 60.0 6.4051596E8 -6.0674211841988174E-5 60 -1.3258833 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 15:59:44.823 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 15:59:48.035 -7196 1237548317 -4613580125776 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:03.049 -7196 -1513172815 5641108254320 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:06.848 -7196 1415466231 -5276858109168 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:11.842 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:12.454 -7196 -2175533 8110387024 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -61 -61.0 1969-12-31 16:00:14.192 -7196 -2114172148 7881633767744 NULL NULL 7196 -14392 -7196 NULL NULL 61.0 6.4051596E8 -6.16854487060213E-5 61 -1.3041475 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 15:59:58.395 -7196 -1367753794 5098986144032 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:01.22 -7196 1670449519 -6227435806832 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:02.373 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:03.85 -7196 -642836823 2396495676144 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:09.025 -7196 -840223244 3132352253632 NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -62 -62.0 1969-12-31 16:00:12.388 -7196 NULL NULL NULL NULL 7196 -14392 -7196 NULL NULL 62.0 6.4051596E8 -6.269668557005445E-5 62 -1.2831129 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:03.552 -7196 -1224023895 4563161080560 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:07.375 -7196 -1711796768 6381578351104 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -63 -63.0 1969-12-31 16:00:11.946 -7196 -994504916 3707514326848 NULL NULL 7196 -14392 -7196 NULL NULL 63.0 6.4051596E8 -6.370792243408759E-5 63 -1.2627460 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 15:59:56.048 -7196 406535485 -1515564288080 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.2430156 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:01.785 -7196 -1639157869 6110780535632 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.2430156 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:11.912 -7196 -1615920595 6024151978160 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.2430156 -NULL -7196.0 1969-12-31 15:59:58.174 NULL false -64 -64.0 1969-12-31 16:00:12.339 -7196 1805860756 -6732248898368 NULL NULL 7196 -14392 -7196 NULL NULL 64.0 6.4051596E8 -6.471915929812072E-5 64 -1.2430156 +-1000804087 NULL NULL H8LCu4M2u4f1S true -51 -51.0 1969-12-31 16:00:08.451 NULL -873515594 3256466134432 1000804087 1000803223.743 NULL NULL NULL 1.0 1000803250.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1003789565 NULL NULL dq1Ji5vGb4GVow42 false -51 -51.0 1969-12-31 16:00:08.451 NULL -505400643 1884133597104 1003789565 1003788701.743 NULL NULL NULL 1.0 1003788728.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1012011232 NULL NULL 7q0iMi2GDq0Q false 11 11.0 1969-12-31 16:00:02.351 NULL -806973080 3008395642240 1012011232 1012010368.743 NULL NULL NULL 1.0 1012010395.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1015510885 NULL NULL Kw7fOuw4DHeyXe2yg false -51 -51.0 1969-12-31 16:00:08.451 NULL -67812054 252803337312 1015510885 1015510021.743 NULL NULL NULL 1.0 1015510048.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1016835101 NULL NULL Md2lY0T7reBu false 8 8.0 1969-12-31 16:00:15.892 NULL -491294009 1831544065552 1016835101 1016834237.743 NULL NULL NULL 1.0 1016834264.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1017266554 NULL NULL DU1m68i1Q7W3 false -51 -51.0 1969-12-31 16:00:08.451 NULL -145067516 540811699648 1017266554 1017265690.743 NULL NULL NULL 1.0 1017265717.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1020120834 NULL NULL 6Ob80MBP350rI275 true 8 8.0 1969-12-31 16:00:15.892 NULL -100465694 374536107232 1020120834 1020119970.743 NULL NULL NULL 1.0 1020119997.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1020466796 NULL NULL 7hCJ5yJvt0775jjgq8S0bX6W false 11 11.0 1969-12-31 16:00:02.351 NULL -926772952 3455009565056 1020466796 1020465932.743 NULL NULL NULL 1.0 1020465959.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1023165277 NULL NULL 438Lxo541TwY5ID80cnR5 false 11 11.0 1969-12-31 16:00:02.351 NULL -1004780673 3745822348944 1023165277 1023164413.743 NULL NULL NULL 1.0 1023164440.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1023644243 NULL NULL Cxas82oA2hX884xmYQ2jrpDX true 11 11.0 1969-12-31 16:00:02.351 NULL -866431241 3230055666448 1023644243 1023643379.743 NULL NULL NULL 1.0 1023643406.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1024321144 NULL NULL CE22Wjuk7d20ouN true 8 8.0 1969-12-31 16:00:15.892 NULL -94624654 352760710112 1024321144 1024320280.743 NULL NULL NULL 1.0 1024320307.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1026019772 NULL NULL T6Al7d0hN770XB65M0F2g true 11 11.0 1969-12-31 16:00:02.351 NULL -338489479 1261888777712 1026019772 1026018908.743 NULL NULL NULL 1.0 1026018935.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1039292315 NULL NULL 07488p5vb4d2 true 8 8.0 1969-12-31 16:00:15.892 NULL -432155916 1611077254848 1039292315 1039291451.743 NULL NULL NULL 1.0 1039291478.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1039495786 NULL NULL b0BEyNEe1bvQ true 8 8.0 1969-12-31 16:00:15.892 NULL -760564106 2835382987168 1039495786 1039494922.743 NULL NULL NULL 1.0 1039494949.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1039715238 NULL NULL oOt2v true -51 -51.0 1969-12-31 16:00:08.451 NULL -86361999 321957532272 1039715238 1039714374.743 NULL NULL NULL 1.0 1039714401.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1041353707 NULL NULL 25Qky6lf2pt5FP47Mqmb true 11 11.0 1969-12-31 16:00:02.351 NULL -931949639 3474308254192 1041353707 1041352843.743 NULL NULL NULL 1.0 1041352870.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1043979188 NULL NULL 2d3tQdCGQN5k7u7S false 11 11.0 1969-12-31 16:00:02.351 NULL -8894336 33158084608 1043979188 1043978324.743 NULL NULL NULL 1.0 1043978351.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1046913669 NULL NULL 40r4yyU6T0A0Mekf24k false 8 8.0 1969-12-31 16:00:15.892 NULL -90393132 336985596096 1046913669 1046912805.743 NULL NULL NULL 1.0 1046912832.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1047036113 NULL NULL Js07yFa2qnrfVU1j2e3 false 11 11.0 1969-12-31 16:00:02.351 NULL -240113848 895144425344 1047036113 1047035249.743 NULL NULL NULL 1.0 1047035276.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1048097158 NULL NULL fpt3gpLE true 11 11.0 1969-12-31 16:00:02.351 NULL -234579722 874513203616 1048097158 1048096294.743 NULL NULL NULL 1.0 1048096321.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1049984461 NULL NULL qUY8Rl34NWRg false 8 8.0 1969-12-31 16:00:15.892 NULL -247067895 921069112560 1049984461 1049983597.743 NULL NULL NULL 1.0 1049983624.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1054849160 NULL NULL CEGOy true 11 11.0 1969-12-31 16:00:02.351 NULL -1027630923 3831008080944 1054849160 1054848296.743 NULL NULL NULL 1.0 1054848323.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1055185482 NULL NULL l20vn2Awc true 11 11.0 1969-12-31 16:00:02.351 NULL -398806473 1486750531344 1055185482 1055184618.743 NULL NULL NULL 1.0 1055184645.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1058286942 NULL NULL R6q656btrqQM6a5nQ4GcVg true 8 8.0 1969-12-31 16:00:15.892 NULL -922041114 3437369272992 1058286942 1058286078.743 NULL NULL NULL 1.0 1058286105.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1058897881 NULL NULL 6fPk0A false 8 8.0 1969-12-31 16:00:15.892 NULL -800997317 2986117997776 1058897881 1058897017.743 NULL NULL NULL 1.0 1058897044.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1060624784 NULL NULL Das7E73 true -51 -51.0 1969-12-31 16:00:08.451 NULL -941434751 3509668751728 1060624784 1060623920.743 NULL NULL NULL 1.0 1060623947.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-1063164541 NULL NULL 1NydRD5y5o3 false 8 8.0 1969-12-31 16:00:15.892 NULL -74907656 279255741568 1063164541 1063163677.743 NULL NULL NULL 1.0 1063163704.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1063745167 NULL NULL L47nqo true 8 8.0 1969-12-31 16:00:15.892 NULL -68741114 256266872992 1063745167 1063744303.743 NULL NULL NULL 1.0 1063744330.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1068247011 NULL NULL dPbX4jd1v47r1bB6506si false 8 8.0 1969-12-31 16:00:15.892 NULL -729456614 2719414256992 1068247011 1068246147.743 NULL NULL NULL 1.0 1068246174.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-1069103950 NULL NULL 41A0nYX72UOSfxO4053xy true 11 11.0 1969-12-31 16:00:02.351 NULL -927759444 3458687207232 1069103950 1069103086.743 NULL NULL NULL 1.0 1069103113.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-1069736047 NULL NULL k17Am8uPHWk02cEf1jet true 11 11.0 1969-12-31 16:00:02.351 NULL -453772520 1691663954560 1069736047 1069735183.743 NULL NULL NULL 1.0 1069735210.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-919940926 NULL NULL i1P3Wlat5EnBugL24oS4I3 true -51 -51.0 1969-12-31 16:00:08.451 NULL -533395388 1988498006464 919940926 919940062.743 NULL NULL NULL 1.0 919940089.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-923400421 NULL NULL MJ7Ej4tBYS8l2mK true 8 8.0 1969-12-31 16:00:15.892 NULL -67708318 252416609504 923400421 923399557.743 NULL NULL NULL 1.0 923399584.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-925336063 NULL NULL 060EnWLmWE4K8Pv false -51 -51.0 1969-12-31 16:00:08.451 NULL -477173411 1778902476208 925336063 925335199.743 NULL NULL NULL 1.0 925335226.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-928500968 NULL NULL 34oSgU32X true 8 8.0 1969-12-31 16:00:15.892 NULL -831143834 3098504213152 928500968 928500104.743 NULL NULL NULL 1.0 928500131.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-930153712 NULL NULL Jj21024T2xdn6 false 11 11.0 1969-12-31 16:00:02.351 NULL -737116859 2747971650352 930153712 930152848.743 NULL NULL NULL 1.0 930152875.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-930463965 NULL NULL ldk1K false 11 11.0 1969-12-31 16:00:02.351 NULL -414014176 1543444848128 930463965 930463101.743 NULL NULL NULL 1.0 930463128.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-932998902 NULL NULL kAr0ffWGEU7MHSKp true 8 8.0 1969-12-31 16:00:15.892 NULL -230462122 859162790816 932998902 932998038.743 NULL NULL NULL 1.0 932998065.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-937557606 NULL NULL 2251WSv5eA2l6WqesdKPM2 true 8 8.0 1969-12-31 16:00:15.892 NULL -532708003 1985935435184 937557606 937556742.743 NULL NULL NULL 1.0 937556769.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-943342622 NULL NULL 3w6XYq04J0Lb3Sv82eOV2HJ true -51 -51.0 1969-12-31 16:00:08.451 NULL -750731096 2798725525888 943342622 943341758.743 NULL NULL NULL 1.0 943341785.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-949286785 NULL NULL XWuYuk5qpn5Khs3764E56 true -51 -51.0 1969-12-31 16:00:08.451 NULL -946341072 3527959516416 949286785 949285921.743 NULL NULL NULL 1.0 949285948.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-954917203 NULL NULL 1M4eTm8OcOW2dAMV2V5slS1 true -51 -51.0 1969-12-31 16:00:08.451 NULL -710267209 2647876155152 954917203 954916339.743 NULL NULL NULL 1.0 954916366.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-965597463 NULL NULL b0G65a66732y6yE65hQ0 false 8 8.0 1969-12-31 16:00:15.892 NULL -922745115 3439993788720 965597463 965596599.743 NULL NULL NULL 1.0 965596626.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-970640948 NULL NULL frhe0 false 11 11.0 1969-12-31 16:00:02.351 NULL -935612665 3487964015120 970640948 970640084.743 NULL NULL NULL 1.0 970640111.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-970918963 NULL NULL suoqdh false -51 -51.0 1969-12-31 16:00:08.451 NULL -588508542 2193959844576 970918963 970918099.743 NULL NULL NULL 1.0 970918126.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-978898374 NULL NULL ShA4jlmOwF8u7kjN false 11 11.0 1969-12-31 16:00:02.351 NULL -277483031 1034456739568 978898374 978897510.743 NULL NULL NULL 1.0 978897537.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-980072140 NULL NULL Jt7E0sR3X7V true -51 -51.0 1969-12-31 16:00:08.451 NULL -819889345 3056547478160 980072140 980071276.743 NULL NULL NULL 1.0 980071303.023 51.0 NULL -5.157308006568995E-5 51 -1.5598627 +-980511555 NULL NULL 1TBB2v0eBqlr4c7d true 8 8.0 1969-12-31 16:00:15.892 NULL -890261594 3318895222432 980511555 980510691.743 NULL NULL NULL 1.0 980510718.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 +-988289401 NULL NULL CeG187j false 11 11.0 1969-12-31 16:00:02.351 NULL -446065499 1662932180272 988289401 988288537.743 NULL NULL NULL 1.0 988288564.023 -11.0 NULL 1.1123605504364498E-5 -11 7.2320909 +-993291633 NULL NULL 8reJCOg48gHGHDs true 8 8.0 1969-12-31 16:00:15.892 NULL -861531376 3211788969728 993291633 993290769.743 NULL NULL NULL 1.0 993290796.023 -8.0 NULL 8.08989491226509E-6 -8 9.9441250 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT cint, cbigint, @@ -1764,81 +1764,81 @@ LIMIT 75 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -44.0 -1416000760 15601 NULL NULL -1416000716 1416000760 44.0 -2832001476 1.0 -15601.0 NULL -1.416016361E9 0.0315682 -7197.0 -15601 NULL -NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -48.0 -1683400285 15601 NULL NULL -1683400237 1683400285 48.0 -3366800522 1.0 -15601.0 NULL -1.683415886E9 0.0289375 -5582.0 -15601 NULL -NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -57.0 -1057361026 15601 NULL NULL -1057360969 1057361026 57.0 -2114721995 1.0 -15601.0 NULL -1.057376627E9 0.0243684 -3251.0 -15601 NULL -NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -62.0 -1726415169 15601 NULL NULL -1726415107 1726415169 62.0 -3452830276 1.0 -15601.0 NULL -1.72643077E9 0.0224032 -8509.0 -15601 NULL -NULL NULL NULL 1969-12-31 15:59:58.456 15601.0 -63.0 -1167054574 15601 NULL NULL -1167054511 1167054574 63.0 -2334109085 1.0 -15601.0 NULL -1.167070175E9 0.0220476 -6168.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -44.0 -1551649760 15601 NULL NULL -1551649716 1551649760 44.0 -3103299476 1.0 -15601.0 NULL -1.551665361E9 0.0315682 -5502.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -1022657523 15601 NULL NULL -1022657478 1022657523 45.0 -2045315001 1.0 -15601.0 NULL -1.022673124E9 0.0308667 -11973.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -1291025659 15601 NULL NULL -1291025614 1291025659 45.0 -2582051273 1.0 -15601.0 NULL -1.29104126E9 0.0308667 -11707.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -45.0 -831227593 15601 NULL NULL -831227548 831227593 45.0 -1662455141 1.0 -15601.0 NULL -8.31243194E8 0.0308667 -6313.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -46.0 -208932264 15601 NULL NULL -208932218 208932264 46.0 -417864482 1.0 -15601.0 NULL -2.08947865E8 0.0301957 -3672.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -46.0 -468932050 15601 NULL NULL -468932004 468932050 46.0 -937864054 1.0 -15601.0 NULL -4.68947651E8 0.0301957 -12793.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -47.0 -436916225 15601 NULL NULL -436916178 436916225 47.0 -873832403 1.0 -15601.0 NULL -4.36931826E8 0.0295532 -10220.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -47.0 -493471535 15601 NULL NULL -493471488 493471535 47.0 -986943023 1.0 -15601.0 NULL -4.93487136E8 0.0295532 -11905.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1228417392 15601 NULL NULL -1228417344 1228417392 48.0 -2456834736 1.0 -15601.0 NULL -1.228432993E9 0.0289375 -10253.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1294837001 15601 NULL NULL -1294836953 1294837001 48.0 -2589673954 1.0 -15601.0 NULL -1.294852602E9 0.0289375 -804.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -1427685796 15601 NULL NULL -1427685748 1427685796 48.0 -2855371544 1.0 -15601.0 NULL -1.427701397E9 0.0289375 -7084.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -48.0 -803222928 15601 NULL NULL -803222880 803222928 48.0 -1606445808 1.0 -15601.0 NULL -8.03238529E8 0.0289375 -5443.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -49.0 -1841324115 15601 NULL NULL -1841324066 1841324115 49.0 -3682648181 1.0 -15601.0 NULL -1.841339716E9 0.0283469 -489.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -49.0 -230127703 15601 NULL NULL -230127654 230127703 49.0 -460255357 1.0 -15601.0 NULL -2.30143304E8 0.0283469 -12953.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -50.0 -596103241 15601 NULL NULL -596103191 596103241 50.0 -1192206432 1.0 -15601.0 NULL -5.96118842E8 0.0277800 -4632.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -51.0 -546830045 15601 NULL NULL -546829994 546830045 51.0 -1093660039 1.0 -15601.0 NULL -5.46845646E8 0.0272353 -14995.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -52.0 -2097289702 15601 NULL NULL -2097289650 2097289702 52.0 -4194579352 1.0 -15601.0 NULL -2.097305303E9 0.0267115 -469.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -52.0 -886068046 15601 NULL NULL -886067994 886068046 52.0 -1772136040 1.0 -15601.0 NULL -8.86083647E8 0.0267115 -9251.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -1114169807 15601 NULL NULL -1114169753 1114169807 54.0 -2228339560 1.0 -15601.0 NULL -1.114185408E9 0.0257222 -8791.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -1754189160 15601 NULL NULL -1754189106 1754189160 54.0 -3508378266 1.0 -15601.0 NULL -1.754204761E9 0.0257222 -12720.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -54.0 -989710558 15601 NULL NULL -989710504 989710558 54.0 -1979421062 1.0 -15601.0 NULL -9.89726159E8 0.0257222 -14320.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -1105322173 15601 NULL NULL -1105322117 1105322173 56.0 -2210644290 1.0 -15601.0 NULL -1.105337774E9 0.0248036 -6924.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -1466363382 15601 NULL NULL -1466363326 1466363382 56.0 -2932726708 1.0 -15601.0 NULL -1.466378983E9 0.0248036 -9791.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -56.0 -865054294 15601 NULL NULL -865054238 865054294 56.0 -1730108532 1.0 -15601.0 NULL -8.65069895E8 0.0248036 -10046.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -1698345590 15601 NULL NULL -1698345533 1698345590 57.0 -3396691123 1.0 -15601.0 NULL -1.698361191E9 0.0243684 -5129.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -2123576095 15601 NULL NULL -2123576038 2123576095 57.0 -4247152133 1.0 -15601.0 NULL -2.123591696E9 0.0243684 -14778.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -304247740 15601 NULL NULL -304247683 304247740 57.0 -608495423 1.0 -15601.0 NULL -3.04263341E8 0.0243684 -12639.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -57.0 -365505703 15601 NULL NULL -365505646 365505703 57.0 -731011349 1.0 -15601.0 NULL -3.65521304E8 0.0243684 -5475.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -59.0 -2021724111 15601 NULL NULL -2021724052 2021724111 59.0 -4043448163 1.0 -15601.0 NULL -2.021739712E9 0.0235424 -6122.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -1016256928 15601 NULL NULL -1016256868 1016256928 60.0 -2032513796 1.0 -15601.0 NULL -1.016272529E9 0.0231500 -7788.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -1743144280 15601 NULL NULL -1743144220 1743144280 60.0 -3486288500 1.0 -15601.0 NULL -1.743159881E9 0.0231500 -13348.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -519753851 15601 NULL NULL -519753791 519753851 60.0 -1039507642 1.0 -15601.0 NULL -5.19769452E8 0.0231500 -6536.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -60.0 -5953872 15601 NULL NULL -5953812 5953872 60.0 -11907684 1.0 -15601.0 NULL -5969473.0 0.0231500 -9891.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -61.0 -982179838 15601 NULL NULL -982179777 982179838 61.0 -1964359615 1.0 -15601.0 NULL -9.82195439E8 0.0227705 -3282.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -63.0 -1574729892 15601 NULL NULL -1574729829 1574729892 63.0 -3149459721 1.0 -15601.0 NULL -1.574745493E9 0.0220476 -11755.0 -15601 NULL -NULL NULL false 1969-12-31 15:59:58.456 15601.0 -63.0 -1996001975 15601 NULL NULL -1996001912 1996001975 63.0 -3992003887 1.0 -15601.0 NULL -1.996017576E9 0.0220476 -10035.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -44.0 -1447719201 15601 NULL NULL -1447719157 1447719201 44.0 -2895438358 1.0 -15601.0 NULL -1.447734802E9 0.0315682 -8805.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -47.0 -1828371599 15601 NULL NULL -1828371552 1828371599 47.0 -3656743151 1.0 -15601.0 NULL -1.8283872E9 0.0295532 -12404.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -1465907371 15601 NULL NULL -1465907323 1465907371 48.0 -2931814694 1.0 -15601.0 NULL -1.465922972E9 0.0289375 -6209.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -1666377780 15601 NULL NULL -1666377732 1666377780 48.0 -3332755512 1.0 -15601.0 NULL -1.666393381E9 0.0289375 -3768.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -48.0 -652336471 15601 NULL NULL -652336423 652336471 48.0 -1304672894 1.0 -15601.0 NULL -6.52352072E8 0.0289375 -11858.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -197652849 15601 NULL NULL -197652800 197652849 49.0 -395305649 1.0 -15601.0 NULL -1.9766845E8 0.0283469 -3780.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -211726367 15601 NULL NULL -211726318 211726367 49.0 -423452685 1.0 -15601.0 NULL -2.11741968E8 0.0283469 -5196.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -57200424 15601 NULL NULL -57200375 57200424 49.0 -114400799 1.0 -15601.0 NULL -5.7216025E7 0.0283469 -7158.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -668597606 15601 NULL NULL -668597557 668597606 49.0 -1337195163 1.0 -15601.0 NULL -6.68613207E8 0.0283469 -1150.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -49.0 -990904667 15601 NULL NULL -990904618 990904667 49.0 -1981809285 1.0 -15601.0 NULL -9.90920268E8 0.0283469 -7152.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -50.0 -458110015 15601 NULL NULL -458109965 458110015 50.0 -916219980 1.0 -15601.0 NULL -4.58125616E8 0.0277800 -2251.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -52.0 -2074134645 15601 NULL NULL -2074134593 2074134645 52.0 -4148269238 1.0 -15601.0 NULL -2.074150246E9 0.0267115 -12897.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -1795674990 15601 NULL NULL -1795674936 1795674990 54.0 -3591349926 1.0 -15601.0 NULL -1.795690591E9 0.0257222 -15491.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -1984659810 15601 NULL NULL -1984659756 1984659810 54.0 -3969319566 1.0 -15601.0 NULL -1.984675411E9 0.0257222 -9797.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -54.0 -641670659 15601 NULL NULL -641670605 641670659 54.0 -1283341264 1.0 -15601.0 NULL -6.4168626E8 0.0257222 -1529.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1062767051 15601 NULL NULL -1062766996 1062767051 55.0 -2125534047 1.0 -15601.0 NULL -1.062782652E9 0.0252545 -11330.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1338667765 15601 NULL NULL -1338667710 1338667765 55.0 -2677335475 1.0 -15601.0 NULL -1.338683366E9 0.0252545 -8359.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -55.0 -1483320156 15601 NULL NULL -1483320101 1483320156 55.0 -2966640257 1.0 -15601.0 NULL -1.483335757E9 0.0252545 -8278.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -56.0 -1683701844 15601 NULL NULL -1683701788 1683701844 56.0 -3367403632 1.0 -15601.0 NULL -1.683717445E9 0.0248036 -10722.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -56.0 -971846497 15601 NULL NULL -971846441 971846497 56.0 -1943692938 1.0 -15601.0 NULL -9.71862098E8 0.0248036 -13404.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -57.0 -585350546 15601 NULL NULL -585350489 585350546 57.0 -1170701035 1.0 -15601.0 NULL -5.85366147E8 0.0243684 -1026.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -58.0 -1072335429 15601 NULL NULL -1072335371 1072335429 58.0 -2144670800 1.0 -15601.0 NULL -1.07235103E9 0.0239483 -694.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -58.0 -1560616588 15601 NULL NULL -1560616530 1560616588 58.0 -3121233118 1.0 -15601.0 NULL -1.560632189E9 0.0239483 -1755.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -59.0 -1315413812 15601 NULL NULL -1315413753 1315413812 59.0 -2630827565 1.0 -15601.0 NULL -1.315429413E9 0.0235424 -15497.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -59.0 -133287350 15601 NULL NULL -133287291 133287350 59.0 -266574641 1.0 -15601.0 NULL -1.33302951E8 0.0235424 -8007.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -60.0 -2041965187 15601 NULL NULL -2041965127 2041965187 60.0 -4083930314 1.0 -15601.0 NULL -2.041980788E9 0.0231500 -12701.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -60.0 -903925845 15601 NULL NULL -903925785 903925845 60.0 -1807851630 1.0 -15601.0 NULL -9.03941446E8 0.0231500 -3905.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -61.0 -1022679553 15601 NULL NULL -1022679492 1022679553 61.0 -2045359045 1.0 -15601.0 NULL -1.022695154E9 0.0227705 -2801.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -61.0 -854893578 15601 NULL NULL -854893517 854893578 61.0 -1709787095 1.0 -15601.0 NULL -8.54909179E8 0.0227705 -5581.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -62.0 -1592016120 15601 NULL NULL -1592016058 1592016120 62.0 -3184032178 1.0 -15601.0 NULL -1.592031721E9 0.0224032 -12075.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -62.0 667693308 15601 NULL NULL 667693370 -667693308 62.0 1335386678 1.0 -15601.0 NULL 6.67677707E8 0.0224032 1710.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -63.0 -200542601 15601 NULL NULL -200542538 200542601 63.0 -401085139 1.0 -15601.0 NULL -2.00558202E8 0.0220476 -7347.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -63.0 -721244708 15601 NULL NULL -721244645 721244708 63.0 -1442489353 1.0 -15601.0 NULL -7.21260309E8 0.0220476 -10478.0 -15601 NULL -NULL NULL true 1969-12-31 15:59:58.456 15601.0 -64.0 -1809291815 15601 NULL NULL -1809291751 1809291815 64.0 -3618583566 1.0 -15601.0 NULL -1.809307416E9 0.0217031 -12643.0 -15601 NULL +-104148943 tEO4vj3G true 1969-12-31 15:59:44.53 2248.0 NULL 1864027286 2248 false -104146695 NULL -1864027286 NULL NULL 1.0 -2248.0 194132281226719770 1.864025038E9 NULL 1422.0 -2248 -104144447 +-110450673 uv5m1sFX10 true 1969-12-31 16:00:16.376 -8148.0 NULL 1864027286 -8148 true -110458821 NULL -1864027286 NULL NULL 1.0 8148.0 205898256323389806 1.864035434E9 NULL 1178.0 8148 -110466969 +-128417177 ygkC2e2sUm2036Sd1U8kCG62 true 1969-12-31 16:00:01.936 -8871.0 NULL 1864027286 -8871 false -128426048 NULL -1864027286 NULL NULL 1.0 8871.0 239389657705145728 1.864036157E9 NULL 8411.0 8871 -128434919 +-129248849 w3OO7InLN4ic3M0h8xpvuBMn true 1969-12-31 15:59:48.413 3255.0 NULL 1864027286 3255 true -129245594 NULL -1864027286 NULL NULL 1.0 -3255.0 240917313811277884 1.864024031E9 NULL 2711.0 -3255 -129242339 +-140351494 xh0Qhj80MAcHEMVKx true 1969-12-31 16:00:14.98 -11115.0 NULL 1864027286 -11115 true -140362609 NULL -1864027286 NULL NULL 1.0 11115.0 261639733110149174 1.864038401E9 NULL 8441.0 11115 -140373724 +-198739996 uxnt0fsrBtPD807 true 1969-12-31 16:00:11.528 -14709.0 NULL 1864027286 -14709 false -198754705 NULL -1864027286 NULL NULL 1.0 14709.0 370484193340880630 1.864041995E9 NULL 14552.0 14709 -198769414 +-203191502 wK0N1nX22KSjcTVhDYq true 1969-12-31 15:59:49.907 -6663.0 NULL 1864027286 -6663 true -203198165 NULL -1864027286 NULL NULL 1.0 6663.0 378766924025130190 1.864033949E9 NULL 6395.0 6663 -203204828 +-25028803 x8n40D35c65l true 1969-12-31 15:59:43.775 -4002.0 NULL 1864027286 -4002 true -25032805 NULL -1864027286 NULL NULL 1.0 4002.0 46661831565117230 1.864031288E9 NULL 3740.0 4002 -25036807 +-315135285 y4jD1v2Go true 1969-12-31 15:59:43.97 -4683.0 NULL 1864027286 -4683 false -315139968 NULL -1864027286 NULL NULL 1.0 4683.0 587429499261166848 1.864031969E9 NULL 1283.0 4683 -315144651 +-360475292 uq2hp true 1969-12-31 16:00:10.933 -1007.0 NULL 1864027286 -1007 false -360476299 NULL -1864027286 NULL NULL 1.0 1007.0 671937657292294514 1.864028293E9 NULL 803.0 1007 -360477306 +-362733967 tUi8QYP4S53YPcw true 1969-12-31 16:00:00.003 -7959.0 NULL 1864027286 -7959 true -362741926 NULL -1864027286 NULL NULL 1.0 7959.0 676160847840192836 1.864035245E9 NULL 5609.0 7959 -362749885 +-367195514 t5805L0xlU0YM true 1969-12-31 15:59:43.799 -13339.0 NULL 1864027286 -13339 false -367208853 NULL -1864027286 NULL NULL 1.0 13339.0 684487321652762958 1.864040625E9 NULL 8748.0 13339 -367222192 +-370283300 x0w77gi6iqtTQ1 true 1969-12-31 15:59:44.652 1850.0 NULL 1864027286 1850 true -370281450 NULL -1864027286 NULL NULL 1.0 -1850.0 690214726299644700 1.864025436E9 NULL 586.0 -1850 -370279600 +-372506148 utfrK57P2tp0 true 1969-12-31 16:00:05.326 -12525.0 NULL 1864027286 -12525 false -372518673 NULL -1864027286 NULL NULL 1.0 12525.0 694384971016511478 1.864039811E9 NULL 6686.0 12525 -372531198 +-380733719 t7s5did true NULL -2120.0 NULL 1864027286 -2120 false -380735839 NULL -1864027286 NULL NULL 1.0 2120.0 709701992654102954 1.864029406E9 NULL 326.0 2120 -380737959 +-412772386 uO4aN4J0dKv3717r8fPG true 1969-12-31 16:00:07.824 -11809.0 NULL 1864027286 -11809 true -412784195 NULL -1864027286 NULL NULL 1.0 11809.0 769441002709544770 1.864039095E9 NULL 254.0 11809 -412796004 +-452599200 v4L3dR650oy4O8MPhjc true 1969-12-31 15:59:46.988 8757.0 NULL 1864027286 8757 false -452590443 NULL -1864027286 NULL NULL 1.0 -8757.0 843640935134827698 1.864018529E9 NULL 3509.0 -8757 -452581686 +-459571311 taArL704d542R82qw8 true 1969-12-31 16:00:00.738 -13901.0 NULL 1864027286 -13901 false -459585212 NULL -1864027286 NULL NULL 1.0 13901.0 856679375410094632 1.864041187E9 NULL 493.0 13901 -459599113 +-487903609 tINcSR1MT3f2P4 true 1969-12-31 16:00:12.099 -9147.0 NULL 1864027286 -9147 false -487912756 NULL -1864027286 NULL NULL 1.0 9147.0 909482690371460216 1.864036433E9 NULL 5891.0 9147 -487921903 +-518918140 ugq0uAy0qXj2D0fX true 1969-12-31 16:00:12.479 5245.0 NULL 1864027286 5245 false -518912895 NULL -1864027286 NULL NULL 1.0 -5245.0 967267795337252970 1.864022041E9 NULL 1491.0 -5245 -518907650 +-520054643 wc4Ae163B5VxG2L true 1969-12-31 16:00:06.693 301.0 NULL 1864027286 301 true -520054342 NULL -1864027286 NULL NULL 1.0 -301.0 969395483690775812 1.864026985E9 NULL 205.0 -301 -520054041 +-520765672 vQalqQ true 1969-12-31 15:59:44.48 -3969.0 NULL 1864027286 -3969 false -520769641 NULL -1864027286 NULL NULL 1.0 3969.0 970728820544424326 1.864031255E9 NULL 2312.0 3969 -520773610 +-532611088 wLWrtVNx188P7uXPV true 1969-12-31 16:00:04.012 -1428.0 NULL 1864027286 -1428 false -532612516 NULL -1864027286 NULL NULL 1.0 1428.0 992804262689111576 1.864028714E9 NULL 338.0 1428 -532613944 +-553779656 weQ0d24K116Y0 true 1969-12-31 16:00:12.009 11147.0 NULL 1864027286 11147 true -553768509 NULL -1864027286 NULL NULL 1.0 -11147.0 1032239610903536574 1.864016139E9 NULL 3652.0 -11147 -553757362 +-601825532 v4gQqo0bxX256o7EEN42lSoU true 1969-12-31 15:59:58.417 11021.0 NULL 1864027286 11021 false -601814511 NULL -1864027286 NULL NULL 1.0 -11021.0 1121798669614747146 1.864016265E9 NULL 1472.0 -11021 -601803490 +-64947310 vvictFVSOgi true 1969-12-31 15:59:48.172 6612.0 NULL 1864027286 6612 false -64940698 NULL -1864027286 NULL NULL 1.0 -6612.0 121051233043885628 1.864020674E9 NULL 5306.0 -6612 -64934086 +-719899789 umNykRkKiih6Cx6K42 true 1969-12-31 15:59:55.878 -10134.0 NULL 1864027286 -10134 true -719909923 NULL -1864027286 NULL NULL 1.0 10134.0 1341931739934158978 1.86403742E9 NULL 9728.0 10134 -719920057 +-758062600 vA0bEQqO50LlKcj7AAR56P63 true 1969-12-31 16:00:16.169 7111.0 NULL 1864027286 7111 false -758055489 NULL -1864027286 NULL NULL 1.0 -7111.0 1413036115798072854 1.864020175E9 NULL 6634.0 -7111 -758048378 +-770958258 uXu1mj3tWs36cGpu4p3aHq true 1969-12-31 15:59:56.944 8059.0 NULL 1864027286 8059 false -770950199 NULL -1864027286 NULL NULL 1.0 -8059.0 1437072207083129914 1.864019227E9 NULL 4763.0 -8059 -770942140 +-778541551 t66fkUkSNP78t2856Lcn true 1969-12-31 16:00:03.35 15678.0 NULL 1864027286 15678 true -778525873 NULL -1864027286 NULL NULL 1.0 -15678.0 1451193470128970678 1.864011608E9 NULL 7154.0 -15678 -778510195 +-804390280 uNJPm true 1969-12-31 16:00:12.321 -10737.0 NULL 1864027286 -10737 true -804401017 NULL -1864027286 NULL NULL 1.0 10737.0 1499425444574149862 1.864038023E9 NULL 8927.0 10737 -804411754 +-804959350 v2wRf43gpDUt1lfieq true 1969-12-31 16:00:08.659 -8072.0 NULL 1864027286 -8072 true -804967422 NULL -1864027286 NULL NULL 1.0 8072.0 1500481238949076692 1.864035358E9 NULL 686.0 8072 -804975494 +-87388872 veoqj217BlDBBVkN0ei3c true 1969-12-31 16:00:03.492 10039.0 NULL 1864027286 10039 false -87378833 NULL -1864027286 NULL NULL 1.0 -10039.0 162876528930837238 1.864017247E9 NULL 5844.0 -10039 -87368794 +-894394703 tFtQ26aDMi1tJ026luPcu true 1969-12-31 15:59:56.928 -3178.0 NULL 1864027286 -3178 true -894397881 NULL -1864027286 NULL NULL 1.0 3178.0 1667182054724580966 1.864030464E9 NULL 3166.0 3178 -894401059 +-933664265 ue8IUf0GlY18RT325P2tu true 1969-12-31 16:00:02.456 13750.0 NULL 1864027286 13750 false -933650515 NULL -1864027286 NULL NULL 1.0 -13750.0 1740350035547952290 1.864013536E9 NULL 8536.0 -13750 -933636765 +-947255611 vgKx505VdPsHO true 1969-12-31 15:59:46.062 13661.0 NULL 1864027286 13661 true -947241950 NULL -1864027286 NULL NULL 1.0 -13661.0 1765684841243847700 1.864013625E9 NULL 11158.0 -13661 -947228289 +1030560824 tmS75um6Mvyb6N1oiKP7 true 1969-12-31 15:59:53.233 -11073.0 NULL 1864027286 -11073 false 1030549751 NULL -1864027286 NULL NULL 1.0 11073.0 -1920972855444505786 1.864038359E9 NULL 9539.0 11073 1030538678 +108023602 veIw1kh7 true 1969-12-31 16:00:14.188 9239.0 NULL 1864027286 9239 true 108032841 NULL -1864027286 NULL NULL 1.0 -9239.0 -201376163408099526 1.864018047E9 NULL 3602.0 -9239 108042080 +136715714 y2Q3YW true 1969-12-31 15:59:50.737 11813.0 NULL 1864027286 11813 false 136727527 NULL -1864027286 NULL NULL 1.0 -11813.0 -254863841075301722 1.864015473E9 NULL 6764.0 -11813 136739340 +194353234 vtad71tYi1fs1e0tcJg0 true 1969-12-31 15:59:55.372 2960.0 NULL 1864027286 2960 true 194356194 NULL -1864027286 NULL NULL 1.0 -2960.0 -362285248819109484 1.864024326E9 NULL 2806.0 -2960 194359154 +200690208 wfT8d53abPxBj0L true 1969-12-31 16:00:15.522 -12052.0 NULL 1864027286 -12052 true 200678156 NULL -1864027286 NULL NULL 1.0 12052.0 -374069558488164616 1.864039338E9 NULL 4706.0 12052 200666104 +2101183 x7By66525 true 1969-12-31 16:00:05.831 -8915.0 NULL 1864027286 -8915 false 2092268 NULL -1864027286 NULL NULL 1.0 8915.0 -3900044641624648 1.864036201E9 NULL 7766.0 8915 2083353 +223484391 tca24E6L true 1969-12-31 16:00:02.505 -12721.0 NULL 1864027286 -12721 false 223471670 NULL -1864027286 NULL NULL 1.0 12721.0 -416557290527987620 1.864040007E9 NULL 6435.0 12721 223458949 +236934374 wiBqE2A1x8T8gcT4 true 1969-12-31 16:00:11.324 -15101.0 NULL 1864027286 -15101 false 236919273 NULL -1864027286 NULL NULL 1.0 15101.0 -441623989451283078 1.864042387E9 NULL 5149.0 15101 236904172 +245429195 vXc7m82uAg2g24 true 1969-12-31 15:59:57.185 -16001.0 NULL 1864027286 -16001 false 245413194 NULL -1864027286 NULL NULL 1.0 16001.0 -457456889960411484 1.864043287E9 NULL 6792.0 16001 245397193 +247204221 wblxBWSlwWlX7E true 1969-12-31 15:59:54.186 4502.0 NULL 1864027286 4502 true 247208723 NULL -1864027286 NULL NULL 1.0 -4502.0 -460803805009215778 1.864022784E9 NULL 1198.0 -4502 247213225 +252479879 tdUWi true 1969-12-31 16:00:01.806 -877.0 NULL 1864027286 -877 false 252479002 NULL -1864027286 NULL NULL 1.0 877.0 -470627748870048572 1.864028163E9 NULL 620.0 877 252478125 +304132102 vxAjxUq0k true 1969-12-31 16:00:03.466 -12962.0 NULL 1864027286 -12962 true 304119140 NULL -1864027286 NULL NULL 1.0 12962.0 -566886375154854040 1.864040248E9 NULL 952.0 12962 304106178 +308450217 t7i26BC11U1YTY8I0p true 1969-12-31 15:59:46.402 1017.0 NULL 1864027286 1017 true 308451234 NULL -1864027286 NULL NULL 1.0 -1017.0 -574961516576370924 1.864026269E9 NULL 530.0 -1017 308452251 +319983133 t78m7 true 1969-12-31 16:00:09.36 14512.0 NULL 1864027286 14512 true 319997645 NULL -1864027286 NULL NULL 1.0 -14512.0 -596484341735741470 1.864012774E9 NULL 4422.0 -14512 320012157 +336043289 xow6f03825H0h8mFjVr true 1969-12-31 15:59:51.587 -97.0 NULL 1864027286 -97 true 336043192 NULL -1864027286 NULL NULL 1.0 97.0 -626393679162536912 1.864027383E9 NULL 14.0 97 336043095 +336056067 tJ7bf true 1969-12-31 15:59:50.481 16124.0 NULL 1864027286 16124 false 336072191 NULL -1864027286 NULL NULL 1.0 -16124.0 -626447734089803626 1.864011162E9 NULL 12266.0 -16124 336088315 +396908469 uGD31tQ70Py2E0T true 1969-12-31 15:59:50.224 16084.0 NULL 1864027286 16084 false 396924553 NULL -1864027286 NULL NULL 1.0 -16084.0 -739878197275353158 1.864011202E9 NULL 4274.0 -16084 396940637 +421764768 whw6kHIbH true 1969-12-31 16:00:06.463 5142.0 NULL 1864027286 5142 true 421769910 NULL -1864027286 NULL NULL 1.0 -5142.0 -786190620653764260 1.864022144E9 NULL 866.0 -5142 421775052 +426284338 u6ELlhG3 true 1969-12-31 16:00:00.64 -15070.0 NULL 1864027286 -15070 true 426269268 NULL -1864027286 NULL NULL 1.0 15070.0 -794577546735246648 1.864042356E9 NULL 3916.0 15070 426254198 +434741484 uxI8i true 1969-12-31 16:00:12.505 8120.0 NULL 1864027286 8120 false 434749604 NULL -1864027286 NULL NULL 1.0 -8120.0 -810385124433694744 1.864019166E9 NULL 86.0 -8120 434757724 +460817498 v3A1iI77YBRwl3I16 true 1969-12-31 16:00:08.026 7391.0 NULL 1864027286 7391 true 460824889 NULL -1864027286 NULL NULL 1.0 -7391.0 -858990167163921254 1.864019895E9 NULL 2304.0 -7391 460832280 +466063930 w6OUE6V3UjfE2 true 1969-12-31 15:59:56.958 14276.0 NULL 1864027286 14276 true 466078206 NULL -1864027286 NULL NULL 1.0 -14276.0 -868782493393928916 1.86401301E9 NULL 9966.0 -14276 466092482 +526337887 t0346137k7Lk0O true 1969-12-31 15:59:51.609 15044.0 NULL 1864027286 15044 false 526352931 NULL -1864027286 NULL NULL 1.0 -15044.0 -981136225450075266 1.864012242E9 NULL 466.0 -15044 526367975 +54908166 wLIR3B37 true 1969-12-31 16:00:05.971 8499.0 NULL 1864027286 8499 true 54916665 NULL -1864027286 NULL NULL 1.0 -8499.0 -102366162016121190 1.864018787E9 NULL 1109.0 -8499 54925164 +573439687 vALXyM54AgSH4e0O4IN true 1969-12-31 16:00:10.069 -150.0 NULL 1864027286 -150 false 573439537 NULL -1864027286 NULL NULL 1.0 150.0 -1068906943839206582 1.864027436E9 NULL 86.0 150 573439387 +573476034 x1832l1R2m3V true 1969-12-31 15:59:49.722 -5070.0 NULL 1864027286 -5070 false 573470964 NULL -1864027286 NULL NULL 1.0 5070.0 -1068965524624723704 1.864032356E9 NULL 1226.0 5070 573465894 +58198060 t7Sx50XeM true 1969-12-31 16:00:07.889 7557.0 NULL 1864027286 7557 true 58205617 NULL -1864027286 NULL NULL 1.0 -7557.0 -108496858286465462 1.864019729E9 NULL 2552.0 -7557 58213174 +605953955 x5vy367f6d81FfL8AI8XJ true 1969-12-31 16:00:01.206 11683.0 NULL 1864027286 11683 false 605965638 NULL -1864027286 NULL NULL 1.0 -11683.0 -1129536483610398468 1.864015603E9 NULL 4636.0 -11683 605977321 +732924624 yxN0212hM17E8J8bJj8D7b true 1969-12-31 15:59:46.461 -6751.0 NULL 1864027286 -6751 false 732917873 NULL -1864027286 NULL NULL 1.0 6751.0 -1366178913669082678 1.864034037E9 NULL 1925.0 6751 732911122 +741306115 y1uSBY0 true 1969-12-31 15:59:56.456 -16032.0 NULL 1864027286 -16032 false 741290083 NULL -1864027286 NULL NULL 1.0 16032.0 -1381784941553204738 1.864043318E9 NULL 2678.0 16032 741274051 +746145173 wEe2THv60F6 true 1969-12-31 16:00:03.372 -5589.0 NULL 1864027286 -5589 true 746139584 NULL -1864027286 NULL NULL 1.0 5589.0 -1390824543740689024 1.864032875E9 NULL 773.0 5589 746133995 +773036466 xnk564ke0a7kay3aE6IC true 1969-12-31 16:00:12.369 -12066.0 NULL 1864027286 -12066 true 773024400 NULL -1864027286 NULL NULL 1.0 12066.0 -1440938574343778400 1.864039352E9 NULL 11276.0 12066 773012334 +773348268 vwb48kytjp0Q2YEb true 1969-12-31 15:59:44.909 12581.0 NULL 1864027286 12581 false 773360849 NULL -1864027286 NULL NULL 1.0 -12581.0 -1441565724460125814 1.864014705E9 NULL 1164.0 -12581 773373430 +855072260 y7S47c5V true 1969-12-31 16:00:08.381 -11734.0 NULL 1864027286 -11734 false 855060526 NULL -1864027286 NULL NULL 1.0 11734.0 -1593856151645512436 1.86403902E9 NULL 10982.0 11734 855048792 +86487282 vH8AHgcWaDm true 1969-12-31 16:00:10.869 13309.0 NULL 1864027286 13309 false 86500591 NULL -1864027286 NULL NULL 1.0 -13309.0 -161239461879126026 1.864013977E9 NULL 8673.0 -13309 86513900 +872474570 wT50ouOe760m3AyJ7x4p83U6 true 1969-12-31 15:59:46.57 -2856.0 NULL 1864027286 -2856 true 872471714 NULL -1864027286 NULL NULL 1.0 2856.0 -1626311081159188204 1.864030142E9 NULL 1766.0 2856 872468858 +936765787 wP0re2S74Y308jgOTc6 true 1969-12-31 15:59:50.924 -10311.0 NULL 1864027286 -10311 false 936755476 NULL -1864027286 NULL NULL 1.0 10311.0 -1746137767573918136 1.864037597E9 NULL 4706.0 10311 936745165 +95424126 txKwQS70d20 true 1969-12-31 16:00:16.343 9766.0 NULL 1864027286 9766 false 95433892 NULL -1864027286 NULL NULL 1.0 -9766.0 -177891378697177112 1.86401752E9 NULL 632.0 -9766 95443658 +97246854 vvK378scVFuBh8Q3HXUJsP true 1969-12-31 16:00:01.629 -9554.0 NULL 1864027286 -9554 true 97237300 NULL -1864027286 NULL NULL 1.0 9554.0 -181252980416967800 1.86403684E9 NULL 3670.0 9554 97227746 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT ctimestamp1, cstring2, @@ -2086,7 +2086,7 @@ POSTHOOK: Input: default@alltypesorc 1969-12-31 16:00:05.83 06Tj8f5xNhpaiE71AWqJ7b5 15601.0 -49.0 226841234 15601 63558.76548052676 -15858 315168.0 -15601.0 158740.17500000002 -6432.0 49.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:05.997 12AEw 15601.0 -64.0 1421812187 15601 398378.30961053516 -15858 411648.0 -15601.0 158740.17500000002 -6432.0 64.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:07.499 14MDiWrX 15601.0 -33.0 42147119 15601 11809.223592042588 -15858 212256.0 -15601.0 158740.17500000002 -6432.0 33.0 NULL -15601.0 -2.43391201E8 -1969-12-31 16:00:08.451 rVWAj4N1MCg8Scyp7wj2C NULL -51.0 -89010 NULL -24.93975903614458 NULL 328032.0 NULL NULL -6432.0 51.0 NULL NULL NULL +1969-12-31 16:00:08.488 16jmamsEtKc51n 15601.0 1.0 -832606494 15601 -233288.45446903896 -15858 -6432.0 -15601.0 158740.17500000002 -6432.0 -1.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:09.123 064GHv0UW8 15601.0 -14.0 1007181336 15601 282202.67189688986 -15858 90048.0 -15601.0 158740.17500000002 -6432.0 14.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:11.928 0UugmY0R5hI 15601.0 -32.0 1701987317 15601 476880.7276548053 -15858 205824.0 -15601.0 158740.17500000002 -6432.0 32.0 NULL -15601.0 -2.43391201E8 1969-12-31 16:00:12.853 12gbSP4px465TdXmV5F2apmC 15601.0 28.0 -1556827241 15601 -436208.2490893808 -15858 -180096.0 -15601.0 158740.17500000002 -6432.0 -28.0 NULL -15601.0 -2.43391201E8
http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out index 121c112..06fa804 100644 --- a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out +++ b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out @@ -197,7 +197,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -228,7 +228,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -476,7 +476,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -507,7 +507,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -665,7 +665,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -821,7 +821,7 @@ STAGE PLANS: Partition table definition input alias: abc name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -852,7 +852,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -1036,7 +1036,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -1067,7 +1067,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -1254,7 +1254,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -1294,7 +1294,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col0 raw input shape: window functions: @@ -1516,7 +1516,7 @@ STAGE PLANS: Partition table definition input alias: abc name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col0: int, _col1: string, _col2: string, _col3: string, _col4: string, _col5: int, _col6: string, _col7: double, _col8: string partition by: _col2 raw input shape: @@ -1758,7 +1758,7 @@ STAGE PLANS: Partition table definition input alias: abc name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col0: int, _col1: string, _col2: string, _col3: string, _col4: string, _col5: int, _col6: string, _col7: double, _col8: string partition by: _col2 raw input shape: @@ -1867,7 +1867,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: p_name ASC NULLS FIRST, p_size DESC NULLS LAST + order by: p_name ASC NULLS LAST, p_size DESC NULLS LAST output shape: p_name: string, p_mfgr: string, p_size: int partition by: p_mfgr raw input shape: @@ -1905,7 +1905,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST + order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -1936,7 +1936,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST + order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -2056,7 +2056,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: p_name ASC NULLS FIRST + order by: p_name ASC NULLS LAST output shape: p_name: string, p_mfgr: string, p_size: int, p_retailprice: double partition by: p_mfgr raw input shape: @@ -2095,7 +2095,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2127,7 +2127,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -2307,7 +2307,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2338,7 +2338,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -2521,7 +2521,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2535,7 +2535,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2543,7 +2543,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2575,7 +2575,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2583,7 +2583,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2614,7 +2614,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -2804,7 +2804,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -2835,7 +2835,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -3064,7 +3064,7 @@ STAGE PLANS: Partition table definition input alias: abc name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col0: int, _col1: string, _col2: string, _col5: int, _col7: double partition by: _col2 raw input shape: @@ -3119,7 +3119,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -3314,7 +3314,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -3555,7 +3555,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col0 ASC NULLS FIRST + order by: _col0 ASC NULLS LAST output shape: _col0: string, _col1: string, _col2: double partition by: _col0 raw input shape: @@ -3586,7 +3586,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col0 raw input shape: window functions: @@ -3806,7 +3806,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -3863,7 +3863,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col5 ASC NULLS FIRST + order by: _col5 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -3904,7 +3904,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col3 ASC NULLS FIRST, _col2 ASC NULLS FIRST + order by: _col3 ASC NULLS LAST, _col2 ASC NULLS LAST partition by: _col3 raw input shape: window functions: @@ -3967,7 +3967,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE @@ -3996,7 +3996,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE @@ -4260,14 +4260,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -4281,7 +4281,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4289,7 +4289,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4321,7 +4321,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4329,7 +4329,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4573,14 +4573,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -4611,7 +4611,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4642,7 +4642,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -4673,7 +4673,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -4881,14 +4881,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -4919,14 +4919,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -4942,7 +4942,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -4970,7 +4970,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -5199,14 +5199,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5237,7 +5237,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -5251,7 +5251,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5284,7 +5284,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5526,7 +5526,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5540,7 +5540,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -5548,7 +5548,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -5580,7 +5580,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -5588,7 +5588,7 @@ STAGE PLANS: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2 raw input shape: @@ -5619,7 +5619,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST partition by: _col2, _col1 raw input shape: window functions: @@ -5823,14 +5823,14 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: Partition table definition input alias: ptf_2 name: noop - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5844,7 +5844,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5877,7 +5877,7 @@ STAGE PLANS: Partition table definition input alias: ptf_1 name: noopwithmap - order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST output shape: _col1: string, _col2: string, _col5: int partition by: _col2, _col1 raw input shape: @@ -5894,7 +5894,7 @@ STAGE PLANS: Reduce Vectorization: enabled: true enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true - reduceColumnNullOrder: aa + reduceColumnNullOrder: az reduceColumnSortOrder: ++ allNative: false usesVectorUDFAdaptor: false @@ -5922,7 +5922,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions:
