http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/functional-query/queries/QueryTest/analytic-fns-tpcds.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/analytic-fns-tpcds.test b/testdata/workloads/functional-query/queries/QueryTest/analytic-fns-tpcds.test index 1d2328f..9d98dec 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/analytic-fns-tpcds.test +++ b/testdata/workloads/functional-query/queries/QueryTest/analytic-fns-tpcds.test @@ -10,16 +10,16 @@ order by i_item_sk limit 10 ---- RESULTS -462,5.94,4489.26 -780,NULL,7182.69 -1146,NULL,11135.77 -1329,0.63,12916.92 -2029,NULL,19805.63 -2723,0.46,26728.77 -2999,NULL,29348.44 -3016,NULL,29496.80 -4099,NULL,40021.33 -5030,NULL,48186.57 +2,1.12,28.14 +24,2.61,213.93 +36,91.42,501.66 +54,37.84,730.17 +110,1.31,1167.33 +168,6.73,1719.08 +190,0.56,1859.34 +200,3.46,1911.81 +372,8.87,3602.84 +404,2.52,3873.45 ---- TYPES BIGINT, DECIMAL, DECIMAL ==== @@ -34,16 +34,16 @@ order by i_item_sk limit 10 ---- RESULTS -462,'',5.94,5.94 -780,'',NULL,5.94 -1146,'',NULL,5.94 -1329,'',0.63,6.57 -2029,'',NULL,6.57 -2723,'',0.46,7.03 -2999,'',NULL,7.03 -3016,'',NULL,7.03 -4099,'',NULL,7.03 -5030,'',NULL,7.03 +2,'amalgamalg #1',1.12,1.12 +24,'amalgamalg #1',2.61,3.73 +36,'amalgamalg #1',91.42,95.15 +54,'amalgamalg #1',37.84,132.99 +110,'amalgamalg #1',1.31,134.30 +168,'amalgamalg #1',6.73,141.03 +190,'amalgamalg #1',0.56,141.59 +200,'amalgamalg #1',3.46,145.05 +372,'amalgamalg #1',8.87,153.92 +404,'amalgamalg #1',2.52,156.44 ---- TYPES BIGINT, STRING, DECIMAL, DECIMAL ==== @@ -58,16 +58,16 @@ order by i_item_sk limit 10 ---- RESULTS -462,'',5.94,22.57 -780,'',NULL,127.10 -1146,'',NULL,127.10 -1329,'',0.63,1.45 -2029,'',NULL,127.10 -2723,'',0.46,0.82 -2999,'',NULL,127.10 -3016,'',NULL,127.10 -4099,'',NULL,127.10 -5030,'',NULL,127.10 +2,'amalgamalg #1',1.12,17.76 +24,'amalgamalg #1',2.61,111.23 +36,'amalgamalg #1',91.42,1967.39 +54,'amalgamalg #1',37.84,1091.13 +110,'amalgamalg #1',1.31,29.10 +168,'amalgamalg #1',6.73,497.90 +190,'amalgamalg #1',0.56,5.73 +200,'amalgamalg #1',3.46,150.20 +372,'amalgamalg #1',8.87,726.45 +404,'amalgamalg #1',2.52,103.45 ---- TYPES BIGINT, STRING, DECIMAL, DECIMAL ==== @@ -116,16 +116,16 @@ order by i_item_sk limit 10 ---- RESULTS -462,'',5.94,NULL,22.57,5.94 -780,'',NULL,NULL,127.10,5.94 -1146,'',NULL,510,127.10,3.11 -1329,'',0.63,139,1.45,1.07 -2029,'',NULL,169,127.10,7.56 -2723,'',0.46,NULL,0.82,5.94 -2999,'',NULL,NULL,127.10,5.94 -3016,'',NULL,272,127.10,4.85 -4099,'',NULL,273,127.10,24.17 -5030,'',NULL,289,127.10,28.80 +2,'amalgamalg #1',1.12,294,17.76,1.12 +24,'amalgamalg #1',2.61,260,111.23,3.73 +36,'amalgamalg #1',91.42,553,1967.39,91.42 +54,'amalgamalg #1',37.84,865,1091.13,37.84 +110,'amalgamalg #1',1.31,253,29.10,1.31 +168,'amalgamalg #1',6.73,310,497.90,8.19 +190,'amalgamalg #1',0.56,46,5.73,3.84 +200,'amalgamalg #1',3.46,40,150.20,3.46 +372,'amalgamalg #1',8.87,652,726.45,8.87 +404,'amalgamalg #1',2.52,260,103.45,3.73 ---- TYPES BIGINT, STRING, DECIMAL, INT, DECIMAL, DECIMAL ==== @@ -144,16 +144,16 @@ order by i_item_sk limit 10 ---- RESULTS -462,'',5.94,11.88 -462,'',5.94,11.88 -780,'',NULL,11.88 -780,'',NULL,11.88 -1146,'',NULL,11.88 -1146,'',NULL,11.88 -1329,'',0.63,13.14 -1329,'',0.63,13.14 -2029,'',NULL,13.14 -2029,'',NULL,13.14 +2,'amalgamalg #1',1.12,2.24 +2,'amalgamalg #1',1.12,2.24 +24,'amalgamalg #1',2.61,7.46 +24,'amalgamalg #1',2.61,7.46 +36,'amalgamalg #1',91.42,190.30 +36,'amalgamalg #1',91.42,190.30 +54,'amalgamalg #1',37.84,265.98 +54,'amalgamalg #1',37.84,265.98 +110,'amalgamalg #1',1.31,268.60 +110,'amalgamalg #1',1.31,268.60 ---- TYPES BIGINT, STRING, DECIMAL, DECIMAL ====
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/functional-query/queries/QueryTest/seq-writer.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/seq-writer.test b/testdata/workloads/functional-query/queries/QueryTest/seq-writer.test index 528b83e..753eb0f 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/seq-writer.test +++ b/testdata/workloads/functional-query/queries/QueryTest/seq-writer.test @@ -98,12 +98,13 @@ create table store_sales_seq_none_rec like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_none_rec partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_none_rec; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -117,12 +118,13 @@ create table store_sales_seq_def_rec like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_def_rec partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_def_rec; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -136,12 +138,13 @@ create table store_sales_seq_snapb_rec like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_snapb_rec partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_snapb_rec; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -155,12 +158,13 @@ create table store_sales_seq_snap_rec like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_snap_rec partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_snap_rec; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -174,12 +178,13 @@ create table store_sales_seq_gzip_rec like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_gzip_rec partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_gzip_rec; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -193,12 +198,13 @@ create table store_sales_seq_none_block like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_none_block partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_none_block; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -212,12 +218,13 @@ create table store_sales_seq_def_block like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_def_block partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_def_block; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -231,12 +238,13 @@ create table store_sales_seq_snapb_block like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_snapb_block partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_snapb_block; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -250,12 +258,13 @@ create table store_sales_seq_snap_block like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_snap_block partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_snap_block; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== @@ -269,12 +278,13 @@ create table store_sales_seq_gzip_block like tpcds_parquet.store_sales stored as SEQUENCEFILE; insert into store_sales_seq_gzip_block partition(ss_sold_date_sk) select * from tpcds_parquet.store_sales -where ss_sold_date_sk between 2450816 and 2451200; +where (ss_sold_date_sk between 2451175 and 2451200) or + (ss_sold_date_sk is null and ss_sold_time_sk > 60000); ==== ---- QUERY select count(*) from store_sales_seq_gzip_block; ---- RESULTS -37999 +60091 ---- TYPES BIGINT ==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/count.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpcds/queries/count.test b/testdata/workloads/tpcds/queries/count.test index 3ff7cd9..213c7a7 100644 --- a/testdata/workloads/tpcds/queries/count.test +++ b/testdata/workloads/tpcds/queries/count.test @@ -1,4 +1,32 @@ ==== +---- QUERY: TPCDS-CALL_CENTER +select count(*) from call_center +---- RESULTS +6 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-CATALOG_PAGE +select count(*) from catalog_page +---- RESULTS +11718 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-CATALOG_RETURNS +select count(*) from catalog_returns +---- RESULTS +144067 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-CATALOG_SALES +select count(*) from catalog_sales +---- RESULTS +1441548 +---- TYPES +BIGINT +==== ---- QUERY: TPCDS-COUNT-CUSTOMER select count(*) from customer ---- RESULTS @@ -34,6 +62,20 @@ select count(*) from household_demographics; ---- TYPES BIGINT ==== +---- QUERY: TPCDS-COUNT-INCOME_BAND +select count(*) from income_band; +---- RESULTS +20 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-INVENTORY +select count(*) from inventory; +---- RESULTS +11745000 +---- TYPES +BIGINT +==== ---- QUERY: TPCDS-COUNT-ITEM select count(*) from item; ---- RESULTS @@ -48,6 +90,13 @@ select count(*) from promotion; ---- TYPES BIGINT ==== +---- QUERY: TPCDS-COUNT-SHIP_MODE +select count(*) from ship_mode; +---- RESULTS +20 +---- TYPES +BIGINT +==== ---- QUERY: TPCDS-COUNT-STORE select count(*) from store; ---- RESULTS @@ -55,10 +104,59 @@ select count(*) from store; ---- TYPES BIGINT ==== +---- QUERY: TPCDS-COUNT-STORE_RETURNS +select count(*) from store_returns; +---- RESULTS +287514 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-STORE_SALES +select count(*) from store_sales; +---- RESULTS +2880404 +---- TYPES +BIGINT +==== ---- QUERY: TPCDS-COUNT-TIME_DIM select count(*) from time_dim; ---- RESULTS 86400 ---- TYPES BIGINT +==== +---- QUERY: TPCDS-COUNT-WAREHOUSE +select count(*) from warehouse; +---- RESULTS +5 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-WEB_PAGE +select count(*) from web_page; +---- RESULTS +60 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-WEB_RETURNS +select count(*) from web_returns; +---- RESULTS +71763 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-WEB_SALES +select count(*) from web_sales; +---- RESULTS +719384 +---- TYPES +BIGINT +==== +---- QUERY: TPCDS-COUNT-WEB_SITE +select count(*) from web_site; +---- RESULTS +30 +---- TYPES +BIGINT ==== \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q1.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpcds/queries/tpcds-q1.test b/testdata/workloads/tpcds/queries/tpcds-q1.test new file mode 100644 index 0000000..f4d8504 --- /dev/null +++ b/testdata/workloads/tpcds/queries/tpcds-q1.test @@ -0,0 +1,129 @@ +==== +---- QUERY: TPCDS-Q1 +with customer_total_return as +(select sr_customer_sk as ctr_customer_sk, + sr_store_sk as ctr_store_sk, + sum(SR_RETURN_AMT) as ctr_total_return + from store_returns, + date_dim + where sr_returned_date_sk = d_date_sk + and d_year = 2000 + group by sr_customer_sk, + sr_store_sk) +select c_customer_id +from customer_total_return ctr1, + store, + customer +where ctr1.ctr_total_return > + (select avg(ctr_total_return)*1.2 + from customer_total_return ctr2 + where ctr1.ctr_store_sk = ctr2.ctr_store_sk) + and s_store_sk = ctr1.ctr_store_sk + and s_state = 'TN' + and ctr1.ctr_customer_sk = c_customer_sk +order by c_customer_id +limit 100; +---- RESULTS +'AAAAAAAAAAABBAAA' +'AAAAAAAAAAADBAAA' +'AAAAAAAAAAADBAAA' +'AAAAAAAAAAAKAAAA' +'AAAAAAAAAABDAAAA' +'AAAAAAAAAABHBAAA' +'AAAAAAAAAABLAAAA' +'AAAAAAAAAABMAAAA' +'AAAAAAAAAACHAAAA' +'AAAAAAAAAACMAAAA' +'AAAAAAAAAADDAAAA' +'AAAAAAAAAADGAAAA' +'AAAAAAAAAADGBAAA' +'AAAAAAAAAADGBAAA' +'AAAAAAAAAADPAAAA' +'AAAAAAAAAAEBAAAA' +'AAAAAAAAAAEFBAAA' +'AAAAAAAAAAEGBAAA' +'AAAAAAAAAAEIAAAA' +'AAAAAAAAAAEMAAAA' +'AAAAAAAAAAFAAAAA' +'AAAAAAAAAAFPAAAA' +'AAAAAAAAAAGGBAAA' +'AAAAAAAAAAGHBAAA' +'AAAAAAAAAAGJAAAA' +'AAAAAAAAAAGMAAAA' +'AAAAAAAAAAHEBAAA' +'AAAAAAAAAAHFBAAA' +'AAAAAAAAAAIEBAAA' +'AAAAAAAAAAJGBAAA' +'AAAAAAAAAAJHBAAA' +'AAAAAAAAAAKCAAAA' +'AAAAAAAAAAKCAAAA' +'AAAAAAAAAAKJAAAA' +'AAAAAAAAAAKMAAAA' +'AAAAAAAAAAKMAAAA' +'AAAAAAAAAALAAAAA' +'AAAAAAAAAALABAAA' +'AAAAAAAAAALGAAAA' +'AAAAAAAAAALHBAAA' +'AAAAAAAAAALJAAAA' +'AAAAAAAAAANHAAAA' +'AAAAAAAAAANHBAAA' +'AAAAAAAAAANJAAAA' +'AAAAAAAAAANMAAAA' +'AAAAAAAAAANMAAAA' +'AAAAAAAAAANNAAAA' +'AAAAAAAAAAOBBAAA' +'AAAAAAAAAAODBAAA' +'AAAAAAAAAAOLAAAA' +'AAAAAAAAAAPGBAAA' +'AAAAAAAAABAAAAAA' +'AAAAAAAAABAEAAAA' +'AAAAAAAAABAEBAAA' +'AAAAAAAAABAFBAAA' +'AAAAAAAAABAIAAAA' +'AAAAAAAAABAOAAAA' +'AAAAAAAAABBDBAAA' +'AAAAAAAAABCFAAAA' +'AAAAAAAAABCHBAAA' +'AAAAAAAAABDHAAAA' +'AAAAAAAAABENAAAA' +'AAAAAAAAABFEBAAA' +'AAAAAAAAABFGAAAA' +'AAAAAAAAABFMAAAA' +'AAAAAAAAABFPAAAA' +'AAAAAAAAABGFAAAA' +'AAAAAAAAABGFBAAA' +'AAAAAAAAABGJAAAA' +'AAAAAAAAABIBBAAA' +'AAAAAAAAABICBAAA' +'AAAAAAAAABIIAAAA' +'AAAAAAAAABJNAAAA' +'AAAAAAAAABKGBAAA' +'AAAAAAAAABLOAAAA' +'AAAAAAAAABLPAAAA' +'AAAAAAAAABMABAAA' +'AAAAAAAAABMPAAAA' +'AAAAAAAAABNAAAAA' +'AAAAAAAAABNCBAAA' +'AAAAAAAAABNEBAAA' +'AAAAAAAAABNLAAAA' +'AAAAAAAAABNOAAAA' +'AAAAAAAAABNPAAAA' +'AAAAAAAAABOAAAAA' +'AAAAAAAAABOFBAAA' +'AAAAAAAAABOOAAAA' +'AAAAAAAAABOPAAAA' +'AAAAAAAAABPEAAAA' +'AAAAAAAAACADAAAA' +'AAAAAAAAACAFAAAA' +'AAAAAAAAACAFAAAA' +'AAAAAAAAACAHBAAA' +'AAAAAAAAACAJAAAA' +'AAAAAAAAACBDAAAA' +'AAAAAAAAACBDAAAA' +'AAAAAAAAACBEBAAA' +'AAAAAAAAACBNAAAA' +'AAAAAAAAACBPAAAA' +'AAAAAAAAACCHAAAA' +---- TYPES +STRING +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q19.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpcds/queries/tpcds-q19.test b/testdata/workloads/tpcds/queries/tpcds-q19.test index 2cb8f81..6e97776 100644 --- a/testdata/workloads/tpcds/queries/tpcds-q19.test +++ b/testdata/workloads/tpcds/queries/tpcds-q19.test @@ -16,14 +16,13 @@ from where d_date_sk = ss_sold_date_sk and ss_item_sk = i_item_sk - and i_manager_id = 7 + and i_manager_id = 8 and d_moy = 11 - and d_year = 1999 + and d_year = 1998 and ss_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and substr(ca_zip, 1, 5) <> substr(s_zip, 1, 5) and ss_store_sk = s_store_sk - and ss_sold_date_sk between 2451484 and 2451513 group by i_brand, i_brand_id, @@ -37,73 +36,106 @@ order by i_manufact limit 100; ---- RESULTS -6011008,'amalgbrand #8',84,'eseeing',NULL -2002002,'importoimporto #2',242,'ableeseable',NULL -9006005,'corpmaxi #5',839,'n stprieing',8147.20 -4003002,'exportiedu pack #2',207,'ationbarable',7984.70 -7006006,'corpbrand #6',878,'eingationeing',6619.12 -8013005,'exportimaxi #5',87,'ationeing',5974.64 -7016007,'corpnameless #7',288,'eingeingable',5847.84 -1003001,'exportiamalg #1',151,'oughtantiought',4869.72 -7004003,'edu packbrand #3',431,'oughtpriese',4859.86 -2002001,'importoimporto #1',723,'priableation',4701.00 -10002005,'importounivamalg #5',485,'antieingese',4197.48 -6008002,'namelesscorp #2',328,'eingablepri',4034.43 -2001001,'amalgimporto #1',233,'pripriable',3632.00 -6016006,'corpbrand #6',965,'anticallyn st',3468.63 -4001001,'amalgedu pack #1',167,'ationcallyought',3324.72 -10008003,'namelessunivamalg #3',453,'priantiese',3322.90 -1001002,'amalgamalg #2',268,'eingcallyable',3173.58 -7010003,'univnameless #3',203,'pribarable',3009.25 -5003001,'exportischolar #1',954,'eseantin st',2837.46 -8001001,'amalgnameless #1',329,'n stablepri',2431.00 -8004005,'edu packnameless #5',172,'ableationought',2282.65 -10005006,'scholarunivamalg #6',263,'pricallyable',2193.57 -5003002,'exportischolar #2',88,'eingeing',2162.40 -7012009,'importonameless #9',269,'n stcallyable',2032.55 -4001001,'amalgedu pack #1',284,'eseeingable',2008.54 -8005007,'scholarnameless #7',206,'callybarable',1948.66 -2004001,'edu packimporto #1',166,'callycallyought',1887.42 -3003001,'exportiexporti #1',550,'barantianti',1741.88 -7010007,'univnameless #7',873,'priationeing',1552.46 -2002002,'importoimporto #2',312,'ableoughtpri',1490.48 -8010009,'univmaxi #9',135,'antipriought',1394.81 -10008016,'namelessunivamalg #16',543,'prieseanti',1287.77 -3001001,'amalgexporti #1',18,'eingought',1280.16 -9011011,'amalgunivamalg #11',751,'oughtantiation',1258.60 -7002009,'importobrand #9',177,'ationationought',1183.84 -3003001,'exportiexporti #1',757,'ationantiation',1150.92 -7006007,'corpbrand #7',189,'n steingought',967.60 -5002001,'importoscholar #1',69,'n stcally',900.16 -9014011,'edu packunivamalg #11',15,'antiought',867.89 -5001001,'amalgscholar #1',125,'antiableought',784.52 -3002002,'importoexporti #2',52,'ableanti',714.42 -8005003,'scholarnameless #3',159,'n stantiought',648.94 -7009002,'maxibrand #2',233,'pripriable',642.72 -6004005,'edu packcorp #5',139,'n stpriought',589.60 -5004001,'edu packscholar #1',111,'oughtoughtought',497.30 -7014005,'edu packnameless #5',142,'ableeseought',469.80 -1003002,'exportiamalg #2',19,'n stought',435.83 -1002001,'importoamalg #1',876,'callyationeing',423.18 -5003001,'exportischolar #1',491,'oughtn stese',413.10 -4002001,'importoedu pack #1',534,'eseprianti',396.50 -2001001,'amalgimporto #1',685,'antieingcally',394.42 -5003001,'exportischolar #1',887,'ationeingeing',319.20 -4003001,'exportiedu pack #1',505,'antibaranti',257.57 -8006007,'corpnameless #7',602,'ablebarcally',257.14 -1001001,'amalgamalg #1',135,'antipriought',236.10 -5004001,'edu packscholar #1',158,'eingantiought',217.14 -4001001,'amalgedu pack #1',613,'prioughtcally',214.35 -3004002,'edu packexporti #2',83,'prieing',150.66 -1002001,'importoamalg #1',884,'eseeingeing',120.12 -5002002,'importoscholar #2',544,'eseeseanti',95.75 -2001001,'amalgimporto #1',129,'n stableought',92.70 -8007003,'brandnameless #3',309,'n stbarpri',79.83 -9015005,'scholarunivamalg #5',54,'eseanti',63.94 -1001001,'amalgamalg #1',180,'bareingought',31.78 -7010009,'univnameless #9',9,'n st',30.24 -5004002,'edu packscholar #2',306,'callybarpri',28.00 -6006003,'corpcorp #3',548,'eingeseanti',5.70 +3001001,'amalgexporti #1',358,'eingantipri',39779.20 +5002002,'importoscholar #2',503,'pribaranti',38877.55 +2002001,'importoimporto #1',229,'n stableable',38849.73 +6009001,'maxicorp #1',609,'n stbarcally',37679.02 +10012003,'importoamalgamalg #3',68,'eingcally',36856.35 +10015008,'scholaramalgamalg #8',839,'n stprieing',36664.59 +5003002,'exportischolar #2',50,'baranti',35402.74 +4002002,'importoedu pack #2',615,'antioughtcally',34673.98 +3002002,'importoexporti #2',581,'oughteinganti',34669.00 +5002001,'importoscholar #1',442,'ableeseese',34618.53 +5003001,'exportischolar #1',224,'eseableable',34541.38 +5004002,'edu packscholar #2',168,'eingcallyought',33004.86 +4001001,'amalgedu pack #1',379,'n stationpri',32777.45 +7009009,'maxibrand #9',10,'barought',32448.47 +8001009,'amalgnameless #9',21,'oughtable',32020.26 +1003001,'exportiamalg #1',162,'ablecallyought',31531.85 +10011013,'amalgamalgamalg #13',551,'oughtantianti',30259.44 +9004003,'edu packmaxi #3',191,'oughtn stought',29977.55 +7001002,'amalgbrand #2',122,'ableableought',29576.48 +10013006,'exportiamalgamalg #6',461,'oughtcallyese',29475.71 +7008009,'namelessbrand #9',540,'bareseanti',28888.95 +7013001,'exportinameless #1',18,'eingought',28720.16 +5004001,'edu packscholar #1',361,'oughtcallypri',28656.02 +5003001,'exportischolar #1',457,'ationantiese',28560.52 +5001001,'amalgscholar #1',192,'ablen stought',28136.83 +8007009,'brandnameless #9',34,'esepri',27968.38 +6010003,'univbrand #3',165,'anticallyought',27826.40 +4003001,'exportiedu pack #1',30,'barpri',27681.74 +1002002,'importoamalg #2',504,'esebaranti',27540.55 +9009011,'maximaxi #11',117,'ationoughtought',26149.58 +4002001,'importoedu pack #1',96,'callyn st',25291.42 +10012006,'importoamalgamalg #6',162,'ablecallyought',25077.80 +5002001,'importoscholar #1',202,'ablebarable',24662.36 +5004002,'edu packscholar #2',427,'ationableese',24502.14 +8009007,'maxinameless #7',146,'callyeseought',24020.70 +7002005,'importobrand #5',822,'ableableeing',23637.35 +4001001,'amalgedu pack #1',236,'callypriable',23425.22 +3002001,'importoexporti #1',889,'n steingeing',23327.10 +4001001,'amalgedu pack #1',106,'callybarought',23272.95 +9004011,'edu packmaxi #11',241,'oughteseable',23233.46 +3002002,'importoexporti #2',597,'ationn stanti',23181.94 +6011005,'amalgbrand #5',373,'priationpri',22935.30 +5004001,'edu packscholar #1',191,'oughtn stought',22767.49 +10003001,'exportiunivamalg #1',252,'ableantiable',22605.56 +2002001,'importoimporto #1',265,'anticallyable',22316.14 +2004001,'edu packimporto #1',584,'eseeinganti',22312.87 +4004002,'edu packedu pack #2',293,'prin stable',22272.04 +9011008,'amalgunivamalg #8',93,'prin st',22103.70 +1003002,'exportiamalg #2',400,'barbarese',21701.01 +8006008,'corpnameless #8',605,'antibarcally',21599.44 +7014001,'edu packnameless #1',23,'priable',21554.24 +5001002,'amalgscholar #2',124,'eseableought',21004.37 +5003002,'exportischolar #2',162,'ablecallyought',20986.26 +3002001,'importoexporti #1',176,'callyationought',20741.06 +2001001,'amalgimporto #1',219,'n stoughtable',20647.28 +2002001,'importoimporto #1',100,'barbarought',20543.92 +4004001,'edu packedu pack #1',718,'eingoughtation',20488.80 +8014009,'edu packmaxi #9',214,'eseoughtable',20379.43 +10010013,'univamalgamalg #13',656,'callyantically',20274.67 +4003001,'exportiedu pack #1',640,'baresecally',20218.12 +1001001,'amalgamalg #1',257,'ationantiable',19957.37 +2002001,'importoimporto #1',525,'antiableanti',19888.38 +8011002,'amalgmaxi #2',293,'prin stable',18991.25 +4002001,'importoedu pack #1',101,'oughtbarought',18892.36 +9012003,'importounivamalg #3',818,'eingoughteing',18832.74 +10001014,'amalgunivamalg #14',207,'ationbarable',18623.57 +4004001,'edu packedu pack #1',257,'ationantiable',18605.21 +1004001,'edu packamalg #1',675,'antiationcally',18349.99 +8012001,'importomaxi #1',277,'ationationable',18325.53 +1004001,'edu packamalg #1',380,'bareingpri',17896.97 +1002002,'importoamalg #2',50,'baranti',17737.23 +1001001,'amalgamalg #1',346,'callyesepri',17660.98 +2004002,'edu packimporto #2',912,'ableoughtn st',17422.31 +6005006,'scholarcorp #6',270,'barationable',17373.47 +8012007,'importomaxi #7',320,'barablepri',17247.22 +1004001,'edu packamalg #1',594,'esen stanti',17217.04 +10001009,'amalgunivamalg #9',414,'eseoughtese',17196.10 +1003002,'exportiamalg #2',483,'prieingese',17180.13 +10010005,'univamalgamalg #5',684,'eseeingcally',17146.97 +6004005,'edu packcorp #5',224,'eseableable',17081.31 +2002001,'importoimporto #1',134,'esepriought',16596.84 +8014007,'edu packmaxi #7',350,'barantipri',16580.66 +6007007,'brandcorp #7',47,'ationese',16413.40 +10011002,'amalgamalgamalg #2',112,'ableoughtought',16120.65 +2003001,'exportiimporto #1',288,'eingeingable',15769.87 +1002002,'importoamalg #2',489,'n steingese',15707.42 +6013003,'exportibrand #3',16,'callyought',15594.16 +10008005,'namelessunivamalg #5',813,'prioughteing',15433.53 +10004013,'edu packunivamalg #13',764,'esecallyation',15242.69 +9016003,'corpunivamalg #3',51,'oughtanti',15172.76 +10006012,'corpunivamalg #12',166,'callycallyought',15153.42 +5004001,'edu packscholar #1',595,'antin stanti',14910.27 +8003003,'exportinameless #3',85,'antieing',14890.03 +4003001,'exportiedu pack #1',239,'n stpriable',14778.52 +6006001,'corpcorp #1',258,'eingantiable',14579.72 +1004001,'edu packamalg #1',222,'ableableable',14254.25 +4003002,'exportiedu pack #2',117,'ationoughtought',14161.18 +1001001,'amalgamalg #1',89,'n steing',14133.10 +8016009,'corpmaxi #9',734,'esepriation',14055.01 +1002001,'importoamalg #1',184,'eseeingought',13719.81 ---- TYPES INT, STRING, INT, STRING, DECIMAL ====
