You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by kw...@apache.org on 2017/05/27 05:34:39 UTC
[09/11] incubator-impala git commit: IMPALA-5376: Loads all TPC-DS
tables
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
====