hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tc...@apache.org
Subject [13/21] hive git commit: HIVE-20423: Set NULLS LAST as the default null ordering (Teddy Choi, reviewed by Jesus Camacho Rodriguez)
Date Wed, 26 Sep 2018 07:51:56 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out b/ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out
index 735dcdd..dea50ba 100644
--- a/ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out
@@ -1237,56 +1237,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,
@@ -1778,81 +1778,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,
@@ -2102,7 +2102,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/llap/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/llap/vectorized_ptf.q.out
index 53bd3c9..9360038 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_ptf.q.out
@@ -200,7 +200,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:
@@ -232,7 +232,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:
@@ -480,7 +480,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:
@@ -512,7 +512,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:
@@ -673,7 +673,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:
@@ -832,7 +832,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:
@@ -864,7 +864,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:
@@ -1051,7 +1051,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:
@@ -1083,7 +1083,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:
@@ -1273,7 +1273,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:
@@ -1314,7 +1314,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:
@@ -1540,7 +1540,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:
@@ -1778,7 +1778,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:
@@ -1888,7 +1888,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:
@@ -1929,7 +1929,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:
@@ -1961,7 +1961,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:
@@ -2082,7 +2082,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:
@@ -2124,7 +2124,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:
@@ -2157,7 +2157,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:
@@ -2340,7 +2340,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:
@@ -2372,7 +2372,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:
@@ -2558,7 +2558,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:
@@ -2572,7 +2572,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:
@@ -2580,7 +2580,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:
@@ -2613,7 +2613,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:
@@ -2621,7 +2621,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:
@@ -2653,7 +2653,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:
@@ -2846,7 +2846,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:
@@ -2878,7 +2878,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:
@@ -3111,7 +3111,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:
@@ -3163,7 +3163,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:
@@ -3361,7 +3361,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:
@@ -3605,7 +3605,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:
@@ -3637,7 +3637,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:
@@ -3862,7 +3862,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:
@@ -3900,7 +3900,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:
@@ -3991,7 +3991,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:
@@ -4033,7 +4033,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:
@@ -4378,14 +4378,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:
@@ -4399,7 +4399,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:
@@ -4407,7 +4407,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:
@@ -4440,7 +4440,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:
@@ -4448,7 +4448,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:
@@ -4696,14 +4696,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:
@@ -4735,7 +4735,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:
@@ -4767,7 +4767,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:
@@ -4799,7 +4799,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:
@@ -5010,14 +5010,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:
@@ -5049,14 +5049,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:
@@ -5072,7 +5072,7 @@ STAGE PLANS:
             Reduce Vectorization:
                 enabled: true
                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true
-                reduceColumnNullOrder: aa
+                reduceColumnNullOrder: az
                 reduceColumnSortOrder: ++
                 allNative: false
                 usesVectorUDFAdaptor: false
@@ -5100,7 +5100,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:
@@ -5332,14 +5332,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:
@@ -5371,7 +5371,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:
@@ -5385,7 +5385,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:
@@ -5419,7 +5419,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:
@@ -5665,7 +5665,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:
@@ -5679,7 +5679,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:
@@ -5687,7 +5687,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:
@@ -5720,7 +5720,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:
@@ -5728,7 +5728,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:
@@ -5760,7 +5760,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:
@@ -5967,14 +5967,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:
@@ -5988,7 +5988,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:
@@ -6022,7 +6022,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:
@@ -6039,7 +6039,7 @@ STAGE PLANS:
             Reduce Vectorization:
                 enabled: true
                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true
-                reduceColumnNullOrder: aa
+                reduceColumnNullOrder: az
                 reduceColumnSortOrder: ++
                 allNative: false
                 usesVectorUDFAdaptor: false
@@ -6067,7 +6067,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:


Mime
View raw message