hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From djais...@apache.org
Subject [03/36] hive git commit: HIVE-18910 : Migrate to Murmur hash for shuffle and bucketing (Deepak Jaiswal, reviewed by Jasone Dere)
Date Wed, 02 May 2018 18:32:43 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/statsfs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/statsfs.q.out b/ql/src/test/results/clientpositive/spark/statsfs.q.out
index fef2040..1af1495 100644
--- a/ql/src/test/results/clientpositive/spark/statsfs.q.out
+++ b/ql/src/test/results/clientpositive/spark/statsfs.q.out
@@ -274,6 +274,7 @@ Retention:          	0
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
 	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\"}
+	bucketing_version   	2                   
 	numFiles            	1                   
 	numRows             	500                 
 	rawDataSize         	5312                
@@ -334,6 +335,7 @@ Retention:          	0
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
 	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\"}
+	bucketing_version   	2                   
 	numFiles            	1                   
 	numRows             	500                 
 	rawDataSize         	5312                

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/subquery_nested_subquery.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_nested_subquery.q.out b/ql/src/test/results/clientpositive/spark/subquery_nested_subquery.q.out
index 15f33f0..0d894e3 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_nested_subquery.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_nested_subquery.q.out
@@ -11,28 +11,28 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
+121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
+121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
 90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
-85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
+49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
 42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
-105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
+112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
+110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
+155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
 48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
 15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
-45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
-65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
-132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
 195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
-17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
 33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
 78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
+85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
 17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
-112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
 40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
 144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
-110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
-155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
+105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
 191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
+45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
 146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
+65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
+132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
+17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/subquery_notin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_notin.q.out b/ql/src/test/results/clientpositive/spark/subquery_notin.q.out
index ffa524e..0f2f717 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_notin.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_notin.q.out
@@ -1213,25 +1213,25 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	almond aquamarine burnished black steel	28
-Manufacturer#1	almond antique chartreuse lavender yellow	34
 Manufacturer#1	almond aquamarine pink moccasin thistle	42
-Manufacturer#2	almond aquamarine rose maroon antique	25
+Manufacturer#2	almond antique violet chocolate turquoise	14
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
 Manufacturer#2	almond antique violet turquoise frosted	40
-Manufacturer#3	almond antique chartreuse khaki white	17
 Manufacturer#3	almond antique metallic orange dim	19
+Manufacturer#4	almond aquamarine floral ivory bisque	27
+Manufacturer#4	almond antique violet mint lemon	39
 Manufacturer#5	almond antique medium spring khaki	6
 Manufacturer#5	almond azure blanched chiffon midnight	23
 Manufacturer#5	almond antique blue firebrick mint	31
 Manufacturer#5	almond aquamarine dodger light gainsboro	46
 Manufacturer#1	almond antique salmon chartreuse burlywood	6
-Manufacturer#2	almond antique violet chocolate turquoise	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
+Manufacturer#1	almond antique chartreuse lavender yellow	34
+Manufacturer#2	almond aquamarine rose maroon antique	25
 Manufacturer#3	almond antique forest lavender goldenrod	14
+Manufacturer#3	almond antique chartreuse khaki white	17
 Manufacturer#3	almond antique olive coral navajo	45
 Manufacturer#4	almond antique gainsboro frosted violet	10
 Manufacturer#4	almond azure aquamarine papaya violet	12
-Manufacturer#4	almond aquamarine floral ivory bisque	27
-Manufacturer#4	almond antique violet mint lemon	39
 Warning: Shuffle Join JOIN[19][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: select li.l_partkey, count(*)
 from lineitem li
@@ -1250,21 +1250,21 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@lineitem
 #### A masked pattern was here ####
 22630	1
-7068	1
-88362	1
-123076	1
-139636	1
-106170	1
-182052	1
-59694	1
 175839	1
-21636	1
 119767	1
+139636	1
+21636	1
 119477	1
-88035	1
-450	1
-61931	1
+88362	1
+106170	1
+59694	1
+7068	1
+123076	1
 85951	1
+61931	1
+450	1
+182052	1
+88035	1
 Warning: Shuffle Join JOIN[18][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: select * 
 from src 
@@ -1789,29 +1789,29 @@ POSTHOOK: query: select * from part where p_brand <> 'Brand#14' AND p_size NOT I
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
 191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
-78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
+85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
+65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
 105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
 112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
 146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
-90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
 110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
+48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
-33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
+45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
 42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
+195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
+144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
+17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
 15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
-85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
-65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
+78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
+90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
 192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
 17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
-45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
 132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
 86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
-195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
-144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
+33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
 Warning: Shuffle Join JOIN[26][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain select * from part  where (p_size-1) NOT IN (select min(p_size) from part group by p_type) order by p_partkey
 PREHOOK: type: QUERY
@@ -2220,27 +2220,27 @@ POSTHOOK: Input: default@part
 17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
 121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
 121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
+42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
+146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
+15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
+78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
+112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
+132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
+191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
+17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
 155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
+33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
 49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
-15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
+110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
 45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
+105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
 90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
-112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
+48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
 65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
 85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
 195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
 192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
-191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
-17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
-146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
-33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
-110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
-105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
-78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
-48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
-132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
 144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
 PREHOOK: query: explain select count(*) as c from part as e where p_size + 100 NOT IN (select p_partkey from part where p_name = e.p_name)
 PREHOOK: type: QUERY
@@ -2914,27 +2914,27 @@ POSTHOOK: Input: default@part
 192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
 90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
 85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
-112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
+17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
+40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
+144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
 110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
-15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
-45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
+155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
+146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
 132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
 195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
-33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
 78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
-17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
 49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
 42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
-40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
-144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
-155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
+112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
 105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
 48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
 86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
-146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
+15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
+45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
 65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
 17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
+33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
 PREHOOK: query: explain select * from part where p_name NOT IN (select p_name from part p where p.p_size = part.p_size AND part.p_partkey= p.p_partkey )
 PREHOOK: type: QUERY
 POSTHOOK: query: explain select * from part where p_name NOT IN (select p_name from part p where p.p_size = part.p_size AND part.p_partkey= p.p_partkey )
@@ -3529,29 +3529,29 @@ POSTHOOK: Input: default@part
 almond aquamarine yellow dodger mint
 almond aquamarine dodger light gainsboro
 almond antique violet turquoise frosted
-almond aquamarine pink moccasin thistle
+almond antique chartreuse lavender yellow
+almond antique metallic orange dim
+almond antique blue firebrick mint
 almond antique salmon chartreuse burlywood
 almond antique burnished rose metallic
 almond antique burnished rose metallic
-almond antique gainsboro frosted violet
+almond antique sky peru orange
+almond aquamarine floral ivory bisque
+almond aquamarine rose maroon antique
+almond aquamarine burnished black steel
 almond azure aquamarine papaya violet
-almond aquamarine sandy cyan gainsboro
+almond antique medium spring khaki
 almond antique olive coral navajo
 almond antique misty red olive
 almond azure blanched chiffon midnight
-almond antique chartreuse lavender yellow
+almond aquamarine pink moccasin thistle
 almond antique violet chocolate turquoise
-almond antique metallic orange dim
 almond aquamarine midnight light salmon
 almond antique chartreuse khaki white
-almond antique blue firebrick mint
 almond antique forest lavender goldenrod
 almond antique violet mint lemon
-almond antique sky peru orange
-almond aquamarine floral ivory bisque
-almond aquamarine rose maroon antique
-almond aquamarine burnished black steel
-almond antique medium spring khaki
+almond antique gainsboro frosted violet
+almond aquamarine sandy cyan gainsboro
 Warning: Shuffle Join JOIN[16][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain select key, count(*) from src where value NOT IN (select key from src) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
 PREHOOK: type: QUERY
@@ -3806,37 +3806,37 @@ POSTHOOK: query: select key, count(*) from src where value NOT IN (select key fr
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-273	3
-454	3
-311	3
-128	3
-396	3
-316	3
+70	3
+431	3
+90	3
 384	3
-369	3
+466	3
+5	3
+409	3
+318	3
 417	3
+167	3
+128	3
+327	3
+193	3
+438	3
+403	3
 298	3
-208	3
-199	3
 430	3
 187	3
-193	3
-318	3
-327	3
-5	3
+273	3
+454	3
 119	3
-466	3
-70	3
-167	3
-403	3
-480	3
+316	3
+311	3
 0	3
-409	3
-35	3
-90	3
-438	3
-431	3
+369	3
 498	3
+35	3
+480	3
+208	3
+199	3
+396	3
 PREHOOK: query: explain select key, count(*) from src where value NOT IN (select concat('v', value) from src sc where sc.key = src.key ) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
 PREHOOK: type: QUERY
 POSTHOOK: query: explain select key, count(*) from src where value NOT IN (select concat('v', value) from src sc where sc.key = src.key ) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
@@ -4110,37 +4110,37 @@ POSTHOOK: query: select key, count(*) from src where value NOT IN (select concat
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-273	3
-454	3
-311	3
-128	3
-396	3
-316	3
+70	3
+431	3
+90	3
 384	3
-369	3
+466	3
+5	3
+409	3
+318	3
 417	3
+167	3
+128	3
+327	3
+193	3
+438	3
+403	3
 298	3
-208	3
-199	3
 430	3
 187	3
-193	3
-318	3
-327	3
-5	3
+273	3
+454	3
 119	3
-466	3
-70	3
-167	3
-403	3
-480	3
+316	3
+311	3
 0	3
-409	3
-35	3
-90	3
-438	3
-431	3
+369	3
 498	3
+35	3
+480	3
+208	3
+199	3
+396	3
 Warning: Shuffle Join JOIN[26][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain select * from part  where (p_size-1) NOT IN (select min(p_size) from part group by p_type) order by p_brand
 PREHOOK: type: QUERY
@@ -4351,8 +4351,8 @@ POSTHOOK: Input: default@part
 40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
 144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
 17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
 33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
+49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
 45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
 48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
 42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
@@ -4773,9 +4773,11 @@ POSTHOOK: Input: default@src
 103	val_103
 104	val_104
 104	val_104
+105	val_105
+11	val_11
 111	val_111
-114	val_114
-116	val_116
+12	val_12
+12	val_12
 120	val_120
 120	val_120
 126	val_126
@@ -4788,73 +4790,59 @@ POSTHOOK: Input: default@src
 133	val_133
 134	val_134
 134	val_134
-145	val_145
-146	val_146
-146	val_146
+136	val_136
+143	val_143
 149	val_149
 149	val_149
-15	val_15
-15	val_15
+150	val_150
 152	val_152
 152	val_152
-155	val_155
+153	val_153
+156	val_156
 157	val_157
+160	val_160
+162	val_162
+163	val_163
+166	val_166
+167	val_167
+167	val_167
+167	val_167
+168	val_168
 169	val_169
 169	val_169
 169	val_169
 169	val_169
 17	val_17
 170	val_170
-172	val_172
-172	val_172
-178	val_178
-179	val_179
-179	val_179
-181	val_181
-187	val_187
-187	val_187
-187	val_187
-189	val_189
-19	val_19
-191	val_191
-191	val_191
-192	val_192
-194	val_194
-195	val_195
-195	val_195
-199	val_199
-199	val_199
-199	val_199
-2	val_2
+174	val_174
+174	val_174
+175	val_175
+175	val_175
+176	val_176
+176	val_176
+180	val_180
+193	val_193
+193	val_193
+193	val_193
+196	val_196
 20	val_20
-200	val_200
-200	val_200
 201	val_201
-202	val_202
 203	val_203
 203	val_203
-207	val_207
-207	val_207
-208	val_208
-208	val_208
-208	val_208
+205	val_205
+205	val_205
+209	val_209
+209	val_209
 213	val_213
 213	val_213
-214	val_214
-216	val_216
-216	val_216
 218	val_218
-222	val_222
+221	val_221
+221	val_221
 223	val_223
 223	val_223
-224	val_224
-224	val_224
-228	val_228
-229	val_229
-229	val_229
+226	val_226
 233	val_233
 233	val_233
-235	val_235
 237	val_237
 237	val_237
 239	val_239
@@ -4862,408 +4850,420 @@ POSTHOOK: Input: default@src
 24	val_24
 24	val_24
 241	val_241
-244	val_244
+242	val_242
+242	val_242
+247	val_247
+248	val_248
 255	val_255
 255	val_255
 256	val_256
 256	val_256
-257	val_257
-258	val_258
 26	val_26
 26	val_26
-262	val_262
-265	val_265
-265	val_265
-266	val_266
-27	val_27
-273	val_273
-273	val_273
-273	val_273
+263	val_263
+272	val_272
+272	val_272
+274	val_274
 275	val_275
-278	val_278
-278	val_278
-28	val_28
-280	val_280
-280	val_280
+277	val_277
+277	val_277
+277	val_277
+277	val_277
+281	val_281
+281	val_281
 282	val_282
 282	val_282
-284	val_284
 285	val_285
 286	val_286
 287	val_287
-288	val_288
-288	val_288
-291	val_291
+289	val_289
 292	val_292
+296	val_296
 298	val_298
 298	val_298
 298	val_298
-30	val_30
 302	val_302
-305	val_305
+307	val_307
+307	val_307
+308	val_308
+309	val_309
+309	val_309
 310	val_310
-311	val_311
-311	val_311
-311	val_311
-316	val_316
-316	val_316
-316	val_316
-321	val_321
-321	val_321
+318	val_318
+318	val_318
+318	val_318
 323	val_323
-33	val_33
+325	val_325
+325	val_325
+327	val_327
+327	val_327
+327	val_327
 332	val_332
 333	val_333
 333	val_333
 335	val_335
-336	val_336
 338	val_338
 339	val_339
-344	val_344
-344	val_344
-353	val_353
-353	val_353
+34	val_34
+341	val_341
+348	val_348
+348	val_348
+348	val_348
+348	val_348
+348	val_348
 356	val_356
 360	val_360
 362	val_362
-364	val_364
-368	val_368
-369	val_369
-369	val_369
-369	val_369
+367	val_367
+367	val_367
 37	val_37
 37	val_37
-373	val_373
+374	val_374
+375	val_375
 377	val_377
-378	val_378
+379	val_379
+382	val_382
+382	val_382
 384	val_384
 384	val_384
 384	val_384
-386	val_386
 392	val_392
-395	val_395
-395	val_395
-396	val_396
-396	val_396
-396	val_396
-397	val_397
-397	val_397
+399	val_399
+399	val_399
+401	val_401
+401	val_401
+401	val_401
+401	val_401
+401	val_401
 402	val_402
-404	val_404
-404	val_404
-407	val_407
-411	val_411
+403	val_403
+403	val_403
+403	val_403
+409	val_409
+409	val_409
+409	val_409
+413	val_413
+413	val_413
 417	val_417
 417	val_417
 417	val_417
-418	val_418
 419	val_419
 42	val_42
 42	val_42
-424	val_424
-424	val_424
+427	val_427
+429	val_429
+429	val_429
 43	val_43
 430	val_430
 430	val_430
 430	val_430
+431	val_431
+431	val_431
+431	val_431
 432	val_432
-436	val_436
+435	val_435
 437	val_437
-444	val_444
-448	val_448
-449	val_449
-453	val_453
-454	val_454
-454	val_454
-454	val_454
+438	val_438
+438	val_438
+438	val_438
+439	val_439
+439	val_439
+44	val_44
+443	val_443
 457	val_457
+458	val_458
+458	val_458
 459	val_459
 459	val_459
-468	val_468
-468	val_468
-468	val_468
-468	val_468
-47	val_47
-477	val_477
+462	val_462
+462	val_462
+466	val_466
+466	val_466
+466	val_466
+467	val_467
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+470	val_470
+472	val_472
+475	val_475
+478	val_478
+478	val_478
 479	val_479
 481	val_481
-482	val_482
 483	val_483
-485	val_485
+487	val_487
 489	val_489
 489	val_489
 489	val_489
 489	val_489
-490	val_490
-492	val_492
-492	val_492
-493	val_493
 494	val_494
 495	val_495
 496	val_496
-497	val_497
+5	val_5
+5	val_5
+5	val_5
+51	val_51
+51	val_51
 57	val_57
-65	val_65
-67	val_67
-67	val_67
+58	val_58
+58	val_58
+64	val_64
+66	val_66
+69	val_69
+70	val_70
+70	val_70
+70	val_70
 72	val_72
 72	val_72
 74	val_74
 76	val_76
 76	val_76
-8	val_8
-80	val_80
+77	val_77
 82	val_82
-85	val_85
-86	val_86
-87	val_87
+83	val_83
+83	val_83
+84	val_84
+84	val_84
 9	val_9
-92	val_92
-96	val_96
-97	val_97
-97	val_97
+90	val_90
+90	val_90
+90	val_90
 0	val_0
 0	val_0
 0	val_0
-105	val_105
-11	val_11
 113	val_113
 113	val_113
+114	val_114
+116	val_116
 118	val_118
 118	val_118
 119	val_119
 119	val_119
 119	val_119
-12	val_12
-12	val_12
 125	val_125
 125	val_125
-136	val_136
 137	val_137
 137	val_137
 138	val_138
 138	val_138
 138	val_138
 138	val_138
-143	val_143
-150	val_150
-153	val_153
-156	val_156
-158	val_158
-160	val_160
-162	val_162
-163	val_163
+145	val_145
+146	val_146
+146	val_146
+15	val_15
+15	val_15
+155	val_155
+158	val_158
 164	val_164
 164	val_164
 165	val_165
 165	val_165
-166	val_166
-167	val_167
-167	val_167
-167	val_167
-168	val_168
-174	val_174
-174	val_174
-175	val_175
-175	val_175
-176	val_176
-176	val_176
+172	val_172
+172	val_172
 177	val_177
+178	val_178
+179	val_179
+179	val_179
 18	val_18
 18	val_18
-180	val_180
+181	val_181
 183	val_183
 186	val_186
+187	val_187
+187	val_187
+187	val_187
+189	val_189
+19	val_19
 190	val_190
-193	val_193
-193	val_193
-193	val_193
-196	val_196
+191	val_191
+191	val_191
+192	val_192
+194	val_194
+195	val_195
+195	val_195
 197	val_197
 197	val_197
-205	val_205
-205	val_205
-209	val_209
-209	val_209
+199	val_199
+199	val_199
+199	val_199
+2	val_2
+200	val_200
+200	val_200
+202	val_202
+207	val_207
+207	val_207
+208	val_208
+208	val_208
+208	val_208
+214	val_214
+216	val_216
+216	val_216
 217	val_217
 217	val_217
 219	val_219
 219	val_219
-221	val_221
-221	val_221
-226	val_226
+222	val_222
+224	val_224
+224	val_224
+228	val_228
+229	val_229
+229	val_229
 230	val_230
 230	val_230
 230	val_230
 230	val_230
 230	val_230
+235	val_235
 238	val_238
 238	val_238
-242	val_242
-242	val_242
-247	val_247
-248	val_248
+244	val_244
 249	val_249
 252	val_252
+257	val_257
+258	val_258
 260	val_260
-263	val_263
-272	val_272
-272	val_272
-274	val_274
-277	val_277
-277	val_277
-277	val_277
-277	val_277
-281	val_281
-281	val_281
+262	val_262
+265	val_265
+265	val_265
+266	val_266
+27	val_27
+273	val_273
+273	val_273
+273	val_273
+278	val_278
+278	val_278
+28	val_28
+280	val_280
+280	val_280
 283	val_283
-289	val_289
-296	val_296
+284	val_284
+288	val_288
+288	val_288
+291	val_291
+30	val_30
+305	val_305
 306	val_306
-307	val_307
-307	val_307
-308	val_308
-309	val_309
-309	val_309
+311	val_311
+311	val_311
+311	val_311
 315	val_315
+316	val_316
+316	val_316
+316	val_316
 317	val_317
 317	val_317
-318	val_318
-318	val_318
-318	val_318
+321	val_321
+321	val_321
 322	val_322
 322	val_322
-325	val_325
-325	val_325
-327	val_327
-327	val_327
-327	val_327
+33	val_33
 331	val_331
 331	val_331
-34	val_34
-341	val_341
+336	val_336
 342	val_342
 342	val_342
+344	val_344
+344	val_344
 345	val_345
-348	val_348
-348	val_348
-348	val_348
-348	val_348
-348	val_348
 35	val_35
 35	val_35
 35	val_35
 351	val_351
+353	val_353
+353	val_353
+364	val_364
 365	val_365
 366	val_366
-367	val_367
-367	val_367
-374	val_374
-375	val_375
-379	val_379
-382	val_382
-382	val_382
+368	val_368
+369	val_369
+369	val_369
+369	val_369
+373	val_373
+378	val_378
+386	val_386
 389	val_389
 393	val_393
 394	val_394
-399	val_399
-399	val_399
+395	val_395
+395	val_395
+396	val_396
+396	val_396
+396	val_396
+397	val_397
+397	val_397
 4	val_4
 400	val_400
-401	val_401
-401	val_401
-401	val_401
-401	val_401
-401	val_401
-403	val_403
-403	val_403
-403	val_403
+404	val_404
+404	val_404
 406	val_406
 406	val_406
 406	val_406
 406	val_406
-409	val_409
-409	val_409
-409	val_409
+407	val_407
 41	val_41
-413	val_413
-413	val_413
+411	val_411
 414	val_414
 414	val_414
+418	val_418
 421	val_421
-427	val_427
-429	val_429
-429	val_429
-431	val_431
-431	val_431
-431	val_431
-435	val_435
-438	val_438
-438	val_438
-438	val_438
-439	val_439
-439	val_439
-44	val_44
-443	val_443
+424	val_424
+424	val_424
+436	val_436
+444	val_444
 446	val_446
+448	val_448
+449	val_449
 452	val_452
+453	val_453
+454	val_454
+454	val_454
+454	val_454
 455	val_455
-458	val_458
-458	val_458
 460	val_460
-462	val_462
-462	val_462
 463	val_463
 463	val_463
-466	val_466
-466	val_466
-466	val_466
-467	val_467
-469	val_469
-469	val_469
-469	val_469
-469	val_469
-469	val_469
-470	val_470
-472	val_472
-475	val_475
-478	val_478
-478	val_478
+468	val_468
+468	val_468
+468	val_468
+468	val_468
+47	val_47
+477	val_477
 480	val_480
 480	val_480
 480	val_480
+482	val_482
 484	val_484
-487	val_487
+485	val_485
+490	val_490
 491	val_491
+492	val_492
+492	val_492
+493	val_493
+497	val_497
 498	val_498
 498	val_498
 498	val_498
-5	val_5
-5	val_5
-5	val_5
-51	val_51
-51	val_51
 53	val_53
 54	val_54
-58	val_58
-58	val_58
-64	val_64
-66	val_66
-69	val_69
-70	val_70
-70	val_70
-70	val_70
-77	val_77
-78	val_78
-83	val_83
-83	val_83
-84	val_84
-84	val_84
-90	val_90
-90	val_90
-90	val_90
+65	val_65
+67	val_67
+67	val_67
+78	val_78
+8	val_8
+80	val_80
+85	val_85
+86	val_86
+87	val_87
+92	val_92
 95	val_95
 95	val_95
+96	val_96
+97	val_97
+97	val_97
 98	val_98
 98	val_98
 PREHOOK: query: explain select count(*) as c from part as e where p_size + 100 not in ( select p_type from part where p_brand = e.p_brand)
@@ -5945,8 +5945,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@t1
 POSTHOOK: Input: default@t2
 #### A masked pattern was here ####
-NULL
 1
+NULL
 PREHOOK: query: DROP TABLE t1
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@t1
@@ -6655,9 +6655,9 @@ POSTHOOK: query: select t.i from t where t.j NOT IN (select t1.i from t t1 where
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@t
 #### A masked pattern was here ####
-4
 7
 1
+4
 PREHOOK: query: explain select t.i from t where t.i NOT IN (select t1.i from t t1 where t1.j=t.j)
 PREHOOK: type: QUERY
 POSTHOOK: query: explain select t.i from t where t.i NOT IN (select t1.i from t t1 where t1.j=t.j)
@@ -6982,8 +6982,8 @@ POSTHOOK: query: select t.i from t where t.j NOT IN (select t1.i from t t1 )
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@t
 #### A masked pattern was here ####
-4
 1
+4
 Warning: Shuffle Join JOIN[16][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain select t.i from t where t.i NOT IN (select t1.i from t t1 )
 PREHOOK: type: QUERY
@@ -7404,9 +7404,11 @@ POSTHOOK: Input: default@src
 103	val_103
 104	val_104
 104	val_104
+105	val_105
+11	val_11
 111	val_111
-114	val_114
-116	val_116
+12	val_12
+12	val_12
 120	val_120
 120	val_120
 126	val_126
@@ -7419,73 +7421,59 @@ POSTHOOK: Input: default@src
 133	val_133
 134	val_134
 134	val_134
-145	val_145
-146	val_146
-146	val_146
+136	val_136
+143	val_143
 149	val_149
 149	val_149
-15	val_15
-15	val_15
+150	val_150
 152	val_152
 152	val_152
-155	val_155
+153	val_153
+156	val_156
 157	val_157
+160	val_160
+162	val_162
+163	val_163
+166	val_166
+167	val_167
+167	val_167
+167	val_167
+168	val_168
 169	val_169
 169	val_169
 169	val_169
 169	val_169
 17	val_17
 170	val_170
-172	val_172
-172	val_172
-178	val_178
-179	val_179
-179	val_179
-181	val_181
-187	val_187
-187	val_187
-187	val_187
-189	val_189
-19	val_19
-191	val_191
-191	val_191
-192	val_192
-194	val_194
-195	val_195
-195	val_195
-199	val_199
-199	val_199
-199	val_199
-2	val_2
+174	val_174
+174	val_174
+175	val_175
+175	val_175
+176	val_176
+176	val_176
+180	val_180
+193	val_193
+193	val_193
+193	val_193
+196	val_196
 20	val_20
-200	val_200
-200	val_200
 201	val_201
-202	val_202
 203	val_203
 203	val_203
-207	val_207
-207	val_207
-208	val_208
-208	val_208
-208	val_208
+205	val_205
+205	val_205
+209	val_209
+209	val_209
 213	val_213
 213	val_213
-214	val_214
-216	val_216
-216	val_216
 218	val_218
-222	val_222
+221	val_221
+221	val_221
 223	val_223
 223	val_223
-224	val_224
-224	val_224
-228	val_228
-229	val_229
-229	val_229
+226	val_226
 233	val_233
 233	val_233
-235	val_235
 237	val_237
 237	val_237
 239	val_239
@@ -7493,407 +7481,419 @@ POSTHOOK: Input: default@src
 24	val_24
 24	val_24
 241	val_241
-244	val_244
+242	val_242
+242	val_242
+247	val_247
+248	val_248
 255	val_255
 255	val_255
 256	val_256
 256	val_256
-257	val_257
-258	val_258
 26	val_26
 26	val_26
-262	val_262
-265	val_265
-265	val_265
-266	val_266
-27	val_27
-273	val_273
-273	val_273
-273	val_273
+263	val_263
+272	val_272
+272	val_272
+274	val_274
 275	val_275
-278	val_278
-278	val_278
-28	val_28
-280	val_280
-280	val_280
+277	val_277
+277	val_277
+277	val_277
+277	val_277
+281	val_281
+281	val_281
 282	val_282
 282	val_282
-284	val_284
 285	val_285
 286	val_286
 287	val_287
-288	val_288
-288	val_288
-291	val_291
+289	val_289
 292	val_292
+296	val_296
 298	val_298
 298	val_298
 298	val_298
-30	val_30
 302	val_302
-305	val_305
+307	val_307
+307	val_307
+308	val_308
+309	val_309
+309	val_309
 310	val_310
-311	val_311
-311	val_311
-311	val_311
-316	val_316
-316	val_316
-316	val_316
-321	val_321
-321	val_321
+318	val_318
+318	val_318
+318	val_318
 323	val_323
-33	val_33
+325	val_325
+325	val_325
+327	val_327
+327	val_327
+327	val_327
 332	val_332
 333	val_333
 333	val_333
 335	val_335
-336	val_336
 338	val_338
 339	val_339
-344	val_344
-344	val_344
-353	val_353
-353	val_353
+34	val_34
+341	val_341
+348	val_348
+348	val_348
+348	val_348
+348	val_348
+348	val_348
 356	val_356
 360	val_360
 362	val_362
-364	val_364
-368	val_368
-369	val_369
-369	val_369
-369	val_369
+367	val_367
+367	val_367
 37	val_37
 37	val_37
-373	val_373
+374	val_374
+375	val_375
 377	val_377
-378	val_378
+379	val_379
+382	val_382
+382	val_382
 384	val_384
 384	val_384
 384	val_384
-386	val_386
 392	val_392
-395	val_395
-395	val_395
-396	val_396
-396	val_396
-396	val_396
-397	val_397
-397	val_397
+399	val_399
+399	val_399
+401	val_401
+401	val_401
+401	val_401
+401	val_401
+401	val_401
 402	val_402
-404	val_404
-404	val_404
-407	val_407
-411	val_411
+403	val_403
+403	val_403
+403	val_403
+409	val_409
+409	val_409
+409	val_409
+413	val_413
+413	val_413
 417	val_417
 417	val_417
 417	val_417
-418	val_418
 419	val_419
 42	val_42
 42	val_42
-424	val_424
-424	val_424
+427	val_427
+429	val_429
+429	val_429
 43	val_43
 430	val_430
 430	val_430
 430	val_430
+431	val_431
+431	val_431
+431	val_431
 432	val_432
-436	val_436
+435	val_435
 437	val_437
-444	val_444
-448	val_448
-449	val_449
-453	val_453
-454	val_454
-454	val_454
-454	val_454
+438	val_438
+438	val_438
+438	val_438
+439	val_439
+439	val_439
+44	val_44
+443	val_443
 457	val_457
+458	val_458
+458	val_458
 459	val_459
 459	val_459
-468	val_468
-468	val_468
-468	val_468
-468	val_468
-47	val_47
-477	val_477
-479	val_479
-481	val_481
-482	val_482
+462	val_462
+462	val_462
+466	val_466
+466	val_466
+466	val_466
+467	val_467
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+470	val_470
+472	val_472
+475	val_475
+478	val_478
+478	val_478
+479	val_479
+481	val_481
 483	val_483
-485	val_485
+487	val_487
 489	val_489
 489	val_489
 489	val_489
 489	val_489
-490	val_490
-492	val_492
-492	val_492
-493	val_493
 494	val_494
 495	val_495
 496	val_496
-497	val_497
+5	val_5
+5	val_5
+5	val_5
+51	val_51
+51	val_51
 57	val_57
-65	val_65
-67	val_67
-67	val_67
+58	val_58
+58	val_58
+64	val_64
+66	val_66
+69	val_69
+70	val_70
+70	val_70
+70	val_70
 72	val_72
 72	val_72
 74	val_74
 76	val_76
 76	val_76
-8	val_8
-80	val_80
+77	val_77
 82	val_82
-85	val_85
-86	val_86
-87	val_87
+83	val_83
+83	val_83
+84	val_84
+84	val_84
 9	val_9
-92	val_92
-96	val_96
-97	val_97
-97	val_97
+90	val_90
+90	val_90
+90	val_90
 0	val_0
 0	val_0
 0	val_0
-105	val_105
-11	val_11
 113	val_113
 113	val_113
+114	val_114
+116	val_116
 118	val_118
 118	val_118
 119	val_119
 119	val_119
 119	val_119
-12	val_12
-12	val_12
 125	val_125
 125	val_125
-136	val_136
 137	val_137
 137	val_137
 138	val_138
 138	val_138
 138	val_138
 138	val_138
-143	val_143
-150	val_150
-153	val_153
-156	val_156
+145	val_145
+146	val_146
+146	val_146
+15	val_15
+15	val_15
+155	val_155
 158	val_158
-160	val_160
-162	val_162
-163	val_163
 164	val_164
 164	val_164
 165	val_165
 165	val_165
-166	val_166
-167	val_167
-167	val_167
-167	val_167
-168	val_168
-174	val_174
-174	val_174
-175	val_175
-175	val_175
-176	val_176
-176	val_176
+172	val_172
+172	val_172
 177	val_177
+178	val_178
+179	val_179
+179	val_179
 18	val_18
 18	val_18
-180	val_180
+181	val_181
 183	val_183
 186	val_186
+187	val_187
+187	val_187
+187	val_187
+189	val_189
+19	val_19
 190	val_190
-193	val_193
-193	val_193
-193	val_193
-196	val_196
+191	val_191
+191	val_191
+192	val_192
+194	val_194
+195	val_195
+195	val_195
 197	val_197
 197	val_197
-205	val_205
-205	val_205
-209	val_209
-209	val_209
+199	val_199
+199	val_199
+199	val_199
+2	val_2
+200	val_200
+200	val_200
+202	val_202
+207	val_207
+207	val_207
+208	val_208
+208	val_208
+208	val_208
+214	val_214
+216	val_216
+216	val_216
 217	val_217
 217	val_217
 219	val_219
 219	val_219
-221	val_221
-221	val_221
-226	val_226
+222	val_222
+224	val_224
+224	val_224
+228	val_228
+229	val_229
+229	val_229
 230	val_230
 230	val_230
 230	val_230
 230	val_230
 230	val_230
+235	val_235
 238	val_238
 238	val_238
-242	val_242
-242	val_242
-247	val_247
-248	val_248
+244	val_244
 249	val_249
 252	val_252
+257	val_257
+258	val_258
 260	val_260
-263	val_263
-272	val_272
-272	val_272
-274	val_274
-277	val_277
-277	val_277
-277	val_277
-277	val_277
-281	val_281
-281	val_281
+262	val_262
+265	val_265
+265	val_265
+266	val_266
+27	val_27
+273	val_273
+273	val_273
+273	val_273
+278	val_278
+278	val_278
+28	val_28
+280	val_280
+280	val_280
 283	val_283
-289	val_289
-296	val_296
+284	val_284
+288	val_288
+288	val_288
+291	val_291
+30	val_30
+305	val_305
 306	val_306
-307	val_307
-307	val_307
-308	val_308
-309	val_309
-309	val_309
+311	val_311
+311	val_311
+311	val_311
 315	val_315
+316	val_316
+316	val_316
+316	val_316
 317	val_317
 317	val_317
-318	val_318
-318	val_318
-318	val_318
+321	val_321
+321	val_321
 322	val_322
 322	val_322
-325	val_325
-325	val_325
-327	val_327
-327	val_327
-327	val_327
+33	val_33
 331	val_331
 331	val_331
-34	val_34
-341	val_341
+336	val_336
 342	val_342
 342	val_342
+344	val_344
+344	val_344
 345	val_345
-348	val_348
-348	val_348
-348	val_348
-348	val_348
-348	val_348
 35	val_35
 35	val_35
 35	val_35
 351	val_351
+353	val_353
+353	val_353
+364	val_364
 365	val_365
 366	val_366
-367	val_367
-367	val_367
-374	val_374
-375	val_375
-379	val_379
-382	val_382
-382	val_382
+368	val_368
+369	val_369
+369	val_369
+369	val_369
+373	val_373
+378	val_378
+386	val_386
 389	val_389
 393	val_393
 394	val_394
-399	val_399
-399	val_399
+395	val_395
+395	val_395
+396	val_396
+396	val_396
+396	val_396
+397	val_397
+397	val_397
 4	val_4
 400	val_400
-401	val_401
-401	val_401
-401	val_401
-401	val_401
-401	val_401
-403	val_403
-403	val_403
-403	val_403
+404	val_404
+404	val_404
 406	val_406
 406	val_406
 406	val_406
 406	val_406
-409	val_409
-409	val_409
-409	val_409
+407	val_407
 41	val_41
-413	val_413
-413	val_413
+411	val_411
 414	val_414
 414	val_414
+418	val_418
 421	val_421
-427	val_427
-429	val_429
-429	val_429
-431	val_431
-431	val_431
-431	val_431
-435	val_435
-438	val_438
-438	val_438
-438	val_438
-439	val_439
-439	val_439
-44	val_44
-443	val_443
+424	val_424
+424	val_424
+436	val_436
+444	val_444
 446	val_446
+448	val_448
+449	val_449
 452	val_452
+453	val_453
+454	val_454
+454	val_454
+454	val_454
 455	val_455
-458	val_458
-458	val_458
 460	val_460
-462	val_462
-462	val_462
 463	val_463
 463	val_463
-466	val_466
-466	val_466
-466	val_466
-467	val_467
-469	val_469
-469	val_469
-469	val_469
-469	val_469
-469	val_469
-470	val_470
-472	val_472
-475	val_475
-478	val_478
-478	val_478
+468	val_468
+468	val_468
+468	val_468
+468	val_468
+47	val_47
+477	val_477
 480	val_480
 480	val_480
 480	val_480
+482	val_482
 484	val_484
-487	val_487
+485	val_485
+490	val_490
 491	val_491
+492	val_492
+492	val_492
+493	val_493
+497	val_497
 498	val_498
 498	val_498
 498	val_498
-5	val_5
-5	val_5
-5	val_5
-51	val_51
-51	val_51
 53	val_53
 54	val_54
-58	val_58
-58	val_58
-64	val_64
-66	val_66
-69	val_69
-70	val_70
-70	val_70
-70	val_70
-77	val_77
+65	val_65
+67	val_67
+67	val_67
 78	val_78
-83	val_83
-83	val_83
-84	val_84
-84	val_84
-90	val_90
-90	val_90
-90	val_90
+8	val_8
+80	val_80
+85	val_85
+86	val_86
+87	val_87
+92	val_92
 95	val_95
 95	val_95
+96	val_96
+97	val_97
+97	val_97
 98	val_98
 98	val_98

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/subquery_select.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_select.q.out b/ql/src/test/results/clientpositive/spark/subquery_select.q.out
index d366a5f..7433b78 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_select.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_select.q.out
@@ -146,16 +146,13 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+1	false
 10	false
 12	false
-14	false
-14	false
-23	false
+19	false
 28	false
-31	false
+34	false
 42	false
-45	false
-1	false
 2	false
 2	false
 2	false
@@ -163,14 +160,17 @@ POSTHOOK: Input: default@part
 6	false
 6	false
 7	false
+14	false
+14	false
 17	false
 18	false
-19	false
+23	false
 25	false
 27	false
-34	false
+31	false
 39	false
 40	false
+45	false
 46	true
 PREHOOK: query: EXPLAIN SELECT p_size, p_size IN (
         SELECT MAX(p_size) FROM part p where p.p_type = part.p_type)
@@ -334,32 +334,32 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-7	true
 1	true
 40	true
-23	true
+34	true
+42	true
 14	true
 19	true
 2	true
-17	false
 6	true
+2	true
+2	true
+39	true
 10	true
-12	true
+27	true
 6	true
+18	true
+45	true
+7	true
 46	true
-34	true
-42	true
+23	true
+17	false
 31	true
 14	true
 2	true
-2	true
-39	true
-2	true
-27	true
 25	true
 28	true
-18	true
-45	true
+12	true
 Warning: Shuffle Join JOIN[21][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain SELECT p_size, p_size NOT IN (
         SELECT MAX(p_size) FROM part)
@@ -508,16 +508,13 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+1	true
 10	true
 12	true
-14	true
-14	true
-23	true
+19	true
 28	true
-31	true
+34	true
 42	true
-45	true
-1	true
 2	true
 2	true
 2	true
@@ -525,14 +522,17 @@ POSTHOOK: Input: default@part
 6	true
 6	true
 7	true
+14	true
+14	true
 17	true
 18	true
-19	true
+23	true
 25	true
 27	true
-34	true
+31	true
 39	true
 40	true
+45	true
 46	false
 PREHOOK: query: EXPLAIN SELECT p_size, p_size NOT IN (
         SELECT MAX(p_size) FROM part p where p.p_type = part.p_type)
@@ -760,32 +760,32 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-7	false
 1	false
 40	false
-23	false
+34	false
+42	false
 14	false
 19	false
 2	false
-17	true
 6	false
+2	false
+2	false
+39	false
 10	false
-12	false
+27	false
 6	false
+18	false
+45	false
+7	false
 46	false
-34	false
-42	false
+23	false
+17	true
 31	false
 14	false
 2	false
-2	false
-39	false
-2	false
-27	false
 25	false
 28	false
-18	false
-45	false
+12	false
 Warning: Shuffle Join JOIN[11][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain SELECT p_size, EXISTS(SELECT p_size FROM part)
 FROM part
@@ -1023,31 +1023,31 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	true
 1	true
-23	true
+34	true
 42	true
-14	true
+19	true
 2	true
+14	true
 6	true
+39	true
 2	true
-2	true
-10	true
-2	true
-12	true
+27	true
 6	true
 18	true
 7	true
-46	true
 40	true
-34	true
-19	true
+23	true
+14	true
 17	true
 31	true
-14	true
-39	true
-27	true
+2	true
+2	true
+10	true
 25	true
 28	true
+12	true
 45	true
 Warning: Shuffle Join JOIN[11][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part)
@@ -1286,31 +1286,31 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	false
 1	false
-23	false
+34	false
 42	false
-14	false
+19	false
 2	false
+14	false
 6	false
+39	false
 2	false
-2	false
-10	false
-2	false
-12	false
+27	false
 6	false
 18	false
 7	false
-46	false
 40	false
-34	false
-19	false
+23	false
+14	false
 17	false
 31	false
-14	false
-39	false
-27	false
+2	false
+2	false
+10	false
 25	false
 28	false
+12	false
 45	false
 PREHOOK: query: explain select p_size, (select count(p_name) from part p where p.p_type = part.p_name) from part
 PREHOOK: type: QUERY
@@ -1421,31 +1421,31 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 31	0
+2	0
+2	0
 17	0
-34	0
+10	0
 6	0
-14	0
+19	0
+6	0
+2	0
 39	0
 28	0
 46	0
-27	0
-42	0
-25	0
 18	0
-7	0
 12	0
 23	0
-2	0
-2	0
+34	0
 14	0
-10	0
-19	0
 1	0
 45	0
-6	0
-2	0
+14	0
 40	0
+27	0
 2	0
+42	0
+25	0
+7	0
 PREHOOK: query: explain select p_size, (select max(p_name) from part p where p.p_type = part.p_name) from part
 PREHOOK: type: QUERY
 POSTHOOK: query: explain select p_size, (select max(p_name) from part p where p.p_type = part.p_name) from part
@@ -1555,31 +1555,31 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 31	NULL
+2	NULL
+2	NULL
 17	NULL
-34	NULL
+10	NULL
 6	NULL
-14	NULL
+19	NULL
+6	NULL
+2	NULL
 39	NULL
 28	NULL
 46	NULL
-27	NULL
-42	NULL
-25	NULL
 18	NULL
-7	NULL
 12	NULL
 23	NULL
-2	NULL
-2	NULL
+34	NULL
 14	NULL
-10	NULL
-19	NULL
 1	NULL
 45	NULL
-6	NULL
-2	NULL
+14	NULL
 40	NULL
+27	NULL
 2	NULL
+42	NULL
+25	NULL
+7	NULL
 Warning: Shuffle Join JOIN[10][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 PREHOOK: query: explain SELECT p_size, (SELECT max(p_size) FROM part)
     FROM part
@@ -2053,10 +2053,6 @@ where b.key in
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-92	val_92
-95	val_95
-95	val_95
-96	val_96
 90	val_90
 90	val_90
 90	val_90
@@ -2064,6 +2060,10 @@ POSTHOOK: Input: default@src
 97	val_97
 98	val_98
 98	val_98
+92	val_92
+95	val_95
+95	val_95
+96	val_96
 PREHOOK: query: CREATE table tnull(i int)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
@@ -2238,16 +2238,13 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 POSTHOOK: Input: default@tnull
 #### A masked pattern was here ####
+1	NULL
 10	NULL
 12	NULL
-14	NULL
-14	NULL
-23	NULL
+19	NULL
 28	NULL
-31	NULL
+34	NULL
 42	NULL
-45	NULL
-1	NULL
 2	NULL
 2	NULL
 2	NULL
@@ -2255,14 +2252,17 @@ POSTHOOK: Input: default@tnull
 6	NULL
 6	NULL
 7	NULL
+14	NULL
+14	NULL
 17	NULL
 18	NULL
-19	NULL
+23	NULL
 25	NULL
 27	NULL
-34	NULL
+31	NULL
 39	NULL
 40	NULL
+45	NULL
 46	NULL
 PREHOOK: query: CREATE TABLE tempty(i int)
 PREHOOK: type: CREATETABLE
@@ -2644,31 +2644,31 @@ POSTHOOK: query: SELECT p_size, 1+(SELECT max(p_size) FROM part p
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	47
 1	2
-23	24
+34	35
 42	43
-14	15
+19	20
 2	3
+14	15
 6	7
+39	40
 2	3
-2	3
-10	11
-2	3
-12	13
+27	28
 6	7
 18	19
 7	8
-46	47
 40	41
-34	35
-19	20
+23	24
+14	15
 17	32
 31	32
-14	15
-39	40
-27	28
+2	3
+2	3
+10	11
 25	26
 28	29
+12	13
 45	46
 PREHOOK: query: explain SELECT p_size, (SELECT count(p_size) FROM part p
     WHERE p.p_type = part.p_type) IS NULL from part
@@ -2782,31 +2782,31 @@ POSTHOOK: query: SELECT p_size, (SELECT count(p_size) FROM part p
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	false
 1	false
-23	false
+34	false
 42	false
-14	false
+19	false
 2	false
+14	false
 6	false
+39	false
 2	false
-2	false
-10	false
-2	false
-12	false
+27	false
 6	false
 18	false
 7	false
-46	false
 40	false
-34	false
-19	false
+23	false
+14	false
 17	false
 31	false
-14	false
-39	false
-27	false
+2	false
+2	false
+10	false
 25	false
 28	false
+12	false
 45	false
 Warning: Shuffle Join JOIN[23][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 Warning: Shuffle Join JOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Work 'Reducer 3' is a cross product
@@ -3267,31 +3267,31 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 31	true
+2	false
+2	false
 17	false
-34	false
+10	false
 6	false
-14	false
+19	false
+6	false
+2	false
 39	false
 28	false
 46	false
-27	false
-42	false
-25	false
 18	false
-7	false
 12	false
 23	false
-2	false
-2	false
+34	false
 14	false
-10	false
-19	false
 1	false
 45	false
-6	false
-2	false
+14	false
 40	false
+27	false
 2	false
+42	false
+25	false
+7	false
 PREHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type)
 FROM part
 PREHOOK: type: QUERY
@@ -3401,31 +3401,31 @@ FROM part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	false
 1	false
-23	false
+34	false
 42	false
-14	false
+19	false
 2	false
+14	false
 6	false
+39	false
 2	false
-2	false
-10	false
-2	false
-12	false
+27	false
 6	false
 18	false
 7	false
-46	false
 40	false
-34	false
-19	false
+23	false
+14	false
 17	false
 31	false
-14	false
-39	false
-27	false
+2	false
+2	false
+10	false
 25	false
 28	false
+12	false
 45	false
 Warning: Shuffle Join JOIN[12][tables = [$hdt$_1, $hdt$_2]] in Work 'Reducer 5' is a cross product
 Warning: Shuffle Join JOIN[41][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
@@ -3672,16 +3672,13 @@ POSTHOOK: query: select p_size, (p_size IN
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+1	false
 10	false
 12	false
-14	false
-14	false
-23	false
+19	false
 28	false
-31	false
+34	false
 42	false
-45	false
-1	false
 2	false
 2	false
 2	false
@@ -3689,14 +3686,17 @@ POSTHOOK: Input: default@part
 6	false
 6	false
 7	false
+14	false
+14	false
 17	false
 18	false
-19	false
+23	false
 25	false
 27	false
-34	false
+31	false
 39	false
 40	false
+45	false
 46	true
 Warning: Shuffle Join JOIN[25][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 Warning: Shuffle Join JOIN[28][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Work 'Reducer 3' is a cross product
@@ -4273,17 +4273,17 @@ POSTHOOK: query: select o.p_size, (select count(distinct p_type) from part p whe
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	1
+27	1
 39	1
 23	1
 28	1
-25	1
+45	1
+40	1
 31	1
-46	1
-27	1
 42	1
 34	1
-45	1
-40	1
+25	1
 Warning: Shuffle Join JOIN[28][tables = [$hdt$_0, $hdt$_1]] in Work 'Reducer 2' is a cross product
 Warning: Shuffle Join JOIN[31][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Work 'Reducer 3' is a cross product
 Warning: Shuffle Join JOIN[34][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Work 'Reducer 4' is a cross product
@@ -5388,31 +5388,31 @@ POSTHOOK: query: select t1.p_size,
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	1	28
+14	1	28
+1	1	28
+6	1	28
+27	1	28
 39	1	28
 10	1	28
 23	1	28
 28	1	28
+17	1	28
 14	1	28
 6	1	28
-2	2	28
-2	2	28
-25	1	28
+19	1	28
+45	1	28
 2	1	28
+40	1	28
 31	1	28
-46	1	28
-14	1	28
 7	1	28
 12	1	28
-1	1	28
-6	1	28
-27	1	28
 42	1	28
 34	1	28
-17	1	28
-19	1	28
-45	1	28
+2	2	28
+2	2	28
+25	1	28
 2	1	28
-40	1	28
 18	1	28
 PREHOOK: query: explain SELECT p_size, exp((SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type)) from part
 PREHOOK: type: QUERY
@@ -5522,29 +5522,29 @@ POSTHOOK: query: SELECT p_size, exp((SELECT max(p_size) FROM part p WHERE p.p_ty
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
+46	9.496119420602448E19
 1	2.718281828459045
-23	9.744803446248903E9
+34	5.834617425274549E14
 42	1.73927494152050099E18
-14	1202604.2841647768
+19	1.7848230096318725E8
 2	7.38905609893065
+14	1202604.2841647768
 6	403.4287934927351
+39	8.6593400423993744E16
 2	7.38905609893065
-2	7.38905609893065
-10	22026.465794806718
-2	7.38905609893065
-12	162754.79141900392
+27	5.3204824060179865E11
 6	403.4287934927351
 18	6.565996913733051E7
 7	1096.6331584284585
-46	9.496119420602448E19
 40	2.3538526683702E17
-34	5.834617425274549E14
-19	1.7848230096318725E8
+23	9.744803446248903E9
+14	1202604.2841647768
 17	2.9048849665247426E13
 31	2.9048849665247426E13
-14	1202604.2841647768
-39	8.6593400423993744E16
-27	5.3204824060179865E11
+2	7.38905609893065
+2	7.38905609893065
+10	22026.465794806718
 25	7.200489933738588E10
 28	1.446257064291475E12
+12	162754.79141900392
 45	3.4934271057485095E19

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/subquery_shared_alias.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/subquery_shared_alias.q.out b/ql/src/test/results/clientpositive/spark/subquery_shared_alias.q.out
index f907f91..0507ab7 100644
--- a/ql/src/test/results/clientpositive/spark/subquery_shared_alias.q.out
+++ b/ql/src/test/results/clientpositive/spark/subquery_shared_alias.q.out
@@ -10,14 +10,14 @@ where src.key in (select key from src where key > '9')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-92	val_92
-96	val_96
-97	val_97
-97	val_97
 90	val_90
 90	val_90
 90	val_90
+92	val_92
 95	val_95
 95	val_95
+96	val_96
+97	val_97
+97	val_97
 98	val_98
 98	val_98

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/transform_ppr1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/transform_ppr1.q.out b/ql/src/test/results/clientpositive/spark/transform_ppr1.q.out
index a7c5243..de2efda 100644
--- a/ql/src/test/results/clientpositive/spark/transform_ppr1.q.out
+++ b/ql/src/test/results/clientpositive/spark/transform_ppr1.q.out
@@ -99,6 +99,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -147,6 +148,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -195,6 +197,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -243,6 +246,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/transform_ppr2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/transform_ppr2.q.out b/ql/src/test/results/clientpositive/spark/transform_ppr2.q.out
index e48e6a3..2628ae6 100644
--- a/ql/src/test/results/clientpositive/spark/transform_ppr2.q.out
+++ b/ql/src/test/results/clientpositive/spark/transform_ppr2.q.out
@@ -101,6 +101,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -149,6 +150,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/truncate_column_buckets.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/truncate_column_buckets.q.out b/ql/src/test/results/clientpositive/spark/truncate_column_buckets.q.out
index edeab0b..38965e7 100644
--- a/ql/src/test/results/clientpositive/spark/truncate_column_buckets.q.out
+++ b/ql/src/test/results/clientpositive/spark/truncate_column_buckets.q.out
@@ -30,8 +30,8 @@ test_tab GROUP BY INPUT__FILE__NAME
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@test_tab
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-258
-242
+248
+252
 PREHOOK: query: TRUNCATE TABLE test_tab COLUMNS (value)
 PREHOOK: type: TRUNCATETABLE
 PREHOOK: Input: default@test_tab
@@ -54,5 +54,5 @@ test_tab GROUP BY INPUT__FILE__NAME
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@test_tab
 POSTHOOK: Output: hdfs://### HDFS PATH ###
-258
-242
+248
+252

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union22.q.out b/ql/src/test/results/clientpositive/spark/union22.q.out
index 9a94847..0a99d86 100644
--- a/ql/src/test/results/clientpositive/spark/union22.q.out
+++ b/ql/src/test/results/clientpositive/spark/union22.q.out
@@ -143,6 +143,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns k0,k1,k2,k3,k4,k5
                       columns.comments 
@@ -192,6 +193,7 @@ STAGE PLANS:
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                             properties:
                               bucket_count -1
+                              bucketing_version 2
                               column.name.delimiter ,
                               columns k1,k2,k3,k4
                               columns.comments 
@@ -245,6 +247,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns k0,k1,k2,k3,k4,k5
                       columns.comments 
@@ -309,6 +312,7 @@ STAGE PLANS:
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                                 properties:
                                   bucket_count -1
+                                  bucketing_version 2
                                   column.name.delimiter ,
                                   columns k1,k2,k3,k4
                                   columns.comments 
@@ -364,6 +368,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns k1,k2,k3,k4
                       columns.comments 
@@ -394,6 +399,7 @@ STAGE PLANS:
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               properties:
                 bucket_count -1
+                bucketing_version 2
                 column.name.delimiter ,
                 columns k1,k2,k3,k4
                 columns.comments 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union24.q.out b/ql/src/test/results/clientpositive/spark/union24.q.out
index d2e9df8..015f904 100644
--- a/ql/src/test/results/clientpositive/spark/union24.q.out
+++ b/ql/src/test/results/clientpositive/spark/union24.q.out
@@ -127,6 +127,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -148,6 +149,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -215,6 +217,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -236,6 +239,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -303,6 +307,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -324,6 +329,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -380,6 +386,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -401,6 +408,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -590,6 +598,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -611,6 +620,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -678,6 +688,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -699,6 +710,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -752,6 +764,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -773,6 +786,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -827,6 +841,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -848,6 +863,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -1030,6 +1046,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -1051,6 +1068,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -1118,6 +1136,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -1139,6 +1158,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -1192,6 +1212,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -1213,6 +1234,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 
@@ -1266,6 +1288,7 @@ STAGE PLANS:
                   properties:
                     COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                     bucket_count -1
+                    bucketing_version 2
                     column.name.delimiter ,
                     columns key,count
                     columns.comments 
@@ -1287,6 +1310,7 @@ STAGE PLANS:
                     properties:
                       COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,count
                       columns.comments 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_ppr.q.out b/ql/src/test/results/clientpositive/spark/union_ppr.q.out
index 1ef33b0..d1b9e3d 100644
--- a/ql/src/test/results/clientpositive/spark/union_ppr.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_ppr.q.out
@@ -89,6 +89,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -137,6 +138,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -217,6 +219,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'
@@ -265,6 +268,7 @@ STAGE PLANS:
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     properties:
                       bucket_count -1
+                      bucketing_version 2
                       column.name.delimiter ,
                       columns key,value
                       columns.comments 'default','default'

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_1.q.out b/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
index f6e5f98..5d17b36 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
@@ -158,6 +158,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	4                   
 	totalSize           	40                  
 #### A masked pattern was here ####

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_10.q.out b/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
index a19bbdb..f22bb29 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
@@ -234,8 +234,9 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	4                   
-	totalSize           	348                 
+	totalSize           	350                 
 #### A masked pattern was here ####
 	 	 
 # Storage Information	 	 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_11.q.out b/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
index 3b60a2f..f70a2d6 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
@@ -223,6 +223,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	3                   
 	totalSize           	273                 
 #### A masked pattern was here ####

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_12.q.out b/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
index b27bdec..fb83bcc 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_12.q.out
@@ -225,6 +225,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	2                   
 	totalSize           	194                 
 #### A masked pattern was here ####

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_13.q.out b/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
index 3eb71d2..cf3e352 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_13.q.out
@@ -248,8 +248,9 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	3                   
-	totalSize           	269                 
+	totalSize           	271                 
 #### A masked pattern was here ####
 	 	 
 # Storage Information	 	 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_14.q.out b/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
index b27bdec..fb83bcc 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_14.q.out
@@ -225,6 +225,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	2                   
 	totalSize           	194                 
 #### A masked pattern was here ####

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_15.q.out b/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
index aeed21a..41477a7 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
@@ -175,11 +175,12 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	4                   
 	numPartitions       	2                   
 	numRows             	0                   
 	rawDataSize         	0                   
-	totalSize           	332                 
+	totalSize           	336                 
 #### A masked pattern was here ####
 	 	 
 # Storage Information	 	 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_16.q.out b/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
index 18c479c..e39dbd4 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
@@ -217,11 +217,12 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	4                   
 	numPartitions       	2                   
 	numRows             	0                   
 	rawDataSize         	0                   
-	totalSize           	332                 
+	totalSize           	336                 
 #### A masked pattern was here ####
 	 	 
 # Storage Information	 	 

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_17.q.out b/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
index 9782885..5a80207 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
@@ -152,6 +152,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	2                   
 	numPartitions       	2                   
 	numRows             	0                   

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_18.q.out b/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
index c29113f..1f8d8a5 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
@@ -187,6 +187,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	12                  
 	numPartitions       	6                   
 	numRows             	0                   

http://git-wip-us.apache.org/repos/asf/hive/blob/54651c78/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_remove_19.q.out b/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
index 3ab4467..aeafa39 100644
--- a/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
+++ b/ql/src/test/results/clientpositive/spark/union_remove_19.q.out
@@ -158,6 +158,7 @@ Retention:          	0
 #### A masked pattern was here ####
 Table Type:         	MANAGED_TABLE       	 
 Table Parameters:	 	 
+	bucketing_version   	2                   
 	numFiles            	4                   
 	totalSize           	40                  
 #### A masked pattern was here ####


Mime
View raw message