impala-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From k...@apache.org
Subject [07/11] incubator-impala git commit: IMPALA-5376: Loads all TPC-DS tables
Date Sat, 27 May 2017 05:34:37 GMT
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q23-1.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q23-1.test b/testdata/workloads/tpcds/queries/tpcds-q23-1.test
new file mode 100644
index 0000000..7ec3bb4
--- /dev/null
+++ b/testdata/workloads/tpcds/queries/tpcds-q23-1.test
@@ -0,0 +1,60 @@
+====
+---- QUERY: TPCDS-Q23
+with frequent_ss_items as
+ (select substr(i_item_desc,1,30) itemdesc,
+         i_item_sk item_sk,
+         d_date solddate,
+         count(*) cnt
+  from store_sales,
+       date_dim,
+       item
+  where ss_sold_date_sk = d_date_sk
+    and ss_item_sk = i_item_sk
+    and d_year in (2000,2000+1,2000+2,2000+3)
+  group by substr(i_item_desc,1,30),i_item_sk,d_date
+  having count(*) > 4),
+ max_store_sales as
+ (select max(csales) tpcds_cmax
+  from (select c_customer_sk,
+               sum(ss_quantity*ss_sales_price) csales
+        from store_sales,
+             customer,
+             date_dim
+        where ss_customer_sk = c_customer_sk
+         and ss_sold_date_sk = d_date_sk
+         and d_year in (2000,2000+1,2000+2,2000+3)
+        group by c_customer_sk) x),
+ best_ss_customer as
+ (select t1.* from
+  (select c_customer_sk,
+          sum(ss_quantity*ss_sales_price) ssales
+   from store_sales,
+        customer
+   where ss_customer_sk = c_customer_sk
+   group by c_customer_sk) t1,
+  (select tpcds_cmax * (50/100.0) as c1 from max_store_sales) t2
+  where t1.ssales > t2.c1)
+select sum(sales)
+from (select cs_quantity*cs_list_price sales
+      from catalog_sales,
+           date_dim
+      where d_year = 2000
+        and d_moy = 2
+        and cs_sold_date_sk = d_date_sk
+        and cs_item_sk in (select item_sk from frequent_ss_items)
+        and cs_bill_customer_sk in (select c_customer_sk from best_ss_customer)
+      union all
+      select ws_quantity*ws_list_price sales
+      from web_sales,
+           date_dim
+      where d_year = 2000
+        and d_moy = 2
+        and ws_sold_date_sk = d_date_sk
+        and ws_item_sk in (select item_sk from frequent_ss_items)
+        and ws_bill_customer_sk in (select c_customer_sk from best_ss_customer)) x
+limit 100;
+---- RESULTS
+17030.91
+---- TYPES
+DECIMAL
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q23-2.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q23-2.test b/testdata/workloads/tpcds/queries/tpcds-q23-2.test
new file mode 100644
index 0000000..3b9e060
--- /dev/null
+++ b/testdata/workloads/tpcds/queries/tpcds-q23-2.test
@@ -0,0 +1,70 @@
+====
+---- QUERY: TPCDS-Q23
+with frequent_ss_items as
+ (select substr(i_item_desc,1,30) itemdesc,
+         i_item_sk item_sk,
+         d_date solddate,
+         count(*) cnt
+  from store_sales,
+       date_dim,
+       item
+  where ss_sold_date_sk = d_date_sk
+    and ss_item_sk = i_item_sk
+    and d_year in (2000,2000 + 1,2000 + 2,2000 + 3)
+  group by substr(i_item_desc,1,30),i_item_sk,d_date
+  having count(*) > 4),
+ max_store_sales as
+ (select max(csales) tpcds_cmax
+  from (select c_customer_sk,sum(ss_quantity*ss_sales_price) csales
+        from store_sales,
+             customer,
+             date_dim
+        where ss_customer_sk = c_customer_sk
+         and ss_sold_date_sk = d_date_sk
+         and d_year in (2000,2000+1,2000+2,2000+3)
+        group by c_customer_sk) x),
+ best_ss_customer as
+ (select t1.* from
+  (select c_customer_sk,sum(ss_quantity*ss_sales_price) ssales
+   from store_sales,
+        customer
+   where ss_customer_sk = c_customer_sk
+   group by c_customer_sk) t1,
+  (select tpcds_cmax * (50/100.0) as c1 from max_store_sales) t2
+  where t1.ssales > t2.c1)
+select c_last_name,c_first_name,sales
+from ((select c_last_name,c_first_name,sum(cs_quantity*cs_list_price) sales
+       from catalog_sales,
+            customer,
+            date_dim
+       where d_year = 2000
+         and d_moy = 2
+         and cs_sold_date_sk = d_date_sk
+         and cs_item_sk in (select distinct item_sk from frequent_ss_items)
+         and cs_bill_customer_sk in (select distinct c_customer_sk from best_ss_customer)
+         and cs_bill_customer_sk = c_customer_sk
+       group by c_last_name,c_first_name)
+      union all
+      (select c_last_name,c_first_name,sum(ws_quantity*ws_list_price) sales
+       from web_sales,
+            customer,
+            date_dim
+       where d_year = 2000
+         and d_moy = 2
+         and ws_sold_date_sk = d_date_sk
+         and ws_item_sk in (select distinct item_sk from frequent_ss_items)
+         and ws_bill_customer_sk in (select distinct c_customer_sk from best_ss_customer)
+         and ws_bill_customer_sk = c_customer_sk
+       group by c_last_name,c_first_name)) y
+     order by c_last_name,
+              c_first_name,
+              sales
+limit 100;
+---- RESULTS
+'Brown','Monika',6031.52
+'Collins','Gordon',727.57
+'Green','Jesse',9672.96
+'NULL','Robert',598.86
+---- TYPES
+STRING, STRING, DECIMAL
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q27.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q27.test b/testdata/workloads/tpcds/queries/tpcds-q27.test
index f025b31..59a792f 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q27.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q27.test
@@ -1,5 +1,6 @@
 ====
 ---- QUERY: TPCDS-Q27
+# TODO: Fix this query up when rollup is implemented
 select
   i_item_id,
   s_state,
@@ -19,14 +20,13 @@ where
   and ss_item_sk = i_item_sk
   and ss_store_sk = s_store_sk
   and ss_cdemo_sk = cd_demo_sk
-  and cd_gender = 'F'
-  and cd_marital_status = 'W'
-  and cd_education_status = 'Primary'
-  and d_year = 1998
-  and s_state in ('WI', 'CA', 'TX', 'FL', 'WA', 'TN')
-  and ss_sold_date_sk between 2450815 and 2451179  -- partition key filter
+  and cd_gender = 'M'
+  and cd_marital_status = 'S'
+  and cd_education_status = 'College'
+  and d_year = 2002
+  and s_state in ('TN','TN', 'TN', 'TN', 'TN', 'TN')
 group by
-  -- rollup (i_item_id, s_state)
+  -- rollup (i_item_id, s_state),
   i_item_id,
   s_state
 order by
@@ -34,106 +34,106 @@ order by
   s_state
 limit 100;
 ---- RESULTS
-'AAAAAAAAAAKBAAAA','TN',7,87.58,64.06,16.64
-'AAAAAAAAAAPBAAAA','TN',6,87.26,NULL,NULL
-'AAAAAAAAABEDAAAA','TN',76,132.50,377.60,99.37
-'AAAAAAAAABGAAAAA','TN',58,16.67,0.00,6.00
-'AAAAAAAAABLBAAAA','TN',99,87.60,854.96,50.80
-'AAAAAAAAABOCAAAA','TN',99,55.69,0.00,49.00
-'AAAAAAAAACJAAAAA','TN',5,86.28,0.00,50.04
-'AAAAAAAAACJCAAAA','TN',56,104.37,0.00,55.31
-'AAAAAAAAACLDAAAA','TN',93,6.70,0.00,3.35
-'AAAAAAAAACPDAAAA','TN',96,88.68,292.67,7.09
-'AAAAAAAAADDEAAAA','TN',26,45.17,0.00,28.00
-'AAAAAAAAADHBAAAA','TN',51,97.68,0.00,51.77
-'AAAAAAAAADKBAAAA','TN',15,92.10,0.00,6.44
-'AAAAAAAAADNDAAAA','TN',71,105.42,0.00,34.78
-'AAAAAAAAAEBDAAAA','TN',76,105.15,1924.19,29.44
-'AAAAAAAAAEECAAAA','TN',83,106.43,0.00,71.30
-'AAAAAAAAAEEDAAAA','TN',1,37.90,0.00,35.62
-'AAAAAAAAAFDAAAAA','TN',66,53.14,1115.99,45.70
-'AAAAAAAAAFGCAAAA','TN',3,88.53,0.00,83.21
-'AAAAAAAAAFGDAAAA','TN',71,34.19,0.00,24.61
-'AAAAAAAAAGBEAAAA','TN',78,139.86,523.53,33.56
-'AAAAAAAAAHDEAAAA','TN',72,118.30,0.00,13.01
-'AAAAAAAAAHIBAAAA','TN',70,168.16,0.00,122.75
-'AAAAAAAAAIIBAAAA','TN',65.5,115.60,797.94,64.73
-'AAAAAAAAAJBBAAAA','TN',86,28.53,0.00,22.25
-'AAAAAAAAAJCCAAAA','TN',74,71.12,0.00,9.24
-'AAAAAAAAAJHAAAAA','TN',2,135.97,0.00,114.21
-'AAAAAAAAAJKAAAAA','TN',15,88.40,0.00,70.72
-'AAAAAAAAAJLDAAAA','TN',38,182.13,0.00,74.67
-'AAAAAAAAAKMDAAAA','TN',77,101.27,0.00,98.23
-'AAAAAAAAALMAAAAA','TN',23,101.43,198.48,37.52
-'AAAAAAAAAMABAAAA','TN',55,127.02,1466.85,38.10
-'AAAAAAAAAMDBAAAA','TN',5,85.09,0.00,51.90
-'AAAAAAAAAMDEAAAA','TN',29,33.22,0.00,27.57
-'AAAAAAAAAMEAAAAA','TN',98,147.70,0.00,13.29
-'AAAAAAAAAMICAAAA','TN',37,69.07,42.91,16.57
-'AAAAAAAAAMLAAAAA','TN',63,101.63,0.00,40.65
-'AAAAAAAAANABAAAA','TN',85,38.40,0.00,16.51
-'AAAAAAAAANAEAAAA','TN',54,31.49,0.00,24.56
-'AAAAAAAAANDDAAAA','TN',43,170.16,0.00,122.51
-'AAAAAAAAAOEBAAAA','TN',94,78.58,0.00,42.43
-'AAAAAAAAAOHBAAAA','TN',42,141.03,0.00,115.64
-'AAAAAAAAAOKCAAAA','TN',71,39.16,810.50,31.71
-'AAAAAAAAAPGBAAAA','TN',32,99.61,0.00,58.76
-'AAAAAAAAAPIAAAAA','TN',70,124.69,2793.71,120.94
-'AAAAAAAABAADAAAA','TN',40,26.11,0.00,3.65
-'AAAAAAAABAFEAAAA','TN',76,51.74,0.00,19.66
-'AAAAAAAABAJAAAAA','TN',3,134.06,85.26,71.05
-'AAAAAAAABAKCAAAA','TN',71,60.70,1672.16,24.28
-'AAAAAAAABAPDAAAA','TN',44,88.92,0.00,62.24
-'AAAAAAAABBNBAAAA','TN',42,139.89,0.00,48.96
-'AAAAAAAABCNAAAAA','TN',84,139.60,0.00,37.69
-'AAAAAAAABDGDAAAA','TN',49,24.89,0.00,2.24
-'AAAAAAAABDHCAAAA','TN',60,27.62,0.00,25.41
-'AAAAAAAABFHDAAAA','TN',94,31.46,0.00,0.00
-'AAAAAAAABIDBAAAA','TN',56,140.91,0.00,23.95
-'AAAAAAAABIGBAAAA','TN',21,37.77,0.00,24.92
-'AAAAAAAABJBCAAAA','TN',32,2.96,0.00,0.00
-'AAAAAAAABJFEAAAA','TN',96,43.52,0.00,16.97
-'AAAAAAAABKFDAAAA','TN',47,23.11,487.22,11.78
-'AAAAAAAABLDEAAAA','TN',10,12.16,0.00,9.12
-'AAAAAAAABMDAAAAA','TN',84,43.80,0.00,35.91
-'AAAAAAAABNCAAAAA','TN',37,122.93,0.00,11.06
-'AAAAAAAABNLDAAAA','TN',56,83.50,0.00,5.01
-'AAAAAAAABOGBAAAA','TN',42,98.26,3031.98,91.38
-'AAAAAAAABPGAAAAA','TN',40,59.76,0.00,15.53
-'AAAAAAAACABEAAAA','TN',35,107.64,0.00,35.52
-'AAAAAAAACACEAAAA','TN',21,10.20,0.00,6.73
-'AAAAAAAACAEEAAAA','TN',11,54.23,0.00,11.38
-'AAAAAAAACALBAAAA','TN',72,146.68,0.00,71.87
-'AAAAAAAACAMCAAAA','TN',29,5.33,0.00,4.79
-'AAAAAAAACAOBAAAA','TN',9,34.38,103.65,17.19
-'AAAAAAAACBFCAAAA','TN',4,73.22,14.05,3.66
-'AAAAAAAACBOCAAAA','TN',100,85.56,0.00,83.84
-'AAAAAAAACCICAAAA','TN',17,89.34,0.00,64.32
-'AAAAAAAACCMAAAAA','TN',42,30.54,0.00,8.10
-'AAAAAAAACDIDAAAA','TN',59,20.70,161.61,12.38
-'AAAAAAAACDLAAAAA','TN',58,71.89,0.00,19.41
-'AAAAAAAACEABAAAA','TN',63,110.83,0.00,5.54
-'AAAAAAAACEBEAAAA','TN',74,31.51,90.90,8.19
-'AAAAAAAACEEAAAAA','TN',42,116.06,0.00,49.90
-'AAAAAAAACFAEAAAA','TN',17,51.60,0.00,27.86
-'AAAAAAAACFIBAAAA','TN',93,121.19,0.00,9.69
-'AAAAAAAACGACAAAA','TN',11,137.04,0.00,98.66
-'AAAAAAAACGMDAAAA','TN',53,76.98,0.00,73.90
-'AAAAAAAACHBAAAAA','TN',79,112.14,0.00,108.77
-'AAAAAAAACHICAAAA','TN',99,42.85,0.00,42.42
-'AAAAAAAACHLAAAAA','TN',26,146.89,0.00,8.81
-'AAAAAAAACHPCAAAA','TN',13,45.93,0.00,18.83
-'AAAAAAAACIBDAAAA','TN',2,6.31,0.16,4.10
-'AAAAAAAACJBEAAAA','TN',71,46.81,0.00,1.87
-'AAAAAAAACJLDAAAA','TN',35,91.70,2199.19,70.60
-'AAAAAAAACJODAAAA','TN',4,68.66,140.87,65.22
-'AAAAAAAACKOAAAAA','TN',17,164.89,0.00,153.34
-'AAAAAAAACLCEAAAA','TN',18,78.95,0.00,43.42
-'AAAAAAAACLEAAAAA','TN',84,55.07,0.00,51.21
-'AAAAAAAACLJDAAAA','TN',28,14.37,72.85,5.31
-'AAAAAAAACMBEAAAA','TN',18,133.72,0.00,64.18
-'AAAAAAAACMIBAAAA','TN',6,100.05,0.00,19.00
-'AAAAAAAACMMAAAAA','TN',36,127.11,0.00,105.50
+'AAAAAAAAAAABAAAA','TN',46,114.72,0.00,32.12
+'AAAAAAAAAAAEAAAA','TN',100,77.97,0.00,57.69
+'AAAAAAAAAABAAAAA','TN',6,48.89,13.61,2.44
+'AAAAAAAAAACAAAAA','TN',62,32.21,0.00,5.50
+'AAAAAAAAAACDAAAA','TN',97,161.78,0.00,55.00
+'AAAAAAAAAADBAAAA','TN',28,136.01,575.76,73.44
+'AAAAAAAAAADCAAAA','TN',64,116.14,0.00,108.01
+'AAAAAAAAAAEBAAAA','TN',9,5.43,0.00,5.21
+'AAAAAAAAAAEDAAAA','TN',45.5,87.63,0.00,51.84
+'AAAAAAAAAAGBAAAA','TN',29,101.94,0.00,100.92
+'AAAAAAAAAAGCAAAA','TN',97,65.27,0.00,21.53
+'AAAAAAAAAAGEAAAA','TN',55,73.87,0.00,71.00
+'AAAAAAAAAAHAAAAA','TN',20,134.30,0.00,119.52
+'AAAAAAAAAAHBAAAA','TN',97,7.40,0.00,6.73
+'AAAAAAAAAAHDAAAA','TN',69,5.62,0.00,0.33
+'AAAAAAAAAAIAAAAA','TN',87,106.98,0.00,27.81
+'AAAAAAAAAAKBAAAA','TN',84.5,66.17,847.83,57.38
+'AAAAAAAAAALAAAAA','TN',6,32.28,0.00,7.42
+'AAAAAAAAAALCAAAA','TN',98,34.31,55.30,1.71
+'AAAAAAAAAALDAAAA','TN',59,129.47,713.90,22.00
+'AAAAAAAAAANAAAAA','TN',74,60.87,0.00,13.20
+'AAAAAAAAAANBAAAA','TN',96,130.79,1864.51,129.48
+'AAAAAAAAAAOAAAAA','TN',85,130.34,0.00,122.51
+'AAAAAAAAAAOCAAAA','TN',14,64.57,0.00,33.97
+'AAAAAAAAAAODAAAA','TN',84,30.50,0.00,28.97
+'AAAAAAAAAAPBAAAA','TN',45,118.89,2380.59,84.71
+'AAAAAAAAABAAAAAA','TN',97,124.75,0.00,74.85
+'AAAAAAAAABABAAAA','TN',31,29.98,17.09,27.58
+'AAAAAAAAABAEAAAA','TN',34,17.21,0.00,13.42
+'AAAAAAAAABCBAAAA','TN',38,131.37,0.00,52.32
+'AAAAAAAAABDAAAAA','TN',31.5,68.34,0.00,63.27
+'AAAAAAAAABDBAAAA','TN',56,103.85,1624.17,59.19
+'AAAAAAAAABDDAAAA','TN',67.33333333333333,119.42,23.18,38.72
+'AAAAAAAAABDEAAAA','TN',61,85.95,2282.36,44.60
+'AAAAAAAAABEDAAAA','TN',61,85.14,0.00,50.23
+'AAAAAAAAABFBAAAA','TN',31,23.55,0.00,13.65
+'AAAAAAAAABFCAAAA','TN',83,15.50,0.00,0.00
+'AAAAAAAAABGAAAAA','TN',64,35.08,0.00,3.15
+'AAAAAAAAABGBAAAA','TN',40,25.07,0.00,16.04
+'AAAAAAAAABGEAAAA','TN',39.5,56.76,14.25,36.00
+'AAAAAAAAABHAAAAA','TN',93,74.80,0.00,21.69
+'AAAAAAAAABHCAAAA','TN',31.5,79.83,181.38,61.93
+'AAAAAAAAABIBAAAA','TN',48,170.89,0.00,140.12
+'AAAAAAAAABJAAAAA','TN',46.5,82.32,0.00,44.98
+'AAAAAAAAABJBAAAA','TN',76,12.40,0.00,3.96
+'AAAAAAAAABJDAAAA','TN',34,118.50,0.00,61.20
+'AAAAAAAAABKAAAAA','TN',65,8.77,0.00,5.18
+'AAAAAAAAABKCAAAA','TN',26,51.57,0.00,41.25
+'AAAAAAAAABLBAAAA','TN',61.5,149.12,0.00,82.54
+'AAAAAAAAABMAAAAA','TN',14,109.97,0.00,10.99
+'AAAAAAAAABMDAAAA','TN',97,104.87,0.00,34.60
+'AAAAAAAAABNAAAAA','TN',13.5,17.39,0.00,2.02
+'AAAAAAAAABOBAAAA','TN',66,112.86,0.00,24.82
+'AAAAAAAAABPAAAAA','TN',19,67.33,268.60,16.83
+'AAAAAAAAABPDAAAA','TN',37,41.16,0.00,20.22
+'AAAAAAAAACACAAAA','TN',53,132.50,0.00,15.90
+'AAAAAAAAACADAAAA','TN',73,76.59,782.56,21.44
+'AAAAAAAAACBBAAAA','TN',82,75.22,277.55,10.24
+'AAAAAAAAACBCAAAA','TN',53,35.46,0.00,21.98
+'AAAAAAAAACBEAAAA','TN',49,113.20,1902.14,75.14
+'AAAAAAAAACCAAAAA','TN',60,111.87,0.00,74.95
+'AAAAAAAAACCEAAAA','TN',89,73.99,0.00,4.43
+'AAAAAAAAACDAAAAA','TN',35,86.57,0.00,22.63
+'AAAAAAAAACDCAAAA','TN',30,68.03,0.00,55.59
+'AAAAAAAAACDDAAAA','TN',67.66666666666667,21.32,0.00,7.83
+'AAAAAAAAACEBAAAA','TN',69.5,81.94,0.00,29.79
+'AAAAAAAAACECAAAA','TN',89,47.10,0.00,20.72
+'AAAAAAAAACFBAAAA','TN',70,14.60,0.00,8.46
+'AAAAAAAAACFDAAAA','TN',53,106.16,0.00,91.29
+'AAAAAAAAACFEAAAA','TN',40.33333333333334,103.41,0.00,18.00
+'AAAAAAAAACGAAAAA','TN',41,10.00,0.00,6.70
+'AAAAAAAAACGDAAAA','TN',4,6.32,0.00,3.72
+'AAAAAAAAACHBAAAA','TN',51,67.85,1521.28,54.99
+'AAAAAAAAACHCAAAA','TN',4,101.18,0.00,97.13
+'AAAAAAAAACKBAAAA','TN',96,123.44,0.00,122.20
+'AAAAAAAAACKCAAAA','TN',44,48.71,0.00,23.86
+'AAAAAAAAACLDAAAA','TN',50,130.80,0.00,13.08
+'AAAAAAAAACMDAAAA','TN',33,91.53,0.00,71.39
+'AAAAAAAAACNCAAAA','TN',27,69.84,0.00,27.93
+'AAAAAAAAACODAAAA','TN',54,57.73,0.00,7.78
+'AAAAAAAAACPAAAAA','TN',36,103.03,0.00,97.87
+'AAAAAAAAADABAAAA','TN',20,194.76,0.00,5.84
+'AAAAAAAAADAEAAAA','TN',53,65.66,0.00,53.84
+'AAAAAAAAADBAAAAA','TN',48,87.49,0.00,74.79
+'AAAAAAAAADBBAAAA','TN',88,48.86,0.00,9.77
+'AAAAAAAAADBDAAAA','TN',41,27.62,380.27,13.25
+'AAAAAAAAADBEAAAA','TN',33.5,112.42,0.00,55.36
+'AAAAAAAAADCAAAAA','TN',59,5.43,0.00,4.88
+'AAAAAAAAADDBAAAA','TN',25,149.67,0.00,125.72
+'AAAAAAAAADDEAAAA','TN',54,11.80,0.00,8.26
+'AAAAAAAAADEAAAAA','TN',23,132.68,0.00,30.51
+'AAAAAAAAADEDAAAA','TN',99,48.89,0.00,48.89
+'AAAAAAAAADFAAAAA','TN',67.5,45.22,0.00,19.09
+'AAAAAAAAADFCAAAA','TN',77,101.79,0.00,39.69
+'AAAAAAAAADFDAAAA','TN',94,79.82,414.86,63.05
+'AAAAAAAAADGCAAAA','TN',19,14.27,0.00,5.56
+'AAAAAAAAADGEAAAA','TN',75.66666666666667,123.31,413.13,51.38
+'AAAAAAAAADHBAAAA','TN',15,179.13,496.44,39.40
+'AAAAAAAAADHDAAAA','TN',98,39.30,0.00,33.79
+'AAAAAAAAADIAAAAA','TN',27,124.51,0.00,107.07
 ---- TYPES
 STRING, STRING, DOUBLE, DECIMAL, DECIMAL, DECIMAL
 ====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q27a.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q27a.test b/testdata/workloads/tpcds/queries/tpcds-q27a.test
new file mode 100644
index 0000000..eb510f1
--- /dev/null
+++ b/testdata/workloads/tpcds/queries/tpcds-q27a.test
@@ -0,0 +1,163 @@
+====
+---- QUERY: TPCDS-Q27a
+with results as
+ (select i_item_id,
+         s_state,
+         0 as g_state,
+         ss_quantity agg1,
+         ss_list_price agg2,
+         ss_coupon_amt agg3,
+         ss_sales_price agg4
+  from store_sales,
+       customer_demographics,
+       date_dim,
+       store,
+       item
+  where ss_sold_date_sk = d_date_sk and
+        ss_item_sk = i_item_sk and
+         ss_store_sk = s_store_sk and
+        ss_cdemo_sk = cd_demo_sk and
+        cd_gender = 'M' and
+        cd_marital_status = 'S' and
+        cd_education_status = 'College' and
+        d_year = 2002 and
+        s_state in ('TN','TN', 'TN', 'TN', 'TN', 'TN'))
+select i_item_id,
+       s_state,
+       g_state,
+       agg1,
+       agg2,
+       agg3,
+       agg4
+from (select i_item_id,
+             s_state,
+             0 as g_state,
+             avg(agg1) agg1,
+             avg(agg2) agg2,
+             avg(agg3) agg3,
+             avg(agg4) agg4 from results
+      group by i_item_id,
+               s_state
+      union all
+      select i_item_id,
+             NULL AS s_state,
+             1 AS g_state,
+             avg(agg1) agg1,
+             avg(agg2) agg2,
+             avg(agg3) agg3,
+             avg(agg4) agg4 from results
+      group by i_item_id
+      union all
+      select NULL AS i_item_id,
+             NULL as s_state,
+             1 as g_state,
+             avg(agg1) agg1,
+             avg(agg2) agg2,
+             avg(agg3) agg3,
+             avg(agg4) agg4 from results) foo
+order by i_item_id, s_state
+limit 100;
+---- RESULTS
+'AAAAAAAAAAABAAAA','TN',0,46,114.72,0.00,32.12
+'AAAAAAAAAAABAAAA','NULL',1,46,114.72,0.00,32.12
+'AAAAAAAAAAAEAAAA','TN',0,100,77.97,0.00,57.69
+'AAAAAAAAAAAEAAAA','NULL',1,100,77.97,0.00,57.69
+'AAAAAAAAAABAAAAA','TN',0,6,48.89,13.61,2.44
+'AAAAAAAAAABAAAAA','NULL',1,6,48.89,13.61,2.44
+'AAAAAAAAAACAAAAA','TN',0,62,32.21,0.00,5.50
+'AAAAAAAAAACAAAAA','NULL',1,62,32.21,0.00,5.50
+'AAAAAAAAAACDAAAA','TN',0,97,161.78,0.00,55.00
+'AAAAAAAAAACDAAAA','NULL',1,97,161.78,0.00,55.00
+'AAAAAAAAAADBAAAA','TN',0,28,136.01,575.76,73.44
+'AAAAAAAAAADBAAAA','NULL',1,28,136.01,575.76,73.44
+'AAAAAAAAAADCAAAA','TN',0,64,116.14,0.00,108.01
+'AAAAAAAAAADCAAAA','NULL',1,64,116.14,0.00,108.01
+'AAAAAAAAAAEBAAAA','TN',0,9,5.43,0.00,5.21
+'AAAAAAAAAAEBAAAA','NULL',1,9,5.43,0.00,5.21
+'AAAAAAAAAAEDAAAA','TN',0,45.5,87.63,0.00,51.84
+'AAAAAAAAAAEDAAAA','NULL',1,45.5,87.63,0.00,51.84
+'AAAAAAAAAAGBAAAA','TN',0,29,101.94,0.00,100.92
+'AAAAAAAAAAGBAAAA','NULL',1,29,101.94,0.00,100.92
+'AAAAAAAAAAGCAAAA','TN',0,97,65.27,0.00,21.53
+'AAAAAAAAAAGCAAAA','NULL',1,97,65.27,0.00,21.53
+'AAAAAAAAAAGEAAAA','TN',0,55,73.87,0.00,71.00
+'AAAAAAAAAAGEAAAA','NULL',1,55,73.87,0.00,71.00
+'AAAAAAAAAAHAAAAA','TN',0,20,134.30,0.00,119.52
+'AAAAAAAAAAHAAAAA','NULL',1,20,134.30,0.00,119.52
+'AAAAAAAAAAHBAAAA','TN',0,97,7.40,0.00,6.73
+'AAAAAAAAAAHBAAAA','NULL',1,97,7.40,0.00,6.73
+'AAAAAAAAAAHDAAAA','TN',0,69,5.62,0.00,0.33
+'AAAAAAAAAAHDAAAA','NULL',1,69,5.62,0.00,0.33
+'AAAAAAAAAAIAAAAA','TN',0,87,106.98,0.00,27.81
+'AAAAAAAAAAIAAAAA','NULL',1,87,106.98,0.00,27.81
+'AAAAAAAAAAKBAAAA','TN',0,84.5,66.17,847.83,57.38
+'AAAAAAAAAAKBAAAA','NULL',1,84.5,66.17,847.83,57.38
+'AAAAAAAAAALAAAAA','TN',0,6,32.28,0.00,7.42
+'AAAAAAAAAALAAAAA','NULL',1,6,32.28,0.00,7.42
+'AAAAAAAAAALCAAAA','TN',0,98,34.31,55.30,1.71
+'AAAAAAAAAALCAAAA','NULL',1,98,34.31,55.30,1.71
+'AAAAAAAAAALDAAAA','TN',0,59,129.47,713.90,22.00
+'AAAAAAAAAALDAAAA','NULL',1,59,129.47,713.90,22.00
+'AAAAAAAAAANAAAAA','TN',0,74,60.87,0.00,13.20
+'AAAAAAAAAANAAAAA','NULL',1,74,60.87,0.00,13.20
+'AAAAAAAAAANBAAAA','TN',0,96,130.79,1864.51,129.48
+'AAAAAAAAAANBAAAA','NULL',1,96,130.79,1864.51,129.48
+'AAAAAAAAAAOAAAAA','TN',0,85,130.34,0.00,122.51
+'AAAAAAAAAAOAAAAA','NULL',1,85,130.34,0.00,122.51
+'AAAAAAAAAAOCAAAA','TN',0,14,64.57,0.00,33.97
+'AAAAAAAAAAOCAAAA','NULL',1,14,64.57,0.00,33.97
+'AAAAAAAAAAODAAAA','TN',0,84,30.50,0.00,28.97
+'AAAAAAAAAAODAAAA','NULL',1,84,30.50,0.00,28.97
+'AAAAAAAAAAPBAAAA','TN',0,45,118.89,2380.59,84.71
+'AAAAAAAAAAPBAAAA','NULL',1,45,118.89,2380.59,84.71
+'AAAAAAAAABAAAAAA','TN',0,97,124.75,0.00,74.85
+'AAAAAAAAABAAAAAA','NULL',1,97,124.75,0.00,74.85
+'AAAAAAAAABABAAAA','TN',0,31,29.98,17.09,27.58
+'AAAAAAAAABABAAAA','NULL',1,31,29.98,17.09,27.58
+'AAAAAAAAABAEAAAA','TN',0,34,17.21,0.00,13.42
+'AAAAAAAAABAEAAAA','NULL',1,34,17.21,0.00,13.42
+'AAAAAAAAABCBAAAA','TN',0,38,131.37,0.00,52.32
+'AAAAAAAAABCBAAAA','NULL',1,38,131.37,0.00,52.32
+'AAAAAAAAABDAAAAA','TN',0,31.5,68.34,0.00,63.27
+'AAAAAAAAABDAAAAA','NULL',1,31.5,68.34,0.00,63.27
+'AAAAAAAAABDBAAAA','TN',0,56,103.85,1624.17,59.19
+'AAAAAAAAABDBAAAA','NULL',1,56,103.85,1624.17,59.19
+'AAAAAAAAABDDAAAA','TN',0,67.33333333333333,119.42,23.18,38.72
+'AAAAAAAAABDDAAAA','NULL',1,67.33333333333333,119.42,23.18,38.72
+'AAAAAAAAABDEAAAA','TN',0,61,85.95,2282.36,44.60
+'AAAAAAAAABDEAAAA','NULL',1,61,85.95,2282.36,44.60
+'AAAAAAAAABEDAAAA','TN',0,61,85.14,0.00,50.23
+'AAAAAAAAABEDAAAA','NULL',1,61,85.14,0.00,50.23
+'AAAAAAAAABFBAAAA','TN',0,31,23.55,0.00,13.65
+'AAAAAAAAABFBAAAA','NULL',1,31,23.55,0.00,13.65
+'AAAAAAAAABFCAAAA','TN',0,83,15.50,0.00,0.00
+'AAAAAAAAABFCAAAA','NULL',1,83,15.50,0.00,0.00
+'AAAAAAAAABGAAAAA','TN',0,64,35.08,0.00,3.15
+'AAAAAAAAABGAAAAA','NULL',1,64,35.08,0.00,3.15
+'AAAAAAAAABGBAAAA','TN',0,40,25.07,0.00,16.04
+'AAAAAAAAABGBAAAA','NULL',1,40,25.07,0.00,16.04
+'AAAAAAAAABGEAAAA','TN',0,39.5,56.76,14.25,36.00
+'AAAAAAAAABGEAAAA','NULL',1,39.5,56.76,14.25,36.00
+'AAAAAAAAABHAAAAA','TN',0,93,74.80,0.00,21.69
+'AAAAAAAAABHAAAAA','NULL',1,93,74.80,0.00,21.69
+'AAAAAAAAABHCAAAA','TN',0,31.5,79.83,181.38,61.93
+'AAAAAAAAABHCAAAA','NULL',1,31.5,79.83,181.38,61.93
+'AAAAAAAAABIBAAAA','TN',0,48,170.89,0.00,140.12
+'AAAAAAAAABIBAAAA','NULL',1,48,170.89,0.00,140.12
+'AAAAAAAAABJAAAAA','TN',0,46.5,82.32,0.00,44.98
+'AAAAAAAAABJAAAAA','NULL',1,46.5,82.32,0.00,44.98
+'AAAAAAAAABJBAAAA','TN',0,76,12.40,0.00,3.96
+'AAAAAAAAABJBAAAA','NULL',1,76,12.40,0.00,3.96
+'AAAAAAAAABJDAAAA','TN',0,34,118.50,0.00,61.20
+'AAAAAAAAABJDAAAA','NULL',1,34,118.50,0.00,61.20
+'AAAAAAAAABKAAAAA','TN',0,65,8.77,0.00,5.18
+'AAAAAAAAABKAAAAA','NULL',1,65,8.77,0.00,5.18
+'AAAAAAAAABKCAAAA','TN',0,26,51.57,0.00,41.25
+'AAAAAAAAABKCAAAA','NULL',1,26,51.57,0.00,41.25
+'AAAAAAAAABLBAAAA','TN',0,61.5,149.12,0.00,82.54
+'AAAAAAAAABLBAAAA','NULL',1,61.5,149.12,0.00,82.54
+'AAAAAAAAABMAAAAA','TN',0,14,109.97,0.00,10.99
+'AAAAAAAAABMAAAAA','NULL',1,14,109.97,0.00,10.99
+---- TYPES
+STRING,STRING,TINYINT,DOUBLE,DECIMAL,DECIMAL,DECIMAL
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q28.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q28.test b/testdata/workloads/tpcds/queries/tpcds-q28.test
new file mode 100644
index 0000000..b19dad1
--- /dev/null
+++ b/testdata/workloads/tpcds/queries/tpcds-q28.test
@@ -0,0 +1,57 @@
+====
+---- QUERY: TPCDS-Q28
+select  *
+from (select avg(ss_list_price) B1_LP,
+             count(ss_list_price) B1_CNT,
+             count(distinct ss_list_price) B1_CNTD
+      from store_sales
+      where ss_quantity between 0 and 5
+        and (ss_list_price between 8 and 8+10
+             or ss_coupon_amt between 459 and 459+1000
+             or ss_wholesale_cost between 57 and 57+20)) B1,
+     (select avg(ss_list_price) B2_LP,
+             count(ss_list_price) B2_CNT,
+             count(distinct ss_list_price) B2_CNTD
+      from store_sales
+      where ss_quantity between 6 and 10
+        and (ss_list_price between 90 and 90+10
+          or ss_coupon_amt between 2323 and 2323+1000
+          or ss_wholesale_cost between 31 and 31+20)) B2,
+     (select avg(ss_list_price) B3_LP,
+             count(ss_list_price) B3_CNT,
+             count(distinct ss_list_price) B3_CNTD
+      from store_sales
+      where ss_quantity between 11 and 15
+        and (ss_list_price between 142 and 142+10
+          or ss_coupon_amt between 12214 and 12214+1000
+          or ss_wholesale_cost between 79 and 79+20)) B3,
+     (select avg(ss_list_price) B4_LP,
+             count(ss_list_price) B4_CNT,
+             count(distinct ss_list_price) B4_CNTD
+      from store_sales
+      where ss_quantity between 16 and 20
+        and (ss_list_price between 135 and 135+10
+          or ss_coupon_amt between 6071 and 6071+1000
+          or ss_wholesale_cost between 38 and 38+20)) B4,
+     (select avg(ss_list_price) B5_LP,
+             count(ss_list_price) B5_CNT,
+             count(distinct ss_list_price) B5_CNTD
+      from store_sales
+      where ss_quantity between 21 and 25
+        and (ss_list_price between 122 and 122+10
+          or ss_coupon_amt between 836 and 836+1000
+          or ss_wholesale_cost between 17 and 17+20)) B5,
+     (select avg(ss_list_price) B6_LP,
+             count(ss_list_price) B6_CNT,
+             count(distinct ss_list_price) B6_CNTD
+      from store_sales
+      where ss_quantity between 26 and 30
+        and (ss_list_price between 154 and 154+10
+          or ss_coupon_amt between 7326 and 7326+1000
+          or ss_wholesale_cost between 7 and 7+20)) B6
+limit 100;
+---- RESULTS
+77.71,36142,9210,69.50,35250,6592,134.01,27875,9741,82.55,31422,7678,61.82,36100,8664,39.27,29776,5210
+---- TYPES
+DECIMAL,BIGINT,BIGINT,DECIMAL,BIGINT,BIGINT,DECIMAL,BIGINT,BIGINT,DECIMAL,BIGINT,BIGINT,DECIMAL,BIGINT,BIGINT,DECIMAL,BIGINT,BIGINT
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q3.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q3.test b/testdata/workloads/tpcds/queries/tpcds-q3.test
index eac2838..44597a5 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q3.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q3.test
@@ -7,19 +7,13 @@ select
   sum(ss_ext_sales_price) sum_agg
 from
   date_dim dt,
-  store_sales,
+  store_sales ss,
   item
 where
-  dt.d_date_sk = store_sales.ss_sold_date_sk
-  and store_sales.ss_item_sk = item.i_item_sk
-  and item.i_manufact_id = 436
-  and dt.d_moy = 12
-  -- partition key filters
-  and (ss_sold_date_sk between 2451149 and 2451179
-    or ss_sold_date_sk between 2451514 and 2451544
-    or ss_sold_date_sk between 2451880 and 2451910
-    or ss_sold_date_sk between 2452245 and 2452275
-    or ss_sold_date_sk between 2452610 and 2452640)
+  dt.d_date_sk = ss.ss_sold_date_sk
+  and ss.ss_item_sk = item.i_item_sk
+  and item.i_manufact_id = 128
+  and dt.d_moy = 11
 group by
   dt.d_year,
   item.i_brand,
@@ -30,24 +24,95 @@ order by
   brand_id
 limit 100;
 ---- RESULTS
-1998,2001001,'amalgimporto #1',7812.38
-1998,10014017,'edu packamalgamalg #17',888.61
-1998,3003001,'exportiexporti #1',418.38
-1998,4003001,'exportiedu pack #1',70.55
-1998,5003001,'exportischolar #1',36.96
-1999,5004001,'edu packscholar #1',7903.35
-1999,10014017,'edu packamalgamalg #17',6715.25
-1999,3003001,'exportiexporti #1',6262.35
-1999,5003001,'exportischolar #1',652.35
-2000,1004001,'corpunivamalg #12',6812.52
-2000,4003002,'exportiedu pack #2',4726.08
-2000,10003008,'exportiunivamalg #8',2263.14
-2000,5003001,'exportischolar #1',641.85
-2000,5004001,'edu packscholar #1',341.88
-2001,6015004,'scholarbrand #4',5579.81
-2001,1004001,'corpunivamalg #12',5303.06
-2001,5003001,'maxiunivamalg #9',4469.75
-2002,5004001,'importocorp #8',1660.92
+1998,2001001,'amalgimporto #1',45162.45
+1998,5003001,'exportischolar #1',40600.56
+1998,5001001,'amalgscholar #1',32515.11
+1998,3004001,'edu packexporti #1',32443.16
+1998,3001001,'amalgexporti #1',30280.72
+1998,3001002,'amalgexporti #2',27644.68
+1998,1003001,'exportiamalg #1',25408.10
+1998,7007010,'brandbrand #10',23346.45
+1998,8001009,'amalgnameless #9',20792.57
+1998,10010002,'univamalgamalg #2',20398.90
+1998,7009008,'maxibrand #8',19199.75
+1998,6004008,'edu packcorp #8',18022.24
+1998,1004001,'edu packamalg #1',17434.09
+1998,10001002,'amalgunivamalg #2',15434.73
+1998,5004001,'edu packscholar #1',15184.40
+1998,7003009,'exportibrand #9',11669.32
+1998,1001002,'amalgamalg #2',10725.87
+1998,5003002,'exportischolar #2',10250.29
+1999,7003009,'exportibrand #9',60081.08
+1999,3004001,'edu packexporti #1',57285.04
+1999,2001001,'amalgimporto #1',46294.06
+1999,5004001,'edu packscholar #1',29587.74
+1999,1003001,'exportiamalg #1',28354.52
+1999,10001002,'amalgunivamalg #2',25166.82
+1999,5003001,'exportischolar #1',20350.80
+1999,1001002,'amalgamalg #2',18476.51
+1999,5003002,'exportischolar #2',17769.35
+1999,7009008,'maxibrand #8',16413.03
+1999,1004001,'edu packamalg #1',14950.65
+1999,6004008,'edu packcorp #8',14524.78
+1999,3001001,'amalgexporti #1',13895.01
+1999,5001001,'amalgscholar #1',11468.36
+1999,7007010,'brandbrand #10',10103.81
+1999,10010002,'univamalgamalg #2',7640.55
+1999,8001009,'amalgnameless #9',7324.50
+1999,3001002,'amalgexporti #2',2940.88
+2000,1003001,'exportiamalg #1',35841.00
+2000,2001001,'amalgimporto #1',32500.27
+2000,3001002,'amalgexporti #2',32059.56
+2000,3004001,'edu packexporti #1',29891.01
+2000,1001002,'amalgamalg #2',19888.62
+2000,10001002,'amalgunivamalg #2',19325.34
+2000,3001001,'amalgexporti #1',19261.58
+2000,10008017,'namelessunivamalg #17',17207.60
+2000,5003002,'exportischolar #2',16365.82
+2000,5003001,'amalgunivamalg #2',15140.30
+2000,1004001,'edu packamalg #1',15074.32
+2000,7009008,'maxibrand #8',15042.42
+2000,5004001,'edu packscholar #1',14744.21
+2000,6004008,'edu packcorp #8',13303.65
+2000,7007010,'brandbrand #10',12915.75
+2000,7003009,'exportibrand #9',11347.80
+2000,8001009,'importoexporti #2',10520.76
+2001,1001002,'amalgamalg #2',40840.34
+2001,1004001,'exportiexporti #2',27499.42
+2001,10008017,'namelessunivamalg #17',25766.09
+2001,4001001,'scholaramalgamalg #15',23917.98
+2001,7007010,'brandbrand #10',23807.16
+2001,1003001,'exportiamalg #2',21192.81
+2001,6004008,'edu packcorp #8',20966.17
+2001,5003002,'exportischolar #2',20410.45
+2001,8001009,'importoexporti #2',19273.11
+2001,3001002,'amalgexporti #2',18047.23
+2001,6005001,'edu packimporto #2',16801.34
+2001,2001001,'exportischolar #2',15894.57
+2001,5003001,'amalgunivamalg #2',15883.30
+2001,7011010,'amalgnameless #10',15174.18
+2001,5004001,'edu packunivamalg #8',10452.64
+2001,8004010,'edu packnameless #10',8565.95
+2001,3001001,'importoscholar #2',7765.96
+2001,7009008,'maxibrand #8',3570.11
+2002,1001002,'amalgamalg #2',57204.62
+2002,6004008,'edu packcorp #8',39584.99
+2002,8004010,'edu packnameless #10',30357.37
+2002,3001002,'amalgexporti #2',23025.23
+2002,3001001,'importoscholar #2',21157.23
+2002,1003001,'exportiamalg #2',20535.46
+2002,7007010,'brandbrand #10',19387.78
+2002,7009008,'maxibrand #8',17673.93
+2002,5004001,'edu packunivamalg #8',15175.94
+2002,4001001,'scholaramalgamalg #15',14984.83
+2002,6005001,'edu packimporto #2',14774.23
+2002,1004001,'exportiexporti #2',13016.75
+2002,7011010,'amalgnameless #10',12343.97
+2002,10008017,'amalgedu pack #1',10334.40
+2002,10013016,'exportiamalgamalg #16',8356.19
+2002,5003002,'exportischolar #2',5435.81
+2002,2001001,'exportischolar #2',4162.39
+2002,5001001,'amalgscholar #1',3537.49
 ---- TYPES
 INT, INT, STRING, DECIMAL
 ====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q34.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q34.test b/testdata/workloads/tpcds/queries/tpcds-q34.test
index 6a1e872..7572aed 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q34.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q34.test
@@ -24,12 +24,14 @@ from
     and (date_dim.d_dom between 1 and 3
       or date_dim.d_dom between 25 and 28)
     and (household_demographics.hd_buy_potential = '>10000'
-      or household_demographics.hd_buy_potential = 'unknown')
+      or household_demographics.hd_buy_potential = 'Unknown')
     and household_demographics.hd_vehicle_count > 0
-    and (case when household_demographics.hd_vehicle_count > 0 then household_demographics.hd_dep_count / household_demographics.hd_vehicle_count else null end) > 1.2
-    and date_dim.d_year in (1998, 1998 + 1, 1998 + 2)
-    and store.s_county in ('Saginaw County', 'Sumner County', 'Appanoose County', 'Daviess County', 'Fairfield County', 'Raleigh County', 'Ziebach County', 'Williamson County')
-    and ss_sold_date_sk between 2450816 and 2451910 -- partition key filter
+    and (case when household_demographics.hd_vehicle_count > 0
+         then (1.0 * household_demographics.hd_dep_count) / (1.0 * household_demographics.hd_vehicle_count)
+         else null end) > 1.2
+    and date_dim.d_year in (1999, 1999 + 1, 1999 + 2)
+    and store.s_county in ('Williamson County','Williamson County','Williamson County','Williamson County',
+                           'Williamson County','Williamson County','Williamson County','Williamson County')
   group by
     ss_ticket_number,
     ss_customer_sk
@@ -42,40 +44,461 @@ order by
   c_last_name,
   c_first_name,
   c_salutation,
-  c_preferred_cust_flag desc
-limit 100000;
+  c_preferred_cust_flag desc,
+  cnt,
+  ss_ticket_number;
 ---- RESULTS
-'','','','Y',16278,15
-'','','','N',220211,15
-'','Judy','Dr.','',234350,16
-'','Thomas','','',182717,15
+'Abbott','Harriet','Ms.','N',195008,15
+'Acosta','Victor','Mr.','N',156807,15
+'Adams','Jerry','Sir','N',216653,15
+'Adams','Willie','Sir','N',88285,15
+'Alford','Deborah','Miss','N',97678,15
+'Allen','Marty','Sir','N',63646,15
+'Anderson','Cindy','Miss','N',90504,15
+'Anderson','Eloise','Mrs.','Y',59994,16
+'Anderson','Marta','Dr.','N',176320,15
+'Anderson','Martha','Mrs.','N',74295,15
+'Anderson','Norma','Miss','Y',132983,16
+'Anderson','Rosemarie','Mrs.','N',178489,15
+'Andrews','Cindy','Miss','Y',132595,16
+'Andrews','Michael','Sir','N',135694,15
+'Andrews','Robert','Sir','Y',30467,15
+'Appleton','Gary','Dr.','N',58554,16
+'Archibald','Cindy','Miss','Y',87178,16
+'Arredondo','Phyllis','Ms.','Y',226220,16
+'Arsenault','Janet','Mrs.','N',169973,16
+'Ashton','Irma','Mrs.','Y',99233,15
+'Bailey','Lucille','Mrs.','N',2490,15
+'Baker','Erik','Sir','Y',69511,15
+'Barba','William','Sir','Y',102719,15
+'Barnes','John','Dr.','N',74071,15
+'Barnes','Michael','Mr.','N',168802,15
+'Bear','Tommy','Sir','Y',27468,15
+'Beasley','Joshua','Dr.','Y',32731,15
+'Bell','William','Mr.','Y',82227,15
+'Bender','Grover','Dr.','N',152239,15
+'Benedict','Bridget','Dr.','N',16544,15
+'Benson','Mike','Sir','Y',53219,16
+'Berry','Theresa','Ms.','Y',77257,15
+'Bilodeau','Norma','Ms.','Y',136244,15
+'Blake','John','Mr.','N',193896,15
+'Blanchard','Joanne','Dr.','N',5917,15
+'Boles','George','Sir','N',64282,15
+'Bolin','Yolanda','Dr.','N',13057,16
+'Bowden','Kathleen','Ms.','N',106265,15
+'Box','Eric','Dr.','N',79283,16
+'Boyd','Mildred','Miss','N',190083,15
+'Boyer','Betty','Mrs.','Y',171238,16
+'Boyle','Timothy','Dr.','N',21865,16
+'Brandt','James','Sir','Y',60562,15
+'Brantley','Frank','Dr.','N',66867,15
+'Brewer','Lynne','Ms.','N',77584,15
+'Broughton','Doretta','Ms.','Y',206939,16
+'Brower','Donald','Dr.','N',163579,15
+'Brown','David','Mr.','N',162755,16
+'Brown','Frederick','Mr.','N',120037,15
+'Brown','Janette','Dr.','Y',7269,16
+'Brown','Janice','Ms.','Y',138617,15
+'Brown','Raymond','Mr.','Y',212279,15
+'Brown','Roderick','Mr.','N',221290,16
+'Brown','Will','Mr.','Y',147392,15
+'Buck','Andrew','Dr.','N',128839,15
+'Burch','Diana','Mrs.','Y',115522,15
+'Burdette','Ronald','Mr.','Y',118097,15
+'Butcher','Francine','Mrs.','N',112093,15
+'Butcher','Thomas','Mr.','N',213918,15
+'Butler','Amos','Dr.','N',7184,15
 'Butler','Nicole','Dr.','N',214214,16
+'Byrd','Stephanie','Miss','Y',24803,15
+'Byrd','Wanda','Ms.','Y',155385,15
+'Campbell','Gordon','Mr.','N',196090,15
+'Campbell','William','Mr.','N',95665,15
+'Carlson','Gwendolyn','Dr.','Y',88472,15
+'Carpenter','Stephen','Mr.','Y',174519,16
+'Carroll','Frederick','Mr.','Y',56635,15
+'Carter','Cecil','Dr.','Y',34336,16
+'Carter','Eddie','Dr.','N',226103,16
+'Carter','Olga','Mrs.','N',84776,15
+'Casey','Darrell','Sir','N',181470,15
+'Castro','Sandra','Ms.','N',87567,15
+'Chandler','Lisa','Dr.','N',102461,16
 'Chang','Bradley','Sir','Y',53396,15
+'Chang','Erik','Sir','Y',140138,15
+'Chase','Daniel','Dr.','Y',129179,15
+'Cheek','Rebecca','Mrs.','Y',82193,15
+'Chen','Brett','Mr.','N',7880,15
+'Christenson','Steven','Mr.','Y',156157,15
+'Clark','Elisa','Mrs.','Y',234445,15
+'Clark','Elizabeth','Dr.','Y',58831,15
+'Clark','Meredith','Dr.','N',229216,16
+'Clark','Rosemary','Miss','Y',31542,15
+'Clayton','Michael','Mr.','N',69714,16
+'Clemente','Patrick','Sir','Y',179702,15
+'Clifford','Bessie','Dr.','N',61376,16
+'Clifford','John','Sir','Y',12960,15
 'Cochran','Dennis','Sir','Y',94375,15
+'Coker','John','Mr.','N',2730,15
+'Cole','Amanda','Dr.','Y',92994,15
+'Cole','Gretchen','Dr.','N',191039,15
+'Cole','June','Miss','N',206225,16
+'Cole','Melanie','Mrs.','Y',208547,15
+'Coleman','Nancy','Ms.','N',39446,16
+'Collier','NULL','Mr.','Y',179488,15
+'Collins','Patsy','Ms.','N',13775,15
+'Conner','Sondra','Miss','N',191684,15
+'Conrad','Jason','Mr.','N',166289,15
+'Cook','John','Mr.','N',237195,15
+'Cook','NULL','Sir','NULL',81755,15
 'Cope','Felicia','Dr.','Y',195003,15
+'Cordero','Dwight','Sir','Y',147038,15
+'Cota','Jorge','Mr.','N',3324,15
+'Crouch','Roberto','Dr.','Y',160826,15
+'Cruz','Donna','Ms.','N',180864,15
+'Cruz','Tamara','Ms.','N',112086,16
+'Dalton','Dorthea','Dr.','Y',37698,15
+'David','Timothy','Mr.','Y',20342,16
+'Davis','Donya','Miss','N',31118,15
+'Davis','Jess','Sir','Y',197947,15
+'Davis','Sandra','Ms.','N',141249,15
+'Davis','Vickie','Miss','Y',35264,15
+'Davison','Jeffrey','Mr.','Y',81413,16
+'Dejesus','Lorena','Dr.','NULL',157934,15
+'Delacruz','Brenton','Mr.','Y',96016,15
+'Delagarza','John','Mr.','N',62980,15
+'Diaz','Brian','Mr.','N',73210,15
+'Dietrich','Tammy','Dr.','N',114650,15
+'Dorsey','Lisa','Dr.','Y',5587,15
+'Dorsey','Melvin','Mr.','Y',231758,15
+'Dunn','Stephen','Sir','N',32455,15
+'Eason','Mario','Sir','N',174089,15
+'Easton','Christopher','Sir','Y',10691,15
+'Elliot','Mark','Mr.','Y',35782,16
+'Esquivel','Hee','Mrs.','Y',42741,15
+'Evans','April','Dr.','Y',41310,15
+'Faison','Roy','Sir','Y',147757,15
+'Farnsworth','Danny','Mr.','Y',29979,15
+'Ferrell','Roy','Mr.','N',139997,15
+'Ferris','William','Sir','Y',12536,15
+'Fields','Philomena','Dr.','N',217374,15
+'Fife','Terry','Dr.','N',81012,15
+'Finn','Margaret','Dr.','N',207070,15
+'Fitzgerald','Thomas','Mr.','Y',2698,15
+'Floyd','Lillian','Dr.','Y',84374,16
+'Flynn','Rhonda','Miss','N',96322,15
+'Forney','Christopher','Sir','N',175230,15
+'Franklin','Dorothy','Miss','Y',210152,15
+'Franklin','Eileen','Miss','Y',88556,15
+'Franklin','Judy','Ms.','Y',27813,15
+'Freeman','Rayford','Dr.','N',36115,15
+'Freeman','NULL','Mrs.','Y',175123,15
+'Fuqua','Harvey','Mr.','N',130609,16
+'Galindo','Karen','Dr.','N',100437,15
+'Galloway','Betty','Mrs.','Y',10097,15
+'Garcia','Kenny','Dr.','N',197122,16
+'Garrison','Robert','Sir','Y',40421,15
+'Garza','William','Sir','N',43273,15
+'German','Katie','Dr.','N',33536,16
+'Gibbons','Christopher','Sir','Y',237265,16
+'Gibbons','Vivian','Mrs.','Y',95173,16
+'Gibson','Agnes','Miss','N',228161,15
+'Gil','Yvette','Mrs.','Y',86699,15
+'Gill','Joshua','Sir','Y',230910,16
+'Glass','Jorge','Sir','N',137536,15
+'Gomez','Brandon','Sir','Y',160457,15
+'Gonzales','Cindy','Dr.','Y',96495,15
+'Gonzales','Edgar','Sir','N',153714,15
+'Gonzalez','Ruby','Mrs.','Y',228694,15
+'Gordon','Larry','Sir','Y',99782,15
+'Graham','Brian','Mr.','N',13629,15
+'Graham','Jerry','Sir','NULL',152656,15
+'Gray','Jeffery','Mr.','Y',154258,15
+'Grayson','Carolyn','Mrs.','N',69374,16
+'Grayson','Terry','Mr.','N',130480,16
+'Green','Cynthia','Mrs.','Y',141374,15
+'Green','Robert','Mr.','N',73965,15
+'Griffin','Martha','Dr.','N',82841,16
+'Grubbs','Florence','Mrs.','N',47930,15
+'Gulley','Daniel','Sir','Y',37484,16
+'Gutierrez','Ashley','Dr.','N',209948,16
+'Guzman','Mason','Mr.','Y',235019,16
+'Haley','Henry','Sir','Y',141619,15
+'Hall','Roger','Mr.','N',136216,15
+'Hamilton','Alex','Mrs.','N',23084,15
+'Hammonds','Richelle','Dr.','Y',135423,15
+'Hampton','NULL','NULL','N',11567,15
+'Hardy','Inez','Ms.','Y',104878,15
+'Harris','Charles','Dr.','Y',61618,15
+'Harris','Ezekiel','Sir','N',142043,15
 'Harrison','Jennifer','Ms.','Y',63097,15
+'Harrison','Michal','Mr.','Y',209687,15
+'Harrison','Qiana','Dr.','Y',10522,15
+'Hawkins','Clyde','Dr.','Y',236510,15
+'Hayes','Elizabeth','Mrs.','N',213826,15
+'Hayes','Johnnie','Sir','N',57732,15
+'Hayes','William','Sir','Y',223946,15
+'Haynes','Jennifer','Dr.','N',203136,15
+'Haywood','Judy','Mrs.','N',167146,15
+'Hernandez','Paul','Dr.','N',190691,15
 'Hernandez','Sandra','Dr.','Y',14252,16
+'Hewitt','Michelle','Dr.','N',155492,15
+'Hill','Barbara','Ms.','Y',88890,15
+'Hill','Julia','Dr.','N',191695,16
 'Horton','Michelle','Ms.','Y',112716,16
+'Howell','Katherine','Dr.','N',147571,16
+'Huffman','Beverly','Ms.','Y',166660,16
+'Hughes','Martin','Dr.','Y',178631,15
+'Ivey','John','Mr.','N',189224,15
+'Jackman','Ida','Dr.','Y',11753,15
+'Jackson','Kathy','Ms.','N',233945,15
+'Johnson','Lottie','Ms.','N',131031,15
+'Johnson','Olen','Mr.','N',12862,15
+'Johnson','Richard','Dr.','N',52256,15
+'Johnston','Walter','Mr.','Y',219689,15
+'Jones','Austin','Dr.','Y',57009,15
 'Jones','Eleanor','Ms.','N',27477,16
-'Lewis','Josephine','Ms.','N',37538,16
+'Jones','Jarvis','Sir','Y',74474,16
+'Jones','Rebecca','Dr.','Y',187035,16
+'Jones','Richard','Dr.','Y',232872,15
+'Joseph','Ramon','Mr.','N',7856,15
+'Joyce','NULL','Ms.','NULL',154184,16
+'Keaton','Lacey','Mrs.','N',133023,15
+'Keith','Bruce','Dr.','Y',24541,15
+'Kelly','Betty','Dr.','Y',151468,16
+'Kim','Bridget','Mrs.','Y',62861,15
+'King','Thomas','Sir','N',62796,15
+'Kinney','Angelica','Mrs.','N',192978,16
+'Kline','Donald','Mr.','Y',161957,15
+'Knight','Terence','Dr.','N',176372,16
+'Kraus','Roger','Dr.','Y',117604,16
+'Kruse','Jose','Dr.','N',114533,15
+'Lacy','Mina','Miss','N',227155,15
+'Ladner','Lisa','Dr.','Y',213223,15
+'Laird','Mark','Mr.','N',65882,15
+'Lavender','Robert','Sir','Y',3754,15
+'Lawson','Amanda','Ms.','Y',61212,16
+'Lawson','Kelly','Mr.','Y',64975,15
+'Le','Rodney','Dr.','Y',79356,16
+'Leigh','Abraham','Mr.','N',10283,15
+'Lewis','Annie','Ms.','Y',131418,15
+'Lewis','Bradley','Sir','N',182566,16
+'Lewis','Jerry','Mr.','Y',233447,15
+'Light','Robert','Mr.','Y',90021,15
 'Lin','Robert','Dr.','Y',236887,15
+'Lopez','Randee','Miss','N',9979,15
+'Lopez','Theresa','Miss','Y',169110,15
+'Lott','Ronald','Sir','N',79453,15
 'Love','Sean','Mr.','N',196652,15
-'Miller','Lena','Mrs.','N',163423,16
+'Lowe','Elmer','Sir','N',133003,16
+'Lozano','Charlotte','Mrs.','Y',31661,15
+'Macias','Roger','Sir','N',82746,15
+'Mansfield','Paul','Dr.','Y',5723,15
+'Manuel','Doris','Mrs.','Y',148847,15
+'Marks','Duane','Dr.','Y',34432,15
+'Marsh','Gary','Sir','Y',6580,15
+'Martin','Donald','Dr.','N',238840,16
+'Martin','Steve','Mr.','N',72094,16
+'Mason','Richard','Sir','Y',27500,16
+'Mast','Catalina','Miss','Y',178574,15
+'Matos','Josephine','Ms.','N',128283,16
+'Maxey','Sharon','Ms.','N',74649,16
+'Mccallister','Andrew','Ms.','Y',122178,15
+'Mccloud','Nicholas','Mr.','Y',28001,15
+'Mcconnell','Scott','Mr.','Y',78305,15
+'Mccormick','Joanne','Ms.','N',236985,15
+'Mcdaniel','Brian','Sir','N',217760,15
+'Mcdonald','Araceli','Ms.','Y',121343,15
+'Mcewen','Barbara','Mrs.','N',179491,15
+'Mckenzie','Ana','Ms.','N',201062,16
+'Mcnamara','Joann','Mrs.','Y',229870,15
+'Mcswain','Virgil','Mr.','N',71937,16
+'Melton','Monique','Ms.','Y',177605,15
+'Miller','Brian','Dr.','N',203465,16
+'Miller','Dennis','Dr.','N',137781,15
+'Miller','Edward','Sir','N',64767,16
+'Miller','Georgia','Ms.','N',40740,16
+'Miller','Karrie','Dr.','N',170750,15
+'Miller','Nancy','Mrs.','N',82671,16
+'Montgomery','Julie','Miss','N',17471,15
+'Moore','Barbara','Dr.','N',69608,15
+'Moore','Jeffrey','Sir','Y',155931,15
+'Moore','Lorena','Mrs.','Y',47752,15
+'Moore','Peggy','Miss','Y',191466,15
+'Morgan','Betty','Dr.','N',90306,15
+'Morgan','Latricia','Mrs.','N',216137,15
+'Morris','John','Dr.','Y',214378,15
+'Morris','Martina','Miss','N',32596,15
+'Morris','Meghan','Mrs.','Y',127565,15
+'Moses','Amy','Dr.','Y',182188,15
+'Moss','Michael','NULL','NULL',137243,15
+'Moultrie','Martin','Dr.','N',215102,15
+'Mulligan','Mark','Sir','Y',184598,16
+'Mullins','Vicki','Dr.','Y',162762,15
+'Murphy','Michael','Sir','Y',210567,15
 'Neeley','Stephanie','Mrs.','N',216299,15
-'Parker','Edward','Mr.','Y',16039,15
-'Pritchett','Marcie','Ms.','N',63897,15
-'Robbins','Elizabeth','Mrs.','N',83835,15
-'Robbins','Michael','Dr.','Y',42684,15
+'Nelson','Everette','Dr.','N',80821,15
+'Nesbitt','Andrew','Miss','N',185257,15
+'Norfleet','Ethel','Miss','N',14366,15
+'Olds','Stephen','Dr.','N',206275,16
+'Olson','David','Dr.','Y',87821,16
+'Oneill','Thomas','Mr.','N',188154,15
+'Oneill','Thomas','Mr.','N',93473,16
+'Osborn','Lena','Miss','Y',226949,16
+'Outlaw','Dennis','Sir','N',115215,16
+'Owens','Terry','Dr.','N',144931,15
+'Page','Elizabeth','Ms.','N',146879,15
+'Page','James','Dr.','Y',214208,16
+'Palacios','Amber','Dr.','Y',225723,15
+'Palmer','Debbie','Dr.','Y',121860,15
+'Park','Jerry','Dr.','N',73028,15
+'Peace','Carlos','Sir','N',203823,15
+'Perez','Harold','Mr.','Y',6311,15
+'Perez','Sheri','Ms.','N',157585,15
+'Perry','Sarah','Ms.','N',100885,15
+'Perry','Valeria','Mrs.','N',64861,15
+'Phelps','Marco','Dr.','Y',86494,16
+'Powell','Robert','Sir','Y',185862,15
+'Price','Florence','Ms.','Y',17220,15
+'Price','Gloria','Mrs.','Y',22568,15
+'Price','Marguerite','Mrs.','N',134265,16
+'Price','Marie','Ms.','N',88963,15
+'Price','Paul','Sir','N',103985,16
+'Price','Reginald','Sir','Y',123793,15
+'Price','NULL','Sir','N',55817,15
+'Pridgen','Hans','Dr.','N',207216,15
+'Ramirez','Lee','Sir','N',234584,15
+'Ramos','David','Dr.','Y',189463,16
+'Reece','Jimmy','Sir','N',166493,16
+'Reyes','Frank','NULL','NULL',84620,15
+'Reyna','Rod','Sir','N',46248,16
+'Reynolds','Oscar','Sir','Y',222749,15
+'Richardson','Alice','Ms.','N',43255,16
+'Riddle','John','Sir','Y',83916,15
+'Riddle','Marcelino','Dr.','N',60749,15
+'Rivera','Kate','Ms.','Y',204524,15
+'Robb','Laura','Miss','NULL',173667,15
+'Roberts','Candice','Dr.','Y',111855,16
+'Roberts','Dorothy','Ms.','N',183154,15
+'Roberts','Jennifer','Miss','Y',141296,15
+'Robinson','Gary','Mr.','Y',87081,15
+'Robinson','Sara','Mrs.','N',190406,15
+'Roldan','Dorothy','Mrs.','N',9370,15
+'Roman','Jimmie','Dr.','Y',221049,15
+'Ross','Rachael','Mrs.','N',106042,16
+'Ross','Robert','Mr.','Y',165295,15
+'Russ','Amber','Mrs.','N',225981,15
+'Russell','Larry','Dr.','Y',15209,16
+'Russell','Mark','Dr.','N',126453,15
+'Sacco','Brian','Sir','N',124398,16
+'Saddler','Robert','Mr.','Y',74571,15
+'Salinas','Kenneth','Dr.','Y',167446,15
 'Salter','Antonio','Miss','N',27497,16
+'Sanders','Dustin','Mr.','N',20319,15
+'Sandoval','Vincent','Mr.','N',140438,16
+'Sanford','Ronald','Sir','N',211947,15
+'Saunders','Mae','Miss','N',108927,15
+'Scott','Adam','Mrs.','N',13944,15
+'Scott','Ethel','Dr.','N',112707,15
+'Scott','Michael','Mr.','Y',104162,15
+'Self','Harry','Sir','Y',102208,16
+'Shaffer','Richard','Dr.','N',190775,16
+'Shuler','Joseph','Sir','N',57224,16
+'Sims','Fern','Dr.','Y',175233,15
+'Sims','John','Dr.','Y',113923,15
+'Smalls','Celeste','Ms.','Y',168837,15
+'Smith','Dalene','Ms.','Y',143125,16
+'Smith','Herbert','Dr.','Y',238646,15
+'Smith','John','Mr.','N',93525,16
+'Smith','Marion','Mr.','Y',65393,15
+'Smith','Ralph','Sir','N',87132,16
+'Smith','Terry','Dr.','Y',16945,15
+'Smith','Toni','Miss','N',50011,15
+'Smith','Wendell','Sir','N',85496,15
+'Soares','Sally','Ms.','Y',203554,16
+'Sparks','Michael','Mr.','Y',23696,15
+'Spears','Edith','Ms.','Y',223566,15
+'Spencer','Alfred','Mr.','Y',159308,15
+'Spencer','Teri','Mrs.','N',28551,16
+'Stafford','Jerry','Mr.','Y',230470,15
+'Stamper','Rebekah','Dr.','N',235329,15
+'Stephens','Donna','Ms.','N',151844,15
+'Stevens','Mattie','Ms.','N',202640,15
+'Stevens','Micheal','Dr.','Y',38659,16
+'Stewart','Amanda','Mrs.','Y',145235,15
+'Stewart','Gilbert','Mr.','Y',217862,15
+'Stewart','Kendra','Mrs.','Y',16423,15
+'Stewart','Pamela','Mrs.','Y',88160,16
+'Straub','Lowell','Dr.','Y',215956,16
+'Street','Lee','Mr.','N',171013,15
 'Sullivan','Amy','Dr.','N',166225,15
-'Thornton','William','Sir','Y',230436,16
+'Swain','Laura','Ms.','Y',36774,16
+'Swisher','Brian','Mr.','Y',53341,15
+'Taylor','Arlene','Dr.','Y',71934,15
+'Taylor','Jacqueline','Mrs.','Y',89977,16
+'Taylor','Karen','Dr.','N',29777,15
+'Taylor','Robert','Dr.','N',37700,15
+'Thomas','Barbara','Dr.','N',172596,15
+'Thomas','Christel','Dr.','Y',34579,15
+'Thomas','Jeffrey','Dr.','Y',115846,15
+'Thomas','Nichole','Miss','N',200721,16
+'Thomas','Rebecca','Mrs.','N',80953,15
+'Thompson','Brenda','Dr.','N',171735,15
+'Thompson','Melissa','Dr.','N',162831,15
+'Tidwell','Phyllis','NULL','NULL',234037,16
+'Tilley','Jane','Mrs.','Y',45378,15
+'Tinsley','Charlie','Dr.','N',23881,16
 'Tolbert','Emily','Miss','Y',40132,15
+'Tompkins','Charlotte','NULL','NULL',197857,15
+'Torres','Jason','Dr.','N',224,16
+'Torres','Roberta','Ms.','N',29436,15
+'Townsend','Michelle','Mrs.','N',39872,15
+'Turner','Kerry','Dr.','Y',23710,16
+'Turner','Marjorie','Mrs.','N',65289,15
 'Valenzuela','Bryan','Sir','Y',221858,16
-'Vargas','Wanda','Mrs.','Y',62471,15
+'Vance','Josefina','Mrs.','N',147148,15
+'Vargas','Charles','Dr.','Y',79536,15
+'Vogel','Leroy','Sir','Y',29032,15
+'Walker','Jim','Sir','N',46947,15
+'Walker','Jose','Sir','Y',189670,16
+'Walker','Richard','Sir','NULL',226475,15
+'Wall','Russell','Sir','N',17231,16
+'Wallace','Joseph','Sir','N',27193,15
+'Walsh','Javier','Sir','Y',211987,16
+'Warren','Brian','Dr.','N',15877,15
+'Watson','Tina','Ms.','Y',120030,16
+'Webb','Gloria','Ms.','N',65663,15
+'Welch','Pauline','Mrs.','Y',47529,15
+'West','Carman','Ms.','NULL',237594,15
+'West','Rachel','Dr.','Y',138384,15
 'Wetzel','Bebe','Dr.','N',82518,15
-'Whitfield','Sean','Sir','Y',61084,15
+'White','Diane','Dr.','Y',82960,16
+'White','Johnny','Dr.','N',204026,16
+'Whitehead','Magan','Dr.','N',192159,16
+'Wiggins','Kermit','Sir','N',112643,15
 'Wilbur','Terry','Sir','N',200312,15
-'Williams','Scott','','',136844,16
+'Williams','Archie','Mr.','N',113007,15
+'Williams','Karen','Ms.','Y',140802,15
+'Williams','Scott','NULL','NULL',136844,16
+'Willis','Amber','Ms.','N',53815,15
+'Willis','Michael','Sir','Y',207326,15
+'Wilson','Charles','Mr.','Y',60,15
+'Wood','Mark','Dr.','N',4376,15
+'Woody','Philip','Mr.','N',211173,16
+'Wright','Amanda','NULL','Y',105395,15
+'Yates','Kimberly','Ms.','Y',220849,15
+'NULL','Grace','NULL','NULL',147095,16
+'NULL','Joshua','Sir','N',108357,15
+'NULL','Judy','Dr.','NULL',234350,16
+'NULL','Roy','NULL','NULL',200033,15
+'NULL','NULL','Mr.','Y',214003,15
+'NULL','NULL','Ms.','NULL',54536,16
+'NULL','NULL','NULL','NULL',151297,15
+'NULL','NULL','NULL','NULL',148695,16
+'NULL','NULL','NULL','Y',16278,15
+'NULL','NULL','NULL','Y',146557,16
+'NULL','NULL','NULL','N',55640,15
+'NULL','NULL','NULL','N',58614,15
+'NULL','NULL','NULL','N',96514,15
+'NULL','NULL','NULL','N',220211,15
 ---- TYPES
-STRING, STRING, STRING, STRING, INT, BIGINT
+STRING, STRING, STRING, STRING, BIGINT, BIGINT
 ====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q4.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q4.test b/testdata/workloads/tpcds/queries/tpcds-q4.test
new file mode 100644
index 0000000..5cf56c3
--- /dev/null
+++ b/testdata/workloads/tpcds/queries/tpcds-q4.test
@@ -0,0 +1,126 @@
+====
+---- QUERY: TPCDS-Q4
+with year_total as (
+ select c_customer_id customer_id,
+        c_first_name customer_first_name,
+        c_last_name customer_last_name,
+        c_preferred_cust_flag customer_preferred_cust_flag,
+        c_birth_country customer_birth_country,
+        c_login customer_login,
+        c_email_address customer_email_address,
+        d_year dyear,
+        sum(((ss_ext_list_price-ss_ext_wholesale_cost-ss_ext_discount_amt)+ss_ext_sales_price)/2) year_total,
+        's' sale_type
+ from customer,
+      store_sales,
+      date_dim
+ where c_customer_sk = ss_customer_sk
+   and ss_sold_date_sk = d_date_sk
+ group by c_customer_id,
+          c_first_name,
+          c_last_name,
+          c_preferred_cust_flag,
+          c_birth_country,
+          c_login,
+          c_email_address,
+          d_year
+ union all
+ select c_customer_id customer_id,
+        c_first_name customer_first_name,
+        c_last_name customer_last_name,
+        c_preferred_cust_flag customer_preferred_cust_flag,
+        c_birth_country customer_birth_country,
+        c_login customer_login,
+        c_email_address customer_email_address,
+        d_year dyear,
+        sum((((cs_ext_list_price-cs_ext_wholesale_cost-cs_ext_discount_amt)+cs_ext_sales_price)/2) ) year_total,
+        'c' sale_type
+ from customer,
+      catalog_sales,
+      date_dim
+ where c_customer_sk = cs_bill_customer_sk
+   and cs_sold_date_sk = d_date_sk
+ group by c_customer_id,
+          c_first_name,
+          c_last_name,
+          c_preferred_cust_flag,
+          c_birth_country,
+          c_login,
+          c_email_address,
+          d_year
+union all
+ select c_customer_id customer_id,
+        c_first_name customer_first_name,
+        c_last_name customer_last_name,
+        c_preferred_cust_flag customer_preferred_cust_flag,
+        c_birth_country customer_birth_country,
+        c_login customer_login,
+        c_email_address customer_email_address,
+        d_year dyear,
+        sum((((ws_ext_list_price-ws_ext_wholesale_cost-ws_ext_discount_amt)+ws_ext_sales_price)/2) ) year_total,
+        'w' sale_type
+ from customer,
+      web_sales,
+      date_dim
+ where c_customer_sk = ws_bill_customer_sk
+   and ws_sold_date_sk = d_date_sk
+ group by c_customer_id,
+          c_first_name,
+          c_last_name,
+          c_preferred_cust_flag,
+          c_birth_country,
+          c_login,
+          c_email_address,
+          d_year
+         )
+  select t_s_secyear.customer_id,
+         t_s_secyear.customer_first_name,
+         t_s_secyear.customer_last_name,
+         t_s_secyear.customer_preferred_cust_flag
+ from year_total t_s_firstyear,
+      year_total t_s_secyear,
+      year_total t_c_firstyear,
+      year_total t_c_secyear,
+      year_total t_w_firstyear,
+      year_total t_w_secyear
+ where t_s_secyear.customer_id = t_s_firstyear.customer_id
+   and t_s_firstyear.customer_id = t_c_secyear.customer_id
+   and t_s_firstyear.customer_id = t_c_firstyear.customer_id
+   and t_s_firstyear.customer_id = t_w_firstyear.customer_id
+   and t_s_firstyear.customer_id = t_w_secyear.customer_id
+   and t_s_firstyear.sale_type = 's'
+   and t_c_firstyear.sale_type = 'c'
+   and t_w_firstyear.sale_type = 'w'
+   and t_s_secyear.sale_type = 's'
+   and t_c_secyear.sale_type = 'c'
+   and t_w_secyear.sale_type = 'w'
+   and t_s_firstyear.dyear =  2001
+   and t_s_secyear.dyear = 2001+1
+   and t_c_firstyear.dyear =  2001
+   and t_c_secyear.dyear =  2001+1
+   and t_w_firstyear.dyear = 2001
+   and t_w_secyear.dyear = 2001+1
+   and t_s_firstyear.year_total > 0
+   and t_c_firstyear.year_total > 0
+   and t_w_firstyear.year_total > 0
+   and case when t_c_firstyear.year_total > 0 then t_c_secyear.year_total / t_c_firstyear.year_total else null end
+           > case when t_s_firstyear.year_total > 0 then t_s_secyear.year_total / t_s_firstyear.year_total else null end
+   and case when t_c_firstyear.year_total > 0 then t_c_secyear.year_total / t_c_firstyear.year_total else null end
+           > case when t_w_firstyear.year_total > 0 then t_w_secyear.year_total / t_w_firstyear.year_total else null end
+ order by t_s_secyear.customer_id,
+          t_s_secyear.customer_first_name,
+          t_s_secyear.customer_last_name,
+          t_s_secyear.customer_email_address
+limit 100;
+---- RESULTS
+'AAAAAAAABIJBAAAA','James','White','N'
+'AAAAAAAADIIOAAAA','David','Carroll','Y'
+'AAAAAAAAIJCIBAAA','Thomas','Oneal','Y'
+'AAAAAAAAKJBLAAAA','Kerry','Davis','Y'
+'AAAAAAAAMFPFBAAA','Jamie','Woods','Y'
+'AAAAAAAANJAMAAAA','Thaddeus','Griffin','N'
+'AAAAAAAANJOLAAAA','Debra','Underwood','Y'
+'AAAAAAAAPEHEBAAA','Edith','Molina','Y'
+---- TYPES
+STRING,STRING,STRING,STRING
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q42.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q42.test b/testdata/workloads/tpcds/queries/tpcds-q42.test
index 2c01feb..f7e6b18 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q42.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q42.test
@@ -13,9 +13,8 @@ where
   dt.d_date_sk = store_sales.ss_sold_date_sk
   and store_sales.ss_item_sk = item.i_item_sk
   and item.i_manager_id = 1
-  and dt.d_moy = 12
-  and dt.d_year = 1998
-  and ss_sold_date_sk between 2451149 and 2451179  -- partition key filter
+  and dt.d_moy = 11
+  and dt.d_year = 2000
 group by
   dt.d_year,
   item.i_category_id,
@@ -27,16 +26,16 @@ order by
   item.i_category
 limit 100;
 ---- RESULTS
-1998,5,'Music',40451.03
-1998,2,'Men',39347.45
-1998,1,'Women',22578.54
-1998,10,'Electronics',19673.46
-1998,6,'Jewelry',19284.14
-1998,4,'Shoes',14433.73
-1998,7,'Home',11618.70
-1998,8,'Sports',10360.74
-1998,3,'Children',9357.81
-1998,9,'Books',7692.17
+2000,7,'Home',458017.85
+2000,3,'Children',370261.29
+2000,2,'Men',368718.95
+2000,1,'Women',320132.43
+2000,10,'Electronics',281421.74
+2000,5,'Music',223420.70
+2000,4,'Shoes',221242.25
+2000,8,'Sports',200806.45
+2000,6,'Jewelry',167920.91
+2000,9,'Books',161721.11
 ---- TYPES
 INT, INT, STRING, DECIMAL
 ====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q43.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q43.test b/testdata/workloads/tpcds/queries/tpcds-q43.test
index fedfae9..efe0f22 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q43.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q43.test
@@ -18,8 +18,7 @@ where
   d_date_sk = ss_sold_date_sk
   and s_store_sk = ss_store_sk
   and s_gmt_offset = -5
-  and d_year = 1998
-  and ss_sold_date_sk between 2450816 and 2451179  -- partition key filter
+  and d_year = 2000
 group by
   s_store_name,
   s_store_id
@@ -35,12 +34,12 @@ order by
   sat_sales
 limit 100;
 ---- RESULTS
-'able','AAAAAAAACAAAAAAA',49349.00,11964.64,65415.32,19680.45,33027.48,9612.44,14204.50
-'ation','AAAAAAAAHAAAAAAA',52459.95,8478.66,57051.69,30679.71,36850.72,11021.47,22339.61
-'bar','AAAAAAAAKAAAAAAA',46457.96,12677.26,57016.02,22659.39,33249.57,10005.28,19184.53
-'eing','AAAAAAAAIAAAAAAA',47770.56,7641.25,61742.84,14919.78,31392.67,10563.21,19786.37
-'ese','AAAAAAAAEAAAAAAA',52691.35,12586.01,60284.60,26242.38,31787.43,11306.84,13454.25
-'ought','AAAAAAAABAAAAAAA',48803.23,9293.29,64635.79,26335.10,37458.69,12052.65,16420.69
+'able','AAAAAAAACAAAAAAA',517884.59,469230.50,505832.67,443696.30,479716.97,462447.50,503064.60
+'ation','AAAAAAAAHAAAAAAA',508811.68,474290.02,448808.84,492870.99,498127.64,474355.89,505906.68
+'bar','AAAAAAAAKAAAAAAA',496021.80,459933.01,479825.96,474630.24,482326.79,478330.87,505252.22
+'eing','AAAAAAAAIAAAAAAA',498752.97,476119.01,485965.24,454921.28,491953.89,476014.69,484633.67
+'ese','AAAAAAAAEAAAAAAA',493724.01,499637.85,452314.62,466232.23,481922.38,477933.29,500577.95
+'ought','AAAAAAAABAAAAAAA',505735.34,471490.23,463248.39,482690.52,485818.98,481816.20,491354.68
 ---- TYPES
 STRING, STRING, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL
 ====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q46.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q46.test b/testdata/workloads/tpcds/queries/tpcds-q46.test
index c66f699..a0bb3d1 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q46.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q46.test
@@ -26,39 +26,11 @@ from
     and store_sales.ss_store_sk = store.s_store_sk
     and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
     and store_sales.ss_addr_sk = customer_address.ca_address_sk
-    and (household_demographics.hd_dep_count = 5
+    and (household_demographics.hd_dep_count = 4
       or household_demographics.hd_vehicle_count = 3)
     and date_dim.d_dow in (6, 0)
     and date_dim.d_year in (1999, 1999 + 1, 1999 + 2)
-    and store.s_city in ('Midway', 'Concord', 'Spring Hill', 'Brownsville', 'Greenville')
-    -- partition key filter
-    and ss_sold_date_sk in (2451181, 2451182, 2451188, 2451189, 2451195, 2451196, 2451202, 2451203, 2451209, 2451210, 2451216, 2451217, 
-                            2451223, 2451224, 2451230, 2451231, 2451237, 2451238, 2451244, 2451245, 2451251, 2451252, 2451258, 2451259, 
-                            2451265, 2451266, 2451272, 2451273, 2451279, 2451280, 2451286, 2451287, 2451293, 2451294, 2451300, 2451301, 
-                            2451307, 2451308, 2451314, 2451315, 2451321, 2451322, 2451328, 2451329, 2451335, 2451336, 2451342, 2451343, 
-                            2451349, 2451350, 2451356, 2451357, 2451363, 2451364, 2451370, 2451371, 2451377, 2451378, 2451384, 2451385, 
-                            2451391, 2451392, 2451398, 2451399, 2451405, 2451406, 2451412, 2451413, 2451419, 2451420, 2451426, 2451427, 
-                            2451433, 2451434, 2451440, 2451441, 2451447, 2451448, 2451454, 2451455, 2451461, 2451462, 2451468, 2451469, 
-                            2451475, 2451476, 2451482, 2451483, 2451489, 2451490, 2451496, 2451497, 2451503, 2451504, 2451510, 2451511, 
-                            2451517, 2451518, 2451524, 2451525, 2451531, 2451532, 2451538, 2451539, 2451545, 2451546, 2451552, 2451553, 
-                            2451559, 2451560, 2451566, 2451567, 2451573, 2451574, 2451580, 2451581, 2451587, 2451588, 2451594, 2451595, 
-                            2451601, 2451602, 2451608, 2451609, 2451615, 2451616, 2451622, 2451623, 2451629, 2451630, 2451636, 2451637, 
-                            2451643, 2451644, 2451650, 2451651, 2451657, 2451658, 2451664, 2451665, 2451671, 2451672, 2451678, 2451679, 
-                            2451685, 2451686, 2451692, 2451693, 2451699, 2451700, 2451706, 2451707, 2451713, 2451714, 2451720, 2451721, 
-                            2451727, 2451728, 2451734, 2451735, 2451741, 2451742, 2451748, 2451749, 2451755, 2451756, 2451762, 2451763, 
-                            2451769, 2451770, 2451776, 2451777, 2451783, 2451784, 2451790, 2451791, 2451797, 2451798, 2451804, 2451805, 
-                            2451811, 2451812, 2451818, 2451819, 2451825, 2451826, 2451832, 2451833, 2451839, 2451840, 2451846, 2451847, 
-                            2451853, 2451854, 2451860, 2451861, 2451867, 2451868, 2451874, 2451875, 2451881, 2451882, 2451888, 2451889, 
-                            2451895, 2451896, 2451902, 2451903, 2451909, 2451910, 2451916, 2451917, 2451923, 2451924, 2451930, 2451931, 
-                            2451937, 2451938, 2451944, 2451945, 2451951, 2451952, 2451958, 2451959, 2451965, 2451966, 2451972, 2451973, 
-                            2451979, 2451980, 2451986, 2451987, 2451993, 2451994, 2452000, 2452001, 2452007, 2452008, 2452014, 2452015, 
-                            2452021, 2452022, 2452028, 2452029, 2452035, 2452036, 2452042, 2452043, 2452049, 2452050, 2452056, 2452057, 
-                            2452063, 2452064, 2452070, 2452071, 2452077, 2452078, 2452084, 2452085, 2452091, 2452092, 2452098, 2452099, 
-                            2452105, 2452106, 2452112, 2452113, 2452119, 2452120, 2452126, 2452127, 2452133, 2452134, 2452140, 2452141, 
-                            2452147, 2452148, 2452154, 2452155, 2452161, 2452162, 2452168, 2452169, 2452175, 2452176, 2452182, 2452183, 
-                            2452189, 2452190, 2452196, 2452197, 2452203, 2452204, 2452210, 2452211, 2452217, 2452218, 2452224, 2452225, 
-                            2452231, 2452232, 2452238, 2452239, 2452245, 2452246, 2452252, 2452253, 2452259, 2452260, 2452266, 2452267, 
-                            2452273, 2452274)
+    and store.s_city in ('Fairview','Midway','Fairview','Fairview','Fairview')
   group by
     ss_ticket_number,
     ss_customer_sk,
@@ -79,106 +51,106 @@ order by
   ss_ticket_number
 limit 100;
 ---- RESULTS
-'','','','Bunker Hill',133136,4983.83,-11549.37
-'','','','Woodville',50899,8655.31,-10609.16
-'','','Centerville','Providence',62604,156.21,-13626.64
-'','','Clifton','White Oak',59712,2292.43,-16908.54
-'','','Crossroads','Unionville',58203,1393.55,-11986.88
-'','','Louisville','Lakeside',139327,3800.99,-10089.61
-'','','Oakwood','Woodville',111282,359.16,-15852.70
-'','','Pleasant Hill','Waterloo',156554,277.78,-3118.59
-'','','Pleasant Valley','Bunker Hill',18775,2344.98,-1692.61
-'','','Shiloh','Oakland',46266,1622.69,-10676.15
-'','','Shore Acres','Cedar Grove',115319,6113.17,-11527.49
-'','','Summit','Stringtown',11040,16067.32,-24193.00
-'','Andrew','Oak Ridge','Enterprise',5925,5897.86,-24034.31
-'','Ashley','Cedar Grove','Unionville',232883,3522.87,-15805.10
-'','Gary','Murray','Crystal',2581,564.43,-467.73
-'','George','Pleasant Grove','Shiloh',179953,3442.20,-15026.03
-'','Justin','Green Acres','Friendship',218888,36.82,-9620.22
-'','Kathleen','Little River','Woodlawn',189811,0.00,-10443.74
-'','Lakeesha','Clifton','Enterprise',218396,1423.91,-8880.27
-'','Ray','Five Forks','Woodbury',164665,1800.44,-5946.03
-'','Tabatha','Harmony','Greenfield',56102,3221.04,-11594.38
-'','Tyler','Pinecrest','Walnut Grove',122234,6583.23,-22140.99
-'Adams','Jacqueline','Gum Springs','Springdale',110641,4071.61,-23419.08
-'Aiello','Beth','Red Hill','Oak Ridge',116426,975.79,-8948.15
+'Aaron','Charles','Jamestown','Red Hill',183217,2067.37,-8054.03
+'Aaron','Genevieve','Lakeside','Springtown',185247,1739.84,-1337.44
+'Aaron','Guy','Lakeside','Mount Pleasant',210815,1849.59,-11333.00
+'Abbott','Frederick','Green Acres','Oakland',7247,518.63,-13290.67
+'Abbott','Harriet','Wesley','Forest Hills',84405,800.12,-8540.46
+'Abel','Flora','Perry','Newtown',117310,8532.29,-28474.67
+'Abney','Louis','Gladstone','Green Acres',140967,7.52,-13382.19
+'Abrams','Amy','Salem','Pine Grove',231298,1132.44,-19986.97
+'Abrams','Dorothy','Lincoln','New Hope',99435,2640.46,-12712.81
+'Abreu','David','Brownsville','Mount Pleasant',189640,4026.11,-7711.87
+'Abreu','David','Brownsville','White Oak',55423,2943.20,-5695.81
+'Ackerman','NULL','Hopewell','Pleasant Grove',94468,5981.77,-11788.36
+'Ackley','Christopher','Bethel','Newport',95923,2996.52,-7797.50
+'Acosta','Bobby','Riverdale','Friendship',197899,60.50,-27188.42
+'Acosta','Eric','Fairfield','Shiloh',11072,9.85,-4142.15
+'Acosta','Johnnie','Centerville','Enterprise',69183,1581.96,-3015.22
+'Acosta','Wilfred','Jackson','Macedonia',190054,316.43,-913.72
+'Adair','Silvia','Bayview','Plainview',170324,4208.47,-9295.96
+'Adams','Alicia','Concord','Mount Zion',22029,3132.36,-12262.13
+'Adams','Carlena','Five Forks','Mount Olive',200385,220.23,-7642.46
+'Adams','Christopher','Highland Park','New Hope',89344,66.03,-8711.35
+'Adams','Christopher','Highland Park','Owens',150027,755.51,-5103.79
+'Adams','David','Bridgeport','Antioch',213366,9174.05,-14025.32
+'Adams','David','Bridgeport','Price',233836,1568.08,-20484.95
+'Adams','Earl','Mount Zion','Greenfield',99055,551.98,-6440.04
+'Adams','Henry','Saint James','Georgetown',231785,901.24,-18286.29
+'Adams','Hortencia','Wildwood','Friendship',69694,296.89,-11931.45
+'Adams','Isidro','Glenwood','Oak Grove',148351,923.30,-3177.00
+'Adams','Jane','Shiloh','Red Hill',106214,1434.41,-7320.39
+'Adams','Jay','Sulphur Springs','Bridgeport',195437,141.95,-6997.43
+'Adams','Jim','Pleasant Valley','Edgewater',136554,4677.64,-8308.27
+'Adams','Kimberly','Caledonia','Five Forks',105902,2112.44,-305.98
+'Adams','Magdalena','Glendale','Edgewood',70321,163.95,-3472.48
+'Adams','Patrick','Bridgeport','Edgewood',232741,523.33,-5830.63
+'Adams','Pedro','Pleasant Valley','Enterprise',139637,2968.84,-5251.73
+'Adams','Steven','Greenville','Hillcrest',13710,7235.33,-2345.79
+'Adams','Tim','Mount Zion','Deerfield',188255,1942.53,-11899.84
+'Adams','Tim','Mount Zion','Oak Grove',97273,3299.36,-16893.16
+'Adams','Tonya','Enterprise','Oak Hill',143974,1025.42,-9619.17
+'Adkins','Alica','Oakwood','Woodrow',131755,4255.95,-18319.64
+'Adkins','Debra','Bloomingdale','Wayland',231738,4340.02,-15037.93
+'Adkins','Debra','Helena','Deerfield',97428,1757.72,-4654.11
+'Adkins','Judith','Plainview','Riverview',61339,5414.10,-15150.39
+'Adkins','Melanie','Liberty','Riverside',41578,3471.30,-15110.65
+'Adkins','Michael','Five Forks','Mount Pleasant',158714,3565.11,-14888.46
+'Adkins','Virginia','Highland','Woodlawn',192086,0.00,-5100.88
+'Aguilar','Arlene','Ashland','Belmont',132623,5624.93,-6045.24
+'Aguilar','Douglas','Pine Grove','Brunswick',77899,166.17,-5251.06
+'Aguilar','Karen','Pleasant Hill','Buena Vista',47133,1868.27,-6121.78
+'Aguilar','Kimberly','Pleasant Hill','Jackson',192256,1.19,-7640.59
+'Aguilar','Lynda','Greenwood','Pleasant Valley',51477,978.54,-11859.19
+'Aguilar','Lynda','Greenwood','Woodrow',89360,803.59,-5283.17
+'Aguilar','Milton','Mount Zion','Friendship',162299,5305.56,-7522.86
+'Aguilar','Robert','Walnut Grove','Antioch',169539,2584.34,-5225.46
+'Aguilar','Tracy','Highland Park','Kingston',206717,2995.45,-3976.20
+'Aguilera','Michelle','Tipton','Shiloh',228010,3815.66,-11820.05
+'Ahmed','Maureen','Oak Hill','Union Hill',128051,7270.41,-13433.60
+'Aiken','James','Mount Olive','Crossroads',212463,0.00,-3126.87
+'Akin','Sharon','Harmony','Edgewood',201392,2962.97,-14053.85
+'Alaniz','Elia','Marion','Mount Zion',79719,3691.54,-10297.32
+'Albert','Donald','Red Hill','Macedonia',83899,2140.15,-9622.92
+'Albert','Jesse','Bunker Hill','Stringtown',139171,19429.35,-18276.98
+'Albert','Joseph','Richfield','Brownsville',63910,5982.83,-9276.46
+'Albert','Robert','Greenville','Royal',52927,0.00,-1929.68
+'Albertson','Sarah','Pleasant Valley','White Oak',82675,2311.79,-11496.78
+'Albright','Michelle','Hillcrest','Woodland',49024,6451.20,-12414.60
+'Albright','Vincent','Wildwood','Oakdale',7278,4425.56,-25696.83
+'Alcala','Nancy','Fairfield','Arlington',181927,711.70,-14419.56
+'Aldrich','Stephen','Shady Grove','Post Oak',194020,4141.47,-15841.39
+'Aldrich','Willard','Woodville','Arthur',11159,9577.24,1816.47
+'Aldrich','NULL','Salem','Woodville',107876,638.97,-6506.27
+'Aleman','Eddie','White Oak','Concord',25327,9293.14,-21425.24
+'Alexander','Beverly','Valley View','Five Forks',212635,0.00,-5122.61
+'Alexander','Donna','Liberty','Hamilton',218554,517.32,-10027.79
+'Alexander','Graham','Fairfield','Newtown',104061,1574.22,-4375.65
+'Alexander','Joseph','Winchester','Sutton',211390,6542.30,-20325.16
+'Alexander','Nancy','Riverside','Union Hill',184734,7944.54,-12244.04
+'Alexander','Paul','Springdale','Hopewell',190468,143.92,-9226.83
+'Alfonso','Mabel','Clifton','Red Hill',54976,2422.52,3133.04
+'Ali','Jennifer','Lake Forest','Liberty',40263,3467.53,-18495.55
+'Ali','Stephen','Lone Pine','Glenwood',175860,167.14,-12116.78
+'Allen','Andrea','Lakeside','Newport',11334,6.64,-2610.30
+'Allen','Curtis','Brentwood','Richardson',216964,0.00,-19124.72
+'Allen','Dana','Crossroads','Bunker Hill',112648,2164.34,-11973.83
+'Allen','Donita','Riverdale','Sunnyside',182017,711.62,-3681.42
 'Allen','Earl','Marion','Lincoln',64277,11935.26,-12108.31
-'Allen','Eric','Star','West Liberty',144009,878.68,135.47
-'Alves','Sam','Mount Olive','Union Hill',129660,38.36,-12463.53
-'Anderson','John','Pleasant Hill','Salem',96731,1631.83,-11010.09
-'Anderson','William','Macedonia','Wilson',97877,387.57,-12078.04
-'Andrews','Everett','Macedonia','Shiloh',96502,1004.97,-3638.15
-'Ashmore','Karen','Cedar Grove','Sulphur Springs',35216,4129.51,-13824.93
-'Augustine','Sylvia','','Ferguson',239026,112.07,-11058.47
-'Austin','Georgia','Woodville','Jamestown',157167,3108.93,-1302.69
-'Ayala','Ann','Oakland','Frankfort',28361,0.00,-5902.62
-'Baker','Richard','Five Forks','Greenfield',110320,264.71,-5730.45
-'Baldridge','Victor','Siloam','Mount Pleasant',46121,5460.48,-21175.89
-'Ball','Evelyn','Spring Valley','Five Points',205355,273.94,-15671.16
-'Banks','Tiffany','Greenfield','Tanglewood',163607,0.00,-3432.89
-'Barnett','Stacie','Wilson','Greenfield',90549,1991.13,-13073.98
-'Barth','Nicole','Cedar','Oak Ridge',175769,268.78,-2179.10
-'Bass','Rosalie','Fairview','Springdale',88499,572.81,-528.38
-'Beard','Brian','Edgewood','White Oak',152373,2468.60,-11237.00
-'Bishop','Daisy','Lakeside','Sulphur Springs',131728,775.04,-13097.37
-'Bivins','Tracy','Union Hill','Bethel',218867,548.08,-7750.72
-'Booker','Corrine','Crossroads','Midway',169619,3286.17,-6067.53
-'Boudreau','Joseph','Red Oak','Friendship',174139,2343.11,-10164.83
-'Bowen','Ann','Spring Hill','Brownsville',43025,1410.63,-2604.28
-'Boyd','Greg','Arlington','Woodville',59295,2127.88,-8753.13
-'Boyer','Abby','Mount Pleasant','Stewart',129199,139.70,-3980.35
-'Bradley','Thomas','Greenfield','Lebanon',63539,8.91,-7548.69
-'Bradshaw','Rhonda','Union Hill','Forest Hills',175675,41.92,-12661.23
-'Braun','Sarah','Harmony','Highland Park',104345,4240.45,-6383.02
-'Brice','Jose','Oak Ridge','Five Points',117335,305.96,-11637.44
-'Briggs','Nathan','Wilson','Bloomingdale',52858,90.42,-5227.26
-'Brock','Allen','Liberty','Woodlawn',230289,133.36,-6088.19
-'Brooks','David','Hamilton','Brownsville',185597,699.59,-7221.99
-'Brown','Alfred','','Oak Hill',57190,1560.07,-16052.32
-'Brown','Cheryl','Jackson','Pleasant Hill',72269,794.26,-8431.77
-'Brown','Eddie','Harmony','Walnut Grove',174318,65.44,-12890.27
-'Brown','Martin','Mount Zion','Unionville',134030,0.00,-3140.24
-'Brown','Ronald','Cedar Grove','Deerfield',149812,45.75,-10436.23
-'Brown','Scott','Brownsville','Florence',152236,602.32,-2929.77
-'Brubaker','Russell','Rosewood','Five Points',24470,10045.43,-8561.03
-'Buck','Traci','Lakeview','Mechanicsburg',136261,608.57,-13695.30
-'Buckley','Linda','Riverside','Forest Hills',172509,1448.70,-11444.86
-'Bullard','Jason','Deerfield','Littleton',205526,9773.59,-13889.96
-'Bunn','Linda','Edgewood','Stringtown',92027,82.41,-4946.79
-'Burdick','Lewis','Lynn','Greenville',16444,2099.08,-3870.46
-'Burkhart','Hanna','Plainview','Shiloh',165655,1215.93,-14760.98
-'Bush','Samuel','New Hope','Mount Pleasant',142279,128.62,-4167.68
-'Butler','Eugene','Liberty','Crossroads',97955,25.74,-10790.20
-'Byrd','Elizabeth','Sleepy Hollow','Fairfield',224342,4824.27,-5421.49
-'Callahan','Delois','Brownsville','Providence',69902,1198.79,-5720.72
-'Campbell','Diane','Waterloo','Mount Olive',99261,0.00,-8538.40
-'Campbell','Ellen','Macedonia','Kingston',32082,0.00,-1155.34
-'Cardenas','Kevin','Fairfield','Pleasant Valley',10046,931.24,1126.28
-'Carmack','Francesca','Clinton','Oakwood',27967,8528.86,-22214.55
-'Carpenter','Douglas','Greenfield','Wilson',171407,1011.15,-1596.83
-'Carroll','Leon','Walnut Grove','Oak Ridge',211854,1721.50,-10222.65
-'Carter','Bonnie','Riverdale','Maple Grove',134966,4343.63,-17216.80
-'Carter','Johnny','Fairview','Union Hill',54872,2645.96,-18847.25
-'Carter','Leticia','Hamilton','Union Hill',189327,2149.88,-11896.18
-'Cary','Gary','Fairfield','Glenwood',30050,625.67,-1904.88
-'Castillo','Joseph','Mount Pleasant','Shady Grove',157459,918.21,-10050.74
-'Castillo','Kirk','Lakeview','Antioch',230673,908.38,-3299.94
-'Castillo','Steven','Midway','Mount Vernon',227163,2489.24,-11455.15
-'Chadwick','Serena','Mount Vernon','Newport',28003,3242.87,-9634.14
-'Chambers','Rosalia','Newtown','Bunker Hill',122828,3806.49,-10758.68
-'Chavez','','Sulphur Springs','Summit',149341,72.69,3105.11
-'Chavez','Christina','Stratford','Oak Ridge',113094,1342.44,-8445.37
-'Chester','Harriet','Unionville','Forest',104340,1290.81,-8642.99
-'Chin','Amado','Mount Zion','Glenwood',143471,3710.70,-10935.83
-'Christie','Ronald','Bridgeport','Woodville',168645,325.14,-6519.76
-'Clayton','Darrin','Brownsville','Midway',97011,9864.25,-10560.99
-'Clements','Stella','Bethel','Forest Hills',62395,1544.16,-3.32
-'Cloud','Jimmy','Spring Valley','Stringtown',180022,1700.78,-12476.49
-'Collins','Adolfo','Buena Vista','Fairview',96557,1457.91,-25595.81
-'Colvin','Angela','Fairview','Farmington',226567,842.08,-19485.16
-'Conklin','Florence','Riverside','Oakdale',160951,7125.31,-21542.41
-'Conn','Nicole','The Meadows','Harmony',146652,2200.25,-9231.72
+'Allen','Edward','Brownsville','Bunker Hill',155950,3267.59,-7671.84
+'Allen','Edward','Brownsville','Lakewood',162070,1359.35,-15806.88
+'Allen','Emily','Macedonia','Springdale',186035,1860.88,-10258.69
+'Allen','Jeanne','Waterloo','Summit',181784,448.50,-10244.62
+'Allen','Jennifer','Green Acres','Five Points',194912,536.52,-18001.88
+'Allen','John','Sulphur Springs','Five Forks',97314,463.68,-14328.20
+'Allen','Leslie','Five Forks','Ashland',77055,87.92,-9644.24
+'Allen','Mark','Lakeside','Riverside',191934,203.13,-19803.96
+'Allen','Marty','Greenwood','Riverview',1040,308.20,-1547.30
+'Allen','Matthew','Mount Pleasant','Mountain View',190723,2.77,-2219.34
+'Allen','Natalie','Oak Grove','Woodville',82315,2230.76,-14635.09
+'Allen','Robert','Oakdale','White Oak',92331,331.56,1122.69
+'Allen','Roger','Jamestown','Springdale',84977,407.65,-2525.30
+'Allen','Ronald','Wright','Pleasant Valley',8104,24.26,-1996.98
 ---- TYPES
-STRING, STRING, STRING, STRING, INT, DECIMAL, DECIMAL
+STRING, STRING, STRING, STRING, BIGINT, DECIMAL, DECIMAL
 ====
\ No newline at end of file


Mime
View raw message