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
