http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q17.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q17.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q17.test new file mode 100644 index 0000000..d4b59f3 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q17.test @@ -0,0 +1,25 @@ +==== +---- QUERY: TPCH-Q17 +# Q17 - Small-Quantity-Order Revenue Query +select + sum(l_extendedprice) / 7.0 as avg_yearly +from + customer.c_orders.o_lineitems l, + part p +where + p_partkey = l_partkey + and p_brand = 'Brand#23' + and p_container = 'MED BOX' + and l_quantity < ( + select + 0.2 * avg(l_quantity) + from + customer.c_orders.o_lineitems l + where + l_partkey = p_partkey + ) +---- RESULTS +348406.05 +---- TYPES +decimal +====
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q18.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q18.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q18.test new file mode 100644 index 0000000..658af2a --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q18.test @@ -0,0 +1,81 @@ +==== +---- QUERY: TPCH-Q18 +# Q18 - Large Value Customer Query +select + c_name, + c_custkey, + o_orderkey, + o_orderdate, + o_totalprice, + sum_quantity +from + customer c, + c.c_orders o, + (select sum(l_quantity) sum_quantity from o.o_lineitems) l +where + sum_quantity > 300 +order by + o_totalprice desc, + o_orderdate +limit 100 +---- RESULTS +'Customer#000128120',128120,4722021,'1994-04-07',544089.09,323.00 +'Customer#000144617',144617,3043270,'1997-02-12',530604.44,317.00 +'Customer#000013940',13940,2232932,'1997-04-13',522720.61,304.00 +'Customer#000066790',66790,2199712,'1996-09-30',515531.82,327.00 +'Customer#000046435',46435,4745607,'1997-07-03',508047.99,309.00 +'Customer#000015272',15272,3883783,'1993-07-28',500241.33,302.00 +'Customer#000146608',146608,3342468,'1994-06-12',499794.58,303.00 +'Customer#000096103',96103,5984582,'1992-03-16',494398.79,312.00 +'Customer#000024341',24341,1474818,'1992-11-15',491348.26,302.00 +'Customer#000137446',137446,5489475,'1997-05-23',487763.25,311.00 +'Customer#000107590',107590,4267751,'1994-11-04',485141.38,301.00 +'Customer#000050008',50008,2366755,'1996-12-09',483891.26,302.00 +'Customer#000015619',15619,3767271,'1996-08-07',480083.96,318.00 +'Customer#000077260',77260,1436544,'1992-09-12',479499.43,307.00 +'Customer#000109379',109379,5746311,'1996-10-10',478064.11,302.00 +'Customer#000054602',54602,5832321,'1997-02-09',471220.08,307.00 +'Customer#000105995',105995,2096705,'1994-07-03',469692.58,307.00 +'Customer#000148885',148885,2942469,'1992-05-31',469630.44,313.00 +'Customer#000114586',114586,551136,'1993-05-19',469605.59,308.00 +'Customer#000105260',105260,5296167,'1996-09-06',469360.57,303.00 +'Customer#000147197',147197,1263015,'1997-02-02',467149.67,320.00 +'Customer#000064483',64483,2745894,'1996-07-04',466991.35,304.00 +'Customer#000136573',136573,2761378,'1996-05-31',461282.73,301.00 +'Customer#000016384',16384,502886,'1994-04-12',458378.92,312.00 +'Customer#000117919',117919,2869152,'1996-06-20',456815.92,317.00 +'Customer#000012251',12251,735366,'1993-11-24',455107.26,309.00 +'Customer#000120098',120098,1971680,'1995-06-14',453451.23,308.00 +'Customer#000066098',66098,5007490,'1992-08-07',453436.16,304.00 +'Customer#000117076',117076,4290656,'1997-02-05',449545.85,301.00 +'Customer#000129379',129379,4720454,'1997-06-07',448665.79,303.00 +'Customer#000126865',126865,4702759,'1994-11-07',447606.65,320.00 +'Customer#000088876',88876,983201,'1993-12-30',446717.46,304.00 +'Customer#000036619',36619,4806726,'1995-01-17',446704.09,328.00 +'Customer#000141823',141823,2806245,'1996-12-29',446269.12,310.00 +'Customer#000053029',53029,2662214,'1993-08-13',446144.49,302.00 +'Customer#000018188',18188,3037414,'1995-01-25',443807.22,308.00 +'Customer#000066533',66533,29158,'1995-10-21',443576.50,305.00 +'Customer#000037729',37729,4134341,'1995-06-29',441082.97,309.00 +'Customer#000003566',3566,2329187,'1998-01-04',439803.36,304.00 +'Customer#000045538',45538,4527553,'1994-05-22',436275.31,305.00 +'Customer#000081581',81581,4739650,'1995-11-04',435405.90,305.00 +'Customer#000119989',119989,1544643,'1997-09-20',434568.25,320.00 +'Customer#000003680',3680,3861123,'1998-07-03',433525.97,301.00 +'Customer#000113131',113131,967334,'1995-12-15',432957.75,301.00 +'Customer#000141098',141098,565574,'1995-09-24',430986.69,301.00 +'Customer#000093392',93392,5200102,'1997-01-22',425487.51,304.00 +'Customer#000015631',15631,1845057,'1994-05-12',419879.59,302.00 +'Customer#000112987',112987,4439686,'1996-09-17',418161.49,305.00 +'Customer#000012599',12599,4259524,'1998-02-12',415200.61,304.00 +'Customer#000105410',105410,4478371,'1996-03-05',412754.51,302.00 +'Customer#000149842',149842,5156581,'1994-05-30',411329.35,302.00 +'Customer#000010129',10129,5849444,'1994-03-21',409129.85,309.00 +'Customer#000069904',69904,1742403,'1996-10-19',408513.00,305.00 +'Customer#000017746',17746,6882,'1997-04-09',408446.93,303.00 +'Customer#000013072',13072,1481925,'1998-03-15',399195.47,301.00 +'Customer#000082441',82441,857959,'1994-02-07',382579.74,305.00 +'Customer#000088703',88703,2995076,'1994-01-30',363812.12,302.00 +---- TYPES +STRING, BIGINT, BIGINT, STRING, DECIMAL, DECIMAL +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q19.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q19.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q19.test new file mode 100644 index 0000000..6bbe4f8 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q19.test @@ -0,0 +1,43 @@ +==== +---- QUERY: TPCH-Q19 +# Q19 - Discounted Revenue Query +select + sum(l_extendedprice * (1 - l_discount)) as revenue +from + customer.c_orders.o_lineitems l, + part p +where + p_partkey = l_partkey + and ( + ( + p_brand = 'Brand#12' + and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG') + and l_quantity >= 1 and l_quantity <= 11 + and p_size between 1 and 5 + and l_shipmode in ('AIR', 'AIR REG') + and l_shipinstruct = 'DELIVER IN PERSON' + ) + or + ( + p_brand = 'Brand#23' + and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK') + and l_quantity >= 10 and l_quantity <= 20 + and p_size between 1 and 10 + and l_shipmode in ('AIR', 'AIR REG') + and l_shipinstruct = 'DELIVER IN PERSON' + ) + or + ( + p_brand = 'Brand#34' + and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG') + and l_quantity >= 20 and l_quantity <= 30 + and p_size between 1 and 15 + and l_shipmode in ('AIR', 'AIR REG') + and l_shipinstruct = 'DELIVER IN PERSON' + ) + ) +---- RESULTS +3083843.0578 +---- TYPES +decimal +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q2.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q2.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q2.test new file mode 100644 index 0000000..0ef4768 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q2.test @@ -0,0 +1,147 @@ +==== +---- QUERY: TPCH-Q2 +# Q2 - Minimum Cost Supplier Query +select + s_acctbal, + s_name, + n_name, + p_partkey, + p_mfgr, + s_address, + s_phone, + s_comment +from + supplier s, + s.s_partsupps ps, + part p, + region r, + r.r_nations n +where + p_partkey = ps_partkey + and p_size = 15 + and p_type like '%BRASS' + and s_nationkey = n_nationkey + and r_name = 'EUROPE' + and ps_supplycost = ( + select + min(ps_supplycost) + from + supplier s, + s.s_partsupps ps, + region r, + r.r_nations n + where + p_partkey = ps_partkey + and s_nationkey = n_nationkey + and r_name = 'EUROPE' + ) +order by + s_acctbal desc, + n_name, + s_name, + p_partkey +limit 100 +---- RESULTS +9938.53,'Supplier#000005359','UNITED KINGDOM',185358,'Manufacturer#4','QKuHYh,vZGiwu2FWEJoLDx04','33-429-790-6131','uriously regular requests hag' +9937.84,'Supplier#000005969','ROMANIA',108438,'Manufacturer#1','ANDENSOSmk,miq23Xfb5RWt6dvUcvt6Qa','29-520-692-3537','efully express instructions. regular requests against the slyly fin' +9936.22,'Supplier#000005250','UNITED KINGDOM',249,'Manufacturer#4','B3rqp0xbSEim4Mpy2RH J','33-320-228-2957','etect about the furiously final accounts. slyly ironic pinto beans sleep inside the furiously' +9923.77,'Supplier#000002324','GERMANY',29821,'Manufacturer#4','y3OD9UywSTOk','17-779-299-1839','ackages boost blithely. blithely regular deposits c' +9871.22,'Supplier#000006373','GERMANY',43868,'Manufacturer#5','J8fcXWsTqM','17-813-485-8637','etect blithely bold asymptotes. fluffily ironic platelets wake furiously; blit' +9870.78,'Supplier#000001286','GERMANY',81285,'Manufacturer#2','YKA,E2fjiVd7eUrzp2Ef8j1QxGo2DFnosaTEH','17-516-924-4574',' regular accounts. furiously unusual courts above the fi' +9870.78,'Supplier#000001286','GERMANY',181285,'Manufacturer#4','YKA,E2fjiVd7eUrzp2Ef8j1QxGo2DFnosaTEH','17-516-924-4574',' regular accounts. furiously unusual courts above the fi' +9852.52,'Supplier#000008973','RUSSIA',18972,'Manufacturer#2','t5L67YdBYYH6o,Vz24jpDyQ9','32-188-594-7038','rns wake final foxes. carefully unusual depende' +9847.83,'Supplier#000008097','RUSSIA',130557,'Manufacturer#2','xMe97bpE69NzdwLoX','32-375-640-3593',' the special excuses. silent sentiments serve carefully final ac' +9847.57,'Supplier#000006345','FRANCE',86344,'Manufacturer#1','VSt3rzk3qG698u6ld8HhOByvrTcSTSvQlDQDag','16-886-766-7945','ges. slyly regular requests are. ruthless, express excuses cajole blithely across the unu' +9847.57,'Supplier#000006345','FRANCE',173827,'Manufacturer#2','VSt3rzk3qG698u6ld8HhOByvrTcSTSvQlDQDag','16-886-766-7945','ges. slyly regular requests are. ruthless, express excuses cajole blithely across the unu' +9836.93,'Supplier#000007342','RUSSIA',4841,'Manufacturer#4','JOlK7C1,7xrEZSSOw','32-399-414-5385','blithely carefully bold theodolites. fur' +9817.10,'Supplier#000002352','RUSSIA',124815,'Manufacturer#2','4LfoHUZjgjEbAKw TgdKcgOc4D4uCYw','32-551-831-1437','wake carefully alongside of the carefully final ex' +9817.10,'Supplier#000002352','RUSSIA',152351,'Manufacturer#3','4LfoHUZjgjEbAKw TgdKcgOc4D4uCYw','32-551-831-1437','wake carefully alongside of the carefully final ex' +9739.86,'Supplier#000003384','FRANCE',138357,'Manufacturer#2','o,Z3v4POifevE k9U1b 6J1ucX,I','16-494-913-5925','s after the furiously bold packages sleep fluffily idly final requests: quickly final' +9721.95,'Supplier#000008757','UNITED KINGDOM',156241,'Manufacturer#3','Atg6GnM4dT2','33-821-407-2995','eep furiously sauternes; quickl' +9681.33,'Supplier#000008406','RUSSIA',78405,'Manufacturer#1',',qUuXcftUl','32-139-873-8571','haggle slyly regular excuses. quic' +9643.55,'Supplier#000005148','ROMANIA',107617,'Manufacturer#1','kT4ciVFslx9z4s79p Js825','29-252-617-4850','final excuses. final ideas boost quickly furiously speci' +9624.82,'Supplier#000001816','FRANCE',34306,'Manufacturer#3','e7vab91vLJPWxxZnewmnDBpDmxYHrb','16-392-237-6726','e packages are around the special ideas. special, pending foxes us' +9624.78,'Supplier#000009658','ROMANIA',189657,'Manufacturer#1','oE9uBgEfSS4opIcepXyAYM,x','29-748-876-2014','ronic asymptotes wake bravely final' +9612.94,'Supplier#000003228','ROMANIA',120715,'Manufacturer#2','KDdpNKN3cWu7ZSrbdqp7AfSLxx,qWB','29-325-784-8187','warhorses. quickly even deposits sublate daringly ironic instructions. slyly blithe t' +9612.94,'Supplier#000003228','ROMANIA',198189,'Manufacturer#4','KDdpNKN3cWu7ZSrbdqp7AfSLxx,qWB','29-325-784-8187','warhorses. quickly even deposits sublate daringly ironic instructions. slyly blithe t' +9571.83,'Supplier#000004305','ROMANIA',179270,'Manufacturer#2','qNHZ7WmCzygwMPRDO9Ps','29-973-481-1831','kly carefully express asymptotes. furiou' +9558.10,'Supplier#000003532','UNITED KINGDOM',88515,'Manufacturer#4','EOeuiiOn21OVpTlGguufFDFsbN1p0lhpxHp','33-152-301-2164',' foxes. quickly even excuses use. slyly special foxes nag bl' +9492.79,'Supplier#000005975','GERMANY',25974,'Manufacturer#5','S6mIiCTx82z7lV','17-992-579-4839','arefully pending accounts. blithely regular excuses boost carefully carefully ironic p' +9461.05,'Supplier#000002536','UNITED KINGDOM',20033,'Manufacturer#1','8mmGbyzaU 7ZS2wJumTibypncu9pNkDc4FYA','33-556-973-5522','. slyly regular deposits wake slyly. furiously regular warthogs are.' +9453.01,'Supplier#000000802','ROMANIA',175767,'Manufacturer#1',',6HYXb4uaHITmtMBj4Ak57Pd','29-342-882-6463','gular frets. permanently special multipliers believe blithely alongs' +9408.65,'Supplier#000007772','UNITED KINGDOM',117771,'Manufacturer#4','AiC5YAH,gdu0i7','33-152-491-1126','nag against the final requests. furiously unusual packages cajole blit' +9359.61,'Supplier#000004856','ROMANIA',62349,'Manufacturer#5','HYogcF3Jb yh1','29-334-870-9731','y ironic theodolites. blithely sile' +9357.45,'Supplier#000006188','UNITED KINGDOM',138648,'Manufacturer#1','g801,ssP8wpTk4Hm','33-583-607-1633','ously always regular packages. fluffily even accounts beneath the furiously final pack' +9352.04,'Supplier#000003439','GERMANY',170921,'Manufacturer#4','qYPDgoiBGhCYxjgC','17-128-996-4650',' according to the carefully bold ideas' +9312.97,'Supplier#000007807','RUSSIA',90279,'Manufacturer#5','oGYMPCk9XHGB2PBfKRnHA','32-673-872-5854','ecial packages among the pending, even requests use regula' +9312.97,'Supplier#000007807','RUSSIA',100276,'Manufacturer#5','oGYMPCk9XHGB2PBfKRnHA','32-673-872-5854','ecial packages among the pending, even requests use regula' +9280.27,'Supplier#000007194','ROMANIA',47193,'Manufacturer#3','zhRUQkBSrFYxIAXTfInj vyGRQjeK','29-318-454-2133','o beans haggle after the furiously unusual deposits. carefully silent dolphins cajole carefully' +9274.80,'Supplier#000008854','RUSSIA',76346,'Manufacturer#3','1xhLoOUM7I3mZ1mKnerw OSqdbb4QbGa','32-524-148-5221','y. courts do wake slyly. carefully ironic platelets haggle above the slyly regular the' +9249.35,'Supplier#000003973','FRANCE',26466,'Manufacturer#1','d18GiDsL6Wm2IsGXM,RZf1jCsgZAOjNYVThTRP4','16-722-866-1658','uests are furiously. regular tithes through the regular, final accounts cajole furiously above the q' +9249.35,'Supplier#000003973','FRANCE',33972,'Manufacturer#1','d18GiDsL6Wm2IsGXM,RZf1jCsgZAOjNYVThTRP4','16-722-866-1658','uests are furiously. regular tithes through the regular, final accounts cajole furiously above the q' +9208.70,'Supplier#000007769','ROMANIA',40256,'Manufacturer#5','rsimdze 5o9P Ht7xS','29-964-424-9649','lites was quickly above the furiously ironic requests. slyly even foxes against the blithely bold ' +9201.47,'Supplier#000009690','UNITED KINGDOM',67183,'Manufacturer#5','CB BnUTlmi5zdeEl7R7','33-121-267-9529','e even, even foxes. blithely ironic packages cajole regular packages. slyly final ide' +9192.10,'Supplier#000000115','UNITED KINGDOM',85098,'Manufacturer#3','nJ 2t0f7Ve,wL1,6WzGBJLNBUCKlsV','33-597-248-1220','es across the carefully express accounts boost caref' +9189.98,'Supplier#000001226','GERMANY',21225,'Manufacturer#4','qsLCqSvLyZfuXIpjz','17-725-903-1381',' deposits. blithely bold excuses about the slyly bold forges wake ' +9128.97,'Supplier#000004311','RUSSIA',146768,'Manufacturer#5','I8IjnXd7NSJRs594RxsRR0','32-155-440-7120','refully. blithely unusual asymptotes haggle ' +9104.83,'Supplier#000008520','GERMANY',150974,'Manufacturer#4','RqRVDgD0ER J9 b41vR2,3','17-728-804-1793','ly about the blithely ironic depths. slyly final theodolites among the fluffily bold ideas print' +9101.00,'Supplier#000005791','ROMANIA',128254,'Manufacturer#5','zub2zCV,jhHPPQqi,P2INAjE1zI n66cOEoXFG','29-549-251-5384','ts. notornis detect blithely above the carefully bold requests. blithely even package' +9094.57,'Supplier#000004582','RUSSIA',39575,'Manufacturer#1','WB0XkCSG3r,mnQ n,h9VIxjjr9ARHFvKgMDf','32-587-577-1351','jole. regular accounts sleep blithely frets. final pinto beans play furiously past the ' +8996.87,'Supplier#000004702','FRANCE',102191,'Manufacturer#5','8XVcQK23akp','16-811-269-8946','ickly final packages along the express plat' +8996.14,'Supplier#000009814','ROMANIA',139813,'Manufacturer#2','af0O5pg83lPU4IDVmEylXZVqYZQzSDlYLAmR','29-995-571-8781',' dependencies boost quickly across the furiously pending requests! unusual dolphins play sl' +8968.42,'Supplier#000010000','ROMANIA',119999,'Manufacturer#5','aTGLEusCiL4F PDBdv665XBJhPyCOB0i','29-578-432-2146','ly regular foxes boost slyly. quickly special waters boost carefully ironi' +8936.82,'Supplier#000007043','UNITED KINGDOM',109512,'Manufacturer#1','FVajceZInZdbJE6Z9XsRUxrUEpiwHDrOXi,1Rz','33-784-177-8208','efully regular courts. furiousl' +8929.42,'Supplier#000008770','FRANCE',173735,'Manufacturer#4','R7cG26TtXrHAP9 HckhfRi','16-242-746-9248','cajole furiously unusual requests. quickly stealthy requests are. ' +8920.59,'Supplier#000003967','ROMANIA',26460,'Manufacturer#1','eHoAXe62SY9','29-194-731-3944','aters. express, pending instructions sleep. brave, r' +8920.59,'Supplier#000003967','ROMANIA',173966,'Manufacturer#2','eHoAXe62SY9','29-194-731-3944','aters. express, pending instructions sleep. brave, r' +8913.96,'Supplier#000004603','UNITED KINGDOM',137063,'Manufacturer#2','OUzlvMUr7n,utLxmPNeYKSf3T24OXskxB5','33-789-255-7342',' haggle slyly above the furiously regular pinto beans. even ' +8877.82,'Supplier#000007967','FRANCE',167966,'Manufacturer#5','A3pi1BARM4nx6R,qrwFoRPU','16-442-147-9345','ously foxes. express, ironic requests im' +8862.24,'Supplier#000003323','ROMANIA',73322,'Manufacturer#3','W9 lYcsC9FwBqk3ItL','29-736-951-3710','ly pending ideas sleep about the furiously unu' +8841.59,'Supplier#000005750','ROMANIA',100729,'Manufacturer#5','Erx3lAgu0g62iaHF9x50uMH4EgeN9hEG','29-344-502-5481','gainst the pinto beans. fluffily unusual dependencies affix slyly even deposits.' +8781.71,'Supplier#000003121','ROMANIA',13120,'Manufacturer#5','wNqTogx238ZYCamFb,50v,bj 4IbNFW9Bvw1xP','29-707-291-5144','s wake quickly ironic ideas' +8754.24,'Supplier#000009407','UNITED KINGDOM',179406,'Manufacturer#4','CHRCbkaWcf5B','33-903-970-9604','e ironic requests. carefully even foxes above the furious' +8691.06,'Supplier#000004429','UNITED KINGDOM',126892,'Manufacturer#2','k,BQms5UhoAF1B2Asi,fLib','33-964-337-5038','efully express deposits kindle after the deposits. final ' +8655.99,'Supplier#000006330','RUSSIA',193810,'Manufacturer#2','UozlaENr0ytKe2w6CeIEWFWn iO3S8Rae7Ou','32-561-198-3705','symptotes use about the express dolphins. requests use after the express platelets. final, ex' +8638.36,'Supplier#000002920','RUSSIA',75398,'Manufacturer#1','Je2a8bszf3L','32-122-621-7549','ly quickly ironic requests. even requests whithout t' +8638.36,'Supplier#000002920','RUSSIA',170402,'Manufacturer#3','Je2a8bszf3L','32-122-621-7549','ly quickly ironic requests. even requests whithout t' +8607.69,'Supplier#000006003','UNITED KINGDOM',76002,'Manufacturer#2','EH9wADcEiuenM0NR08zDwMidw,52Y2RyILEiA','33-416-807-5206','ar, pending accounts. pending depende' +8569.52,'Supplier#000005936','RUSSIA',5935,'Manufacturer#5','jXaNZ6vwnEWJ2ksLZJpjtgt0bY2a3AU','32-644-251-7916','. regular foxes nag carefully atop the regular, silent deposits. quickly regular packages ' +8564.12,'Supplier#000000033','GERMANY',110032,'Manufacturer#1','gfeKpYw3400L0SDywXA6Ya1Qmq1w6YB9f3R','17-138-897-9374','n sauternes along the regular asymptotes are regularly along the ' +8553.82,'Supplier#000003979','ROMANIA',143978,'Manufacturer#4','BfmVhCAnCMY3jzpjUMy4CNWs9 HzpdQR7INJU','29-124-646-4897','ic requests wake against the blithely unusual accounts. fluffily r' +8517.23,'Supplier#000009529','RUSSIA',37025,'Manufacturer#5','e44R8o7JAIS9iMcr','32-565-297-8775','ove the even courts. furiously special platelets ' +8517.23,'Supplier#000009529','RUSSIA',59528,'Manufacturer#2','e44R8o7JAIS9iMcr','32-565-297-8775','ove the even courts. furiously special platelets ' +8503.70,'Supplier#000006830','RUSSIA',44325,'Manufacturer#4','BC4WFCYRUZyaIgchU 4S','32-147-878-5069','pades cajole. furious packages among the carefully express excuses boost furiously across th' +8457.09,'Supplier#000009456','UNITED KINGDOM',19455,'Manufacturer#1','7SBhZs8gP1cJjT0Qf433YBk','33-858-440-4349','cing requests along the furiously unusual deposits promise among the furiously unus' +8441.40,'Supplier#000003817','FRANCE',141302,'Manufacturer#2','hU3fz3xL78','16-339-356-5115','ely even ideas. ideas wake slyly furiously unusual instructions. pinto beans sleep ag' +8432.89,'Supplier#000003990','RUSSIA',191470,'Manufacturer#1','wehBBp1RQbfxAYDASS75MsywmsKHRVdkrvNe6m','32-839-509-9301','ep furiously. packages should have to haggle slyly across the deposits. furiously regu' +8431.40,'Supplier#000002675','ROMANIA',5174,'Manufacturer#1','HJFStOu9R5NGPOegKhgbzBdyvrG2yh8w','29-474-643-1443','ithely express pinto beans. blithely even foxes haggle. furiously regular theodol' +8407.04,'Supplier#000005406','RUSSIA',162889,'Manufacturer#4','j7 gYF5RW8DC5UrjKC','32-626-152-4621','r the blithely regular packages. slyly ironic theodoli' +8386.08,'Supplier#000008518','FRANCE',36014,'Manufacturer#3','2jqzqqAVe9crMVGP,n9nTsQXulNLTUYoJjEDcqWV','16-618-780-7481','blithely bold pains are carefully platelets. finally regular pinto beans sleep carefully special' +8376.52,'Supplier#000005306','UNITED KINGDOM',190267,'Manufacturer#5','9t8Y8 QqSIsoADPt6NLdk,TP5zyRx41oBUlgoGc9','33-632-514-7931','ly final accounts sleep special, regular requests. furiously regular' +8348.74,'Supplier#000008851','FRANCE',66344,'Manufacturer#4','nWxi7GwEbjhw1','16-796-240-2472',' boldly final deposits. regular, even instructions detect slyly. fluffily unusual pinto bea' +8338.58,'Supplier#000007269','FRANCE',17268,'Manufacturer#4','ZwhJSwABUoiB04,3','16-267-277-4365','iously final accounts. even pinto beans cajole slyly regular' +8328.46,'Supplier#000001744','ROMANIA',69237,'Manufacturer#5','oLo3fV64q2,FKHa3p,qHnS7Yzv,ps8','29-330-728-5873','ep carefully-- even, careful packages are slyly along t' +8307.93,'Supplier#000003142','GERMANY',18139,'Manufacturer#1','dqblvV8dCNAorGlJ','17-595-447-6026','olites wake furiously regular decoys. final requests nod ' +8231.61,'Supplier#000009558','RUSSIA',192000,'Manufacturer#2','mcdgen,yT1iJDHDS5fV','32-762-137-5858',' foxes according to the furi' +8152.61,'Supplier#000002731','ROMANIA',15227,'Manufacturer#4',' nluXJCuY1tu','29-805-463-2030',' special requests. even, regular warhorses affix among the final gr' +8109.09,'Supplier#000009186','FRANCE',99185,'Manufacturer#1','wgfosrVPexl9pEXWywaqlBMDYYf','16-668-570-1402','tions haggle slyly about the sil' +8102.62,'Supplier#000003347','UNITED KINGDOM',18344,'Manufacturer#5','m CtXS2S16i','33-454-274-8532','egrate with the slyly bold instructions. special foxes haggle silently among the' +8046.07,'Supplier#000008780','FRANCE',191222,'Manufacturer#3','AczzuE0UK9osj ,Lx0Jmh','16-473-215-6395','onic platelets cajole after the regular instructions. permanently bold excuses' +8042.09,'Supplier#000003245','RUSSIA',135705,'Manufacturer#4','Dh8Ikg39onrbOL4DyTfGw8a9oKUX3d9Y','32-836-132-8872','osits. packages cajole slyly. furiously regular deposits cajole slyly. q' +8042.09,'Supplier#000003245','RUSSIA',150729,'Manufacturer#1','Dh8Ikg39onrbOL4DyTfGw8a9oKUX3d9Y','32-836-132-8872','osits. packages cajole slyly. furiously regular deposits cajole slyly. q' +7992.40,'Supplier#000006108','FRANCE',118574,'Manufacturer#1','8tBydnTDwUqfBfFV4l3','16-974-998-8937',' ironic ideas? fluffily even instructions wake. blithel' +7980.65,'Supplier#000001288','FRANCE',13784,'Manufacturer#4','zE,7HgVPrCn','16-646-464-8247','ully bold courts. escapades nag slyly. furiously fluffy theodo' +7950.37,'Supplier#000008101','GERMANY',33094,'Manufacturer#5','kkYvL6IuvojJgTNG IKkaXQDYgx8ILohj','17-627-663-8014','arefully unusual requests x-ray above the quickly final deposits. ' +7937.93,'Supplier#000009012','ROMANIA',83995,'Manufacturer#2','iUiTziH,Ek3i4lwSgunXMgrcTzwdb','29-250-925-9690','to the blithely ironic deposits nag sly' +7914.45,'Supplier#000001013','RUSSIA',125988,'Manufacturer#2','riRcntps4KEDtYScjpMIWeYF6mNnR','32-194-698-3365',' busily bold packages are dolphi' +7912.91,'Supplier#000004211','GERMANY',159180,'Manufacturer#5','2wQRVovHrm3,v03IKzfTd,1PYsFXQFFOG','17-266-947-7315','ay furiously regular platelets. cou' +7912.91,'Supplier#000004211','GERMANY',184210,'Manufacturer#4','2wQRVovHrm3,v03IKzfTd,1PYsFXQFFOG','17-266-947-7315','ay furiously regular platelets. cou' +7894.56,'Supplier#000007981','GERMANY',85472,'Manufacturer#4','NSJ96vMROAbeXP','17-963-404-3760','ic platelets affix after the furiously' +7887.08,'Supplier#000009792','GERMANY',164759,'Manufacturer#3','Y28ITVeYriT3kIGdV2K8fSZ V2UqT5H1Otz','17-988-938-4296','ckly around the carefully fluffy theodolites. slyly ironic pack' +7871.50,'Supplier#000007206','RUSSIA',104695,'Manufacturer#1','3w fNCnrVmvJjE95sgWZzvW','32-432-452-7731','ironic requests. furiously final theodolites cajole. final, express packages sleep. quickly reg' +7852.45,'Supplier#000005864','RUSSIA',8363,'Manufacturer#4','WCNfBPZeSXh3h,c','32-454-883-3821','usly unusual pinto beans. brave ideas sleep carefully quickly ironi' +7850.66,'Supplier#000001518','UNITED KINGDOM',86501,'Manufacturer#1','ONda3YJiHKJOC','33-730-383-3892','ifts haggle fluffily pending pai' +7843.52,'Supplier#000006683','FRANCE',11680,'Manufacturer#4','2Z0JGkiv01Y00oCFwUGfviIbhzCdy','16-464-517-8943',' express, final pinto beans x-ray slyly asymptotes. unusual, unusual' +---- TYPES +DECIMAL, STRING, STRING, BIGINT, STRING, STRING, STRING, STRING +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q20.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q20.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q20.test new file mode 100644 index 0000000..87b1dcd --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q20.test @@ -0,0 +1,226 @@ +==== +---- QUERY: TPCH-Q20 +# Q20 - Potential Part Promotion Query +# Note: Tricky rewrite from the original to avoid mixing +# correlated and uncorrelated table refs in a subquery. +select distinct + s_name, + s_address +from + supplier s, + s.s_partsupps ps, + region.r_nations n +where + ps_partkey in ( + select + p_partkey + from + part p + where + p_name like 'forest%' + ) + and ps_availqty > ( + select + 0.5 * sum(l_quantity) + from + customer.c_orders.o_lineitems l + where + l_partkey = ps_partkey + and l_suppkey = s_suppkey + and l_shipdate >= '1994-01-01' + and l_shipdate < '1995-01-01' + ) + and s_nationkey = n_nationkey + and n_name = 'CANADA' +order by + s_name +---- RESULTS +'Supplier#000000020','iybAE,RmTymrZVYaFZva2SH,j' +'Supplier#000000091','YV45D7TkfdQanOOZ7q9QxkyGUapU1oOWU6q3' +'Supplier#000000205','rF uV8d0JNEk' +'Supplier#000000285','Br7e1nnt1yxrw6ImgpJ7YdhFDjuBf' +'Supplier#000000287','7a9SP7qW5Yku5PvSg' +'Supplier#000000354','w8fOo5W,aS' +'Supplier#000000378','FfbhyCxWvcPrO8ltp9' +'Supplier#000000402','i9Sw4DoyMhzhKXCH9By,AYSgmD' +'Supplier#000000530','0qwCMwobKY OcmLyfRXlagA8ukENJv,' +'Supplier#000000555','TfB,a5bfl3Ah 3Z 74GqnNs6zKVGM' +'Supplier#000000640','mvvtlQKsTOsJj5Ihk7,cq' +'Supplier#000000729','pqck2ppy758TQpZCUAjPvlU55K3QjfL7Bi' +'Supplier#000000736','l6i2nMwVuovfKnuVgaSGK2rDy65DlAFLegiL7' +'Supplier#000000761','zlSLelQUj2XrvTTFnv7WAcYZGvvMTx882d4' +'Supplier#000000887','urEaTejH5POADP2ARrf' +'Supplier#000000935','ij98czM 2KzWe7dDTOxB8sq0UfCdvrX' +'Supplier#000000975',',AC e,tBpNwKb5xMUzeohxlRn, hdZJo73gFQF8y' +'Supplier#000001263','rQWr6nf8ZhB2TAiIDIvo5Io' +'Supplier#000001367','42YSkFcAXMMcucsqeEefOE4HeCC' +'Supplier#000001426','bPOCc086oFm8sLtS,fGrH' +'Supplier#000001446','lch9HMNU1R7a0LIybsUodVknk6' +'Supplier#000001500','wDmF5xLxtQch9ctVu,' +'Supplier#000001602','uKNWIeafaM644' +'Supplier#000001626','UhxNRzUu1dtFmp0' +'Supplier#000001682','pXTkGxrTQVyH1Rr' +'Supplier#000001700','7hMlCof1Y5zLFg' +'Supplier#000001726','TeRY7TtTH24sEword7yAaSkjx8' +'Supplier#000001730','Rc8e,1Pybn r6zo0VJIEiD0UD vhk' +'Supplier#000001746','qWsendlOekQG1aW4uq06uQaCm51se8lirv7 hBRd' +'Supplier#000001806','M934fuZSnLW' +'Supplier#000001855','MWk6EAeozXb' +'Supplier#000001931','FpJbMU2h6ZR2eBv8I9NIxF' +'Supplier#000002022',' dwebGX7Id2pc25YvY33' +'Supplier#000002036','20ytTtVObjKUUI2WCB0A' +'Supplier#000002096','kuxseyLtq QPLXxm9ZUrnB6Kkh92JtK5cQzzXNU ' +'Supplier#000002117','MRtkgKolHJ9Wh X9J,urANHKDzvjr' +'Supplier#000002204','uYmlr46C06udCqanj0KiRsoTQakZsEyssL' +'Supplier#000002218','nODZw5q4dx kp0K5' +'Supplier#000002243','nSOEV3JeOU79' +'Supplier#000002245','hz2qWXWVjOyKhqPYMoEwz6zFkrTaDM' +'Supplier#000002282','ES21K9dxoW1I1TzWCj7ekdlNwSWnv1Z 6mQ,BKn' +'Supplier#000002303','nCoWfpB6YOymbgOht7ltfklpkHl' +'Supplier#000002331','WRh2w5WFvRg7Z0S1AvSvHCL' +'Supplier#000002373','RzHSxOTQmElCjxIBiVA52Z JB58rJhPRylR' +'Supplier#000002419','qydBQd14I5l5mVXa4fYY' +'Supplier#000002571','JZUugz04c iJFLrlGsz9O N,W 1rVHNIReyq' +'Supplier#000002585','CsPoKpw2QuTY4AV1NkWuttneIa4SN' +'Supplier#000002629','0Bw,q5Zp8su9XrzoCngZ3cAEXZwZ' +'Supplier#000002721','HVdFAN2JHMQSpKm' +'Supplier#000002730','lIFxR4fzm31C6,muzJwl84z' +'Supplier#000002775','yDclaDaBD4ihH' +'Supplier#000002799','lwr, 6L3gdfc79PQut,4XO6nQsTJY63cAyYO' +'Supplier#000002934','m,trBENywSArwg3DhB' +'Supplier#000002941','Naddba 8YTEKekZyP0' +'Supplier#000003028','jouzgX0WZjhNMWLaH4fy' +'Supplier#000003095','HxON3jJhUi3zjt,r mTD' +'Supplier#000003143','hdolgh608uTkHh7t6qfSqkifKaiFjnCH' +'Supplier#000003185','hMa535Cbf2mj1Nw4OWOKWVrsK0VdDkJURrdjSIJe' +'Supplier#000003189','DWdPxt7 RnkZv6VOByR0em' +'Supplier#000003201','E87yws6I,t0qNs4QW7UzExKiJnJDZWue' +'Supplier#000003213','pxrRP4irQ1VoyfQ,dTf3' +'Supplier#000003275','9xO4nyJ2QJcX6vGf' +'Supplier#000003288','EDdfNt7E5Uc,xLTupoIgYL4yY7ujh,' +'Supplier#000003314','jnisU8MzqO4iUB3zsPcrysMw3DDUojS4q7LD' +'Supplier#000003373','iy8VM48ynpc3N2OsBwAvhYakO2us9R1bi' +'Supplier#000003421','Sh3dt9W5oeofFWovnFhrg,' +'Supplier#000003422','DJoCEapUeBXoV1iYiCcPFQvzsTv2ZI960' +'Supplier#000003441','zvFJIzS,oUuShHjpcX' +'Supplier#000003590','sy79CMLxqb,Cbo' +'Supplier#000003607','lNqFHQYjwSAkf' +'Supplier#000003625','qY588W0Yk5iaUy1RXTgNrEKrMAjBYHcKs' +'Supplier#000003723','jZEp0OEythCLcS OmJSrFtxJ66bMlzSp' +'Supplier#000003849','KgbZEaRk,6Q3mWvwh6uptrs1KRUHg 0' +'Supplier#000003894','vvGC rameLOk' +'Supplier#000003941','Pmb05mQfBMS618O7WKqZJ 9vyv' +'Supplier#000004059','umEYZSq9RJ2WEzdsv9meU8rmqwzVLRgiZwC' +'Supplier#000004207','tF64pwiOM4IkWjN3mS,e06WuAjLx' +'Supplier#000004236','dl,HPtJmGipxYsSqn9wmqkuWjst,mCeJ8O6T' +'Supplier#000004278','bBddbpBxIVp Di9' +'Supplier#000004281','1OwPHh Pgiyeus,iZS5eA23JDOipwk' +'Supplier#000004304','hQCAz59k,HLlp2CKUrcBIL' +'Supplier#000004346','S3076LEOwo' +'Supplier#000004406','Ah0ZaLu6VwufPWUz,7kbXgYZhauEaHqGIg' +'Supplier#000004430','yvSsKNSTL5HLXBET4luOsPNLxKzAMk' +'Supplier#000004527','p pVXCnxgcklWF6A1o3OHY3qW6' +'Supplier#000004655','67NqBc4 t3PG3F8aO IsqWNq4kGaPowYL' +'Supplier#000004851','Rj,x6IgLT7kBL99nqp' +'Supplier#000004871',',phpt6AWEnUS8t4Avb50rFfdg7O9c6nU8xxv8eC5' +'Supplier#000004884','42Z1uLye9nsn6aTGBNd dI8 x' +'Supplier#000004975','GPq5PMKY6Wy' +'Supplier#000005076','Xl7h9ifgvIHmqxFLgWfHK4Gjav BkP' +'Supplier#000005195','Woi3b2ZaicPh ZSfu1EfXhE' +'Supplier#000005256','Onc3t57VAMchm,pmoVLaU8bONni9NsuaM PzMMFz' +'Supplier#000005257','f9g8SEHB7obMj3QXAjXS2vfYY22' +'Supplier#000005300','gXG28YqpxU' +'Supplier#000005323','tMCkdqbDoyNo8vMIkzjBqYexoRAuv,T6 qzcu' +'Supplier#000005386','Ub6AAfHpWLWP' +'Supplier#000005426','9Dz2OVT1q sb4BK71ljQ1XjPBYRPvO' +'Supplier#000005465','63cYZenZBRZ613Q1FaoG0,smnC5zl9' +'Supplier#000005484','saFdOR qW7AFY,3asPqiiAa11Mo22pCoN0BtPrKo' +'Supplier#000005505','d2sbjG43KwMPX' +'Supplier#000005506','On f5ypzoWgB' +'Supplier#000005631','14TVrjlzo2SJEBYCDgpMwTlvwSqC' +'Supplier#000005642','ZwKxAv3V40tW E8P7Qwu,zlu,kPsL' +'Supplier#000005686','f2RBKec2T1NIi7yS M' +'Supplier#000005730','5rkb0PSews HvxkL8JaD41UpnSF2cg8H1' +'Supplier#000005736','2dq XTYhtYWSfp' +'Supplier#000005737','dmEWcS32C3kx,d,B95 OmYn48' +'Supplier#000005797',',o,OebwRbSDmVl9gN9fpWPCiqB UogvlSR' +'Supplier#000005875','lK,sYiGzB94hSyHy9xvSZFbVQNCZe2LXZuGbS' +'Supplier#000005974','REhR5jE,lLusQXvf54SwYySgsSSVFhu' +'Supplier#000006059','4m0cv8MwJ9yX2vlwI Z' +'Supplier#000006065','UiI2Cy3W4Tu5sLk LuvXLRy6KihlGv' +'Supplier#000006093','KJNUg1odUT2wtCS2s6PrH3D6fd' +'Supplier#000006099','aZilwQKYDTVPoK' +'Supplier#000006109','rY5gbfh3dKHnylcQUTPGCwnbe' +'Supplier#000006217','RVN23SYT9jenUeaWGXUd' +'Supplier#000006297','73VRDOO56GUCyvc40oYJ' +'Supplier#000006435','xIgE69XszYbnO4Eon7cHHO8y' +'Supplier#000006463','7 wkdj2EO49iotley2kmIM ADpLSszGV3RNWj' +'Supplier#000006478','bQYPnj9lpmW3U' +'Supplier#000006521','b9 2zjHzxR' +'Supplier#000006642','N,CUclSqRLJcS8zQ' +'Supplier#000006659','iTLsnvD8D2GzWNUv kRInwRjk5rDeEmfup1' +'Supplier#000006669','NQ4Yryj624p7K53' +'Supplier#000006748','rC,2rEn8gKDIS5Q0dJEoiF' +'Supplier#000006761','n4jhxGMqB5prD1HhpLvwrWStOLlla' +'Supplier#000006808','HGd2Xo 9nEcHJhZvXjXxWKIpApT' +'Supplier#000006858','fnlINT885vBBhsWwTGiZ0o22thwGY16h GHJj21' +'Supplier#000006946','To6Slo0GJTqcIvD' +'Supplier#000006949','mLxYUJhsGcLtKe ,GFirNu183AvT' +'Supplier#000007072','2tRyX9M1a 4Rcm57s779F1ANG9jlpK' +'Supplier#000007098','G3j8g0KC4OcbAu2OVoPHrXQWMCUdjq8wgCHOExu' +'Supplier#000007132','xonvn0KAQIL3p8kYk HC1FSSDSUSTC' +'Supplier#000007135','ls DoKV7V5ulfQy9V' +'Supplier#000007147','Xzb16kC63wmLVYexUEgB0hXFvHkjT5iPpq' +'Supplier#000007160','TqDGBULB3cTqIT6FKDvm9BS4e4v,zwYiQPb' +'Supplier#000007169','tEc95D2moN9S84nd55O,dlnW' +'Supplier#000007278','I2ae3rS7KVF8GVHtB' +'Supplier#000007365','51xhROLvQMJ05DndtZWt' +'Supplier#000007398','V8eE6oZ00OFNU,' +'Supplier#000007402','4UVv58ery1rjmqSR5' +'Supplier#000007448','yhhpWiJi7EJ6Q5VCaQ' +'Supplier#000007458','BYuucapYkptZl6fnd2QaDyZmI9gR1Ih16e' +'Supplier#000007477','9m9j0wfhWzCvVHxkU,PpAxwSH0h' +'Supplier#000007509','q8,V6LJRoHJjHcOuSG7aLTMg' +'Supplier#000007561','rMcFg2530VC' +'Supplier#000007616','R IovIqzDi3,QHnaqZk1xS4hGAgelhP4yj' +'Supplier#000007760','JsPE18PvcdFTK' +'Supplier#000007801','69fi,U1r6enUb ' +'Supplier#000007865','5cDGCS,T6N' +'Supplier#000007885','u3sicchh5ZpyTUpN1cJKNcAoabIWgY' +'Supplier#000007926','ErzCF80K9Uy' +'Supplier#000007998','LnASFBfYRFOo9d6d,asBvVq9Lo2P' +'Supplier#000008090','eonbJZvoDFYBNUinYfp6yERIg' +'Supplier#000008224','TWxt9f,LVER' +'Supplier#000008231','IK7eGw Yj90sTdpsP,vcqWxLB' +'Supplier#000008243','2AyePMkDqmzVzjGTizXthFLo8h EiudCMxOmIIG' +'Supplier#000008323','75I18sZmASwm POeheRMdj9tmpyeQ,BfCXN5BIAb' +'Supplier#000008366','h778cEj14BuW9OEKlvPTWq4iwASR6EBBXN7zeS8' +'Supplier#000008532','Uc29q4,5xVdDOF87UZrxhr4xWS0ihEUXuh' +'Supplier#000008595','MH0iB73GQ3z UW3O DbCbqmc' +'Supplier#000008610','SgVgP90vP452sUNTgzL9zKwXHXAzV6tV' +'Supplier#000008683','gLuGcugfpJSeGQARnaHNCaWnGaqsNnjyl20' +'Supplier#000008705','aE,trRNdPx,4yinTD9O3DebDIp' +'Supplier#000008742','HmPlQEzKCPEcTUL14,kKq' +'Supplier#000008841','I 85Lu1sekbg2xrSIzm0' +'Supplier#000008872','8D 45GgxJO2OwwYP9S4AaXJKvDwPfLM' +'Supplier#000008879','rDSA,D9oPM,65NMWEFrmGKAu' +'Supplier#000008967','2kwEHyMG 7FwozNImAUE6mH0hYtqYculJM' +'Supplier#000008972','w2vF6 D5YZO3visPXsqVfLADTK' +'Supplier#000009032','qK,trB6Sdy4Dz1BRUFNy' +'Supplier#000009043','57OPvKH4qyXIZ7IzYeCaw11a5N1Ki9f1WWmVQ,' +'Supplier#000009278','RqYTzgxj93CLX 0mcYfCENOefD' +'Supplier#000009326','XmiC,uy36B9,fb0zhcjaagiXQutg' +'Supplier#000009430','igRqmneFt ' +'Supplier#000009549','h3RVchUf8MzY46IzbZ0ng09' +'Supplier#000009601','51m637bO,Rw5DnHWFUvLacRx9' +'Supplier#000009709','rRnCbHYgDgl9PZYnyWKVYSUW0vKg' +'Supplier#000009753','wLhVEcRmd7PkJF4FBnGK7Z' +'Supplier#000009799',' 4wNjXGa4OKWl' +'Supplier#000009811','E3iuyq7UnZxU7oPZIe2Gu6' +'Supplier#000009812','APFRMy3lCbgFga53n5t9DxzFPQPgnjrGt32' +'Supplier#000009846','57sNwJJ3PtBDu,hMPP5QvpcOcSNRXn3PypJJrh' +'Supplier#000009899','7XdpAHrzr1t,UQFZE' +'Supplier#000009974','7wJ,J5DKcxSU4Kp1cQLpbcAvB5AsvKT' +---- TYPES +string, string +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q21.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q21.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q21.test new file mode 100644 index 0000000..24c1c41 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q21.test @@ -0,0 +1,145 @@ +==== +---- QUERY: TPCH-Q21 +# Q21 - Suppliers Who Kept Orders Waiting Query +select + s_name, + count(*) as numwait +from + supplier s, + customer c, + c.c_orders o, + o.o_lineitems l1, + region.r_nations n +where + s_suppkey = l1.l_suppkey + and o_orderstatus = 'F' + and l1.l_receiptdate > l1.l_commitdate + and exists ( + select + * + from + o.o_lineitems l2 + where + l2.l_suppkey <> l1.l_suppkey + ) + and not exists ( + select + * + from + o.o_lineitems l3 + where + l3.l_suppkey <> l1.l_suppkey + and l3.l_receiptdate > l3.l_commitdate + ) + and s_nationkey = n_nationkey + and n_name = 'SAUDI ARABIA' +group by + s_name +order by + numwait desc, + s_name +limit 100 +---- RESULTS +'Supplier#000002829',20 +'Supplier#000005808',18 +'Supplier#000000262',17 +'Supplier#000000496',17 +'Supplier#000002160',17 +'Supplier#000002301',17 +'Supplier#000002540',17 +'Supplier#000003063',17 +'Supplier#000005178',17 +'Supplier#000008331',17 +'Supplier#000002005',16 +'Supplier#000002095',16 +'Supplier#000005799',16 +'Supplier#000005842',16 +'Supplier#000006450',16 +'Supplier#000006939',16 +'Supplier#000009200',16 +'Supplier#000009727',16 +'Supplier#000000486',15 +'Supplier#000000565',15 +'Supplier#000001046',15 +'Supplier#000001047',15 +'Supplier#000001161',15 +'Supplier#000001336',15 +'Supplier#000001435',15 +'Supplier#000003075',15 +'Supplier#000003335',15 +'Supplier#000005649',15 +'Supplier#000006027',15 +'Supplier#000006795',15 +'Supplier#000006800',15 +'Supplier#000006824',15 +'Supplier#000007131',15 +'Supplier#000007382',15 +'Supplier#000008913',15 +'Supplier#000009787',15 +'Supplier#000000633',14 +'Supplier#000001960',14 +'Supplier#000002323',14 +'Supplier#000002490',14 +'Supplier#000002993',14 +'Supplier#000003101',14 +'Supplier#000004489',14 +'Supplier#000005435',14 +'Supplier#000005583',14 +'Supplier#000005774',14 +'Supplier#000007579',14 +'Supplier#000008180',14 +'Supplier#000008695',14 +'Supplier#000009224',14 +'Supplier#000000357',13 +'Supplier#000000436',13 +'Supplier#000000610',13 +'Supplier#000000788',13 +'Supplier#000000889',13 +'Supplier#000001062',13 +'Supplier#000001498',13 +'Supplier#000002056',13 +'Supplier#000002312',13 +'Supplier#000002344',13 +'Supplier#000002596',13 +'Supplier#000002615',13 +'Supplier#000002978',13 +'Supplier#000003048',13 +'Supplier#000003234',13 +'Supplier#000003727',13 +'Supplier#000003806',13 +'Supplier#000004472',13 +'Supplier#000005236',13 +'Supplier#000005906',13 +'Supplier#000006241',13 +'Supplier#000006326',13 +'Supplier#000006384',13 +'Supplier#000006394',13 +'Supplier#000006624',13 +'Supplier#000006629',13 +'Supplier#000006682',13 +'Supplier#000006737',13 +'Supplier#000006825',13 +'Supplier#000007021',13 +'Supplier#000007417',13 +'Supplier#000007497',13 +'Supplier#000007602',13 +'Supplier#000008134',13 +'Supplier#000008234',13 +'Supplier#000009435',13 +'Supplier#000009436',13 +'Supplier#000009564',13 +'Supplier#000009896',13 +'Supplier#000000379',12 +'Supplier#000000673',12 +'Supplier#000000762',12 +'Supplier#000000811',12 +'Supplier#000000821',12 +'Supplier#000001337',12 +'Supplier#000001916',12 +'Supplier#000001925',12 +'Supplier#000002039',12 +'Supplier#000002357',12 +'Supplier#000002483',12 +---- TYPES +string, bigint +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q22.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q22.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q22.test new file mode 100644 index 0000000..0312be3 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q22.test @@ -0,0 +1,46 @@ +==== +---- QUERY: TPCH-Q22 +# Q22 - Global Sales Opportunity Query +select + cntrycode, + count(*) as numcust, + sum(c_acctbal) as totacctbal +from ( + select + substr(c_phone, 1, 2) as cntrycode, + c_acctbal + from + customer c + where + substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17') + and c_acctbal > ( + select + avg(c_acctbal) + from + customer c + where + c_acctbal > 0.00 + and substr(c_phone, 1, 2) in ('13', '31', '23', '29', '30', '18', '17') + ) + and not exists ( + select + o_orderkey + from + c.c_orders + ) + ) as custsale +group by + cntrycode +order by + cntrycode +---- RESULTS +'13',888,6737713.99 +'17',861,6460573.72 +'18',964,7236687.40 +'23',892,6701457.95 +'29',948,7158866.63 +'30',909,6808436.13 +'31',922,6806670.18 +---- TYPES +string, bigint, decimal +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q3.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q3.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q3.test new file mode 100644 index 0000000..0c5b4e8 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q3.test @@ -0,0 +1,38 @@ +==== +---- QUERY: TPCH-Q3 +# Q3 - Shipping Priority Query +select + o_orderkey, + sum(l_extendedprice * (1 - l_discount)) as revenue, + o_orderdate, + o_shippriority +from + customer c, + c.c_orders o, + o.o_lineitems l +where + c_mktsegment = 'BUILDING' + and o_orderdate < '1995-03-15' + and l_shipdate > '1995-03-15' +group by + o_orderkey, + o_orderdate, + o_shippriority +order by + revenue desc, + o_orderdate +limit 10 +---- RESULTS +2456423,406181.0111,'1995-03-05',0 +3459808,405838.6989,'1995-03-04',0 +492164,390324.0610,'1995-02-19',0 +1188320,384537.9359,'1995-03-09',0 +2435712,378673.0558,'1995-02-26',0 +4878020,378376.7952,'1995-03-12',0 +5521732,375153.9215,'1995-03-13',0 +2628192,373133.3094,'1995-02-22',0 +993600,371407.4595,'1995-03-05',0 +2300070,367371.1452,'1995-03-13',0 +---- TYPES +BIGINT, DECIMAL, STRING, INT +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q4.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q4.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q4.test new file mode 100644 index 0000000..4b9d960 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q4.test @@ -0,0 +1,33 @@ +==== +---- QUERY: TPCH-Q4 +# Q4 - Order Priority Checking Query +select + o_orderpriority, + count(*) as order_count +from + customer c, + c.c_orders o +where + o_orderdate >= '1993-07-01' + and o_orderdate < '1993-10-01' + and exists ( + select + * + from + o.o_lineitems + where + l_commitdate < l_receiptdate + ) +group by + o_orderpriority +order by + o_orderpriority +---- RESULTS +'1-URGENT',10594 +'2-HIGH',10476 +'3-MEDIUM',10410 +'4-NOT SPECIFIED',10556 +'5-LOW',10487 +---- TYPES +string, bigint +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q5.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q5.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q5.test new file mode 100644 index 0000000..fa66e09 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q5.test @@ -0,0 +1,33 @@ +==== +---- QUERY: TPCH-Q5 +# Q5 - Local Supplier Volume Query +select + n_name, + sum(l_extendedprice * (1 - l_discount)) as revenue +from + customer c, + c.c_orders o, + o.o_lineitems l, + supplier s, + region r, + r.r_nations n +where + l_suppkey = s_suppkey + and c_nationkey = s_nationkey + and s_nationkey = n_nationkey + and r_name = 'ASIA' + and o_orderdate >= '1994-01-01' + and o_orderdate < '1995-01-01' +group by + n_name +order by + revenue desc +---- RESULTS +'INDONESIA',55502041.1697 +'VIETNAM',55295086.9967 +'CHINA',53724494.2566 +'INDIA',52035512.0002 +'JAPAN',45410175.6954 +---- TYPES +string, decimal +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q6.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q6.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q6.test new file mode 100644 index 0000000..efb43e8 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q6.test @@ -0,0 +1,17 @@ +==== +---- QUERY: TPCH-Q6 +# Q6 - Forecasting Revenue Change Query +select + sum(l_extendedprice * l_discount) as revenue +from + customer.c_orders.o_lineitems +where + l_shipdate >= '1994-01-01' + and l_shipdate < '1995-01-01' + and l_discount between 0.05 and 0.07 + and l_quantity < 24 +---- RESULTS +123141078.2283 +---- TYPES +decimal +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q7.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q7.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q7.test new file mode 100644 index 0000000..0c5878d --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q7.test @@ -0,0 +1,47 @@ +==== +---- QUERY: TPCH-Q7 +# Q7 - Volume Shipping Query +select + supp_nation, + cust_nation, + l_year, + sum(volume) as revenue +from ( + select + n1.n_name as supp_nation, + n2.n_name as cust_nation, + year(l_shipdate) as l_year, + l_extendedprice * (1 - l_discount) as volume + from + customer c, + c.c_orders o, + o.o_lineitems l, + supplier s, + region.r_nations n1, + region.r_nations n2 + where + s_suppkey = l_suppkey + and s_nationkey = n1.n_nationkey + and c_nationkey = n2.n_nationkey + and ( + (n1.n_name = 'FRANCE' and n2.n_name = 'GERMANY') + or (n1.n_name = 'GERMANY' and n2.n_name = 'FRANCE') + ) + and l_shipdate between '1995-01-01' and '1996-12-31' + ) as shipping +group by + supp_nation, + cust_nation, + l_year +order by + supp_nation, + cust_nation, + l_year +---- RESULTS +'FRANCE','GERMANY',1995,54639732.7336 +'FRANCE','GERMANY',1996,54633083.3076 +'GERMANY','FRANCE',1995,52531746.6697 +'GERMANY','FRANCE',1996,52520549.0224 +---- TYPES +STRING, STRING, INT, DECIMAL +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q8.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q8.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q8.test new file mode 100644 index 0000000..94d91a6 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q8.test @@ -0,0 +1,43 @@ +==== +---- QUERY: TPCH-Q8 +# Q8 - National Market Share Query +select + o_year, + sum(case + when nation = 'BRAZIL' + then volume + else 0 + end) / sum(volume) as mkt_share +from ( + select + year(o_orderdate) as o_year, + l_extendedprice * (1 - l_discount) as volume, + n2.n_name as nation + from + customer c, + c.c_orders o, + o.o_lineitems l, + supplier s, + part p, + region r, + r.r_nations n1, + region.r_nations n2 + where + p_partkey = l_partkey + and s_suppkey = l_suppkey + and c_nationkey = n1.n_nationkey + and r_name = 'AMERICA' + and s_nationkey = n2.n_nationkey + and o_orderdate between '1995-01-01' and '1996-12-31' + and p_type = 'ECONOMY ANODIZED STEEL' + ) as all_nations +group by + o_year +order by + o_year +---- RESULTS +1995,0.0344 +1996,0.0414 +---- TYPES +int, decimal +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/testdata/workloads/tpch_nested/queries/tpch_nested-q9.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/tpch_nested/queries/tpch_nested-q9.test b/testdata/workloads/tpch_nested/queries/tpch_nested-q9.test new file mode 100644 index 0000000..0290433 --- /dev/null +++ b/testdata/workloads/tpch_nested/queries/tpch_nested-q9.test @@ -0,0 +1,211 @@ +==== +---- QUERY: TPCH-Q9 +# Q9 - Product Type Measure Query +select + nation, + o_year, + sum(amount) as sum_profit +from( + select + n_name as nation, + year(o_orderdate) as o_year, + l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount + from + customer.c_orders o, + o.o_lineitems l, + supplier s, + s.s_partsupps ps, + part p, + region.r_nations n + where + s_suppkey = l_suppkey + and ps_partkey = l_partkey + and p_partkey = l_partkey + and s_nationkey = n_nationkey + and p_name like '%green%' + ) as profit +group by + nation, + o_year +order by + nation, + o_year desc +---- RESULTS +'ALGERIA',1998,27136900.1803 +'ALGERIA',1997,48611833.4962 +'ALGERIA',1996,48285482.6782 +'ALGERIA',1995,44402273.5999 +'ALGERIA',1994,48694008.0668 +'ALGERIA',1993,46044207.7838 +'ALGERIA',1992,45636849.4881 +'ARGENTINA',1998,28341663.7848 +'ARGENTINA',1997,47143964.1176 +'ARGENTINA',1996,45255278.6021 +'ARGENTINA',1995,45631769.2054 +'ARGENTINA',1994,48268856.3547 +'ARGENTINA',1993,48605593.6162 +'ARGENTINA',1992,46654240.7487 +'BRAZIL',1998,26527736.3960 +'BRAZIL',1997,45640660.7677 +'BRAZIL',1996,45090647.1630 +'BRAZIL',1995,44015888.5132 +'BRAZIL',1994,44854218.8932 +'BRAZIL',1993,45766603.7379 +'BRAZIL',1992,45280216.8027 +'CANADA',1998,26828985.3944 +'CANADA',1997,44849954.3186 +'CANADA',1996,46307936.1108 +'CANADA',1995,47311993.0441 +'CANADA',1994,46691491.9596 +'CANADA',1993,46634791.1121 +'CANADA',1992,45873849.6882 +'CHINA',1998,27510180.1657 +'CHINA',1997,46123865.4097 +'CHINA',1996,49532807.0601 +'CHINA',1995,46734651.4838 +'CHINA',1994,46397896.6097 +'CHINA',1993,49634673.9463 +'CHINA',1992,46949457.6426 +'EGYPT',1998,28401491.7968 +'EGYPT',1997,47674857.6783 +'EGYPT',1996,47745727.5450 +'EGYPT',1995,45897160.6783 +'EGYPT',1994,47194895.2280 +'EGYPT',1993,49133627.6471 +'EGYPT',1992,47000574.5027 +'ETHIOPIA',1998,25135046.1377 +'ETHIOPIA',1997,43010596.0838 +'ETHIOPIA',1996,43636287.1922 +'ETHIOPIA',1995,43575757.3343 +'ETHIOPIA',1994,41597208.5283 +'ETHIOPIA',1993,42622804.1616 +'ETHIOPIA',1992,44385735.6813 +'FRANCE',1998,26210392.2804 +'FRANCE',1997,42392969.4731 +'FRANCE',1996,43306317.9749 +'FRANCE',1995,46377408.4328 +'FRANCE',1994,43447352.9922 +'FRANCE',1993,43729961.0639 +'FRANCE',1992,44052308.4290 +'GERMANY',1998,25991257.1071 +'GERMANY',1997,43968355.8079 +'GERMANY',1996,45882074.8049 +'GERMANY',1995,43314338.3077 +'GERMANY',1994,44616995.4369 +'GERMANY',1993,45126645.9113 +'GERMANY',1992,44361141.2107 +'INDIA',1998,29626417.2379 +'INDIA',1997,51386111.3448 +'INDIA',1996,47571018.5122 +'INDIA',1995,49344062.2829 +'INDIA',1994,50106952.4261 +'INDIA',1993,48112766.6987 +'INDIA',1992,47914303.1234 +'INDONESIA',1998,27734909.6763 +'INDONESIA',1997,44593812.9863 +'INDONESIA',1996,44746729.8078 +'INDONESIA',1995,45593622.6993 +'INDONESIA',1994,45988483.8772 +'INDONESIA',1993,46147963.7895 +'INDONESIA',1992,45185777.0688 +'IRAN',1998,26661608.9301 +'IRAN',1997,45019114.1696 +'IRAN',1996,45891397.0992 +'IRAN',1995,44414285.2348 +'IRAN',1994,43696360.4795 +'IRAN',1993,45362775.8094 +'IRAN',1992,43052338.4143 +'IRAQ',1998,31188498.1914 +'IRAQ',1997,48585307.5222 +'IRAQ',1996,50036593.8404 +'IRAQ',1995,48774801.7275 +'IRAQ',1994,48795847.2310 +'IRAQ',1993,47435691.5082 +'IRAQ',1992,47562355.6571 +'JAPAN',1998,24694102.1720 +'JAPAN',1997,42377052.3454 +'JAPAN',1996,40267778.9094 +'JAPAN',1995,40925317.4650 +'JAPAN',1994,41159518.3058 +'JAPAN',1993,39589074.2771 +'JAPAN',1992,39113493.9052 +'JORDAN',1998,23489867.7893 +'JORDAN',1997,41615962.6619 +'JORDAN',1996,41860855.4684 +'JORDAN',1995,39931672.0908 +'JORDAN',1994,40707555.4638 +'JORDAN',1993,39060405.4658 +'JORDAN',1992,41657604.2684 +'KENYA',1998,25566337.4303 +'KENYA',1997,43108847.9024 +'KENYA',1996,43482953.5430 +'KENYA',1995,42517988.9814 +'KENYA',1994,43612479.4523 +'KENYA',1993,42724038.7571 +'KENYA',1992,43217106.2068 +'MOROCCO',1998,24915496.8756 +'MOROCCO',1997,42698382.8550 +'MOROCCO',1996,42986113.5049 +'MOROCCO',1995,42316089.1593 +'MOROCCO',1994,43458604.6029 +'MOROCCO',1993,42672288.0699 +'MOROCCO',1992,42800781.6415 +'MOZAMBIQUE',1998,28279876.0301 +'MOZAMBIQUE',1997,51159216.2298 +'MOZAMBIQUE',1996,48072525.0645 +'MOZAMBIQUE',1995,48905200.6007 +'MOZAMBIQUE',1994,46092076.2805 +'MOZAMBIQUE',1993,48555926.2669 +'MOZAMBIQUE',1992,47809075.1192 +'PERU',1998,26713966.2678 +'PERU',1997,48324008.6011 +'PERU',1996,50310008.8629 +'PERU',1995,49647080.9629 +'PERU',1994,46420910.2773 +'PERU',1993,51536906.2487 +'PERU',1992,47711665.3137 +'ROMANIA',1998,27271993.1010 +'ROMANIA',1997,45063059.1953 +'ROMANIA',1996,47492335.0323 +'ROMANIA',1995,45710636.2909 +'ROMANIA',1994,46088041.1066 +'ROMANIA',1993,47515092.5613 +'ROMANIA',1992,44111439.8044 +'RUSSIA',1998,27935323.7271 +'RUSSIA',1997,48222347.2924 +'RUSSIA',1996,47553559.4932 +'RUSSIA',1995,46755990.0976 +'RUSSIA',1994,48000515.6191 +'RUSSIA',1993,48569624.5082 +'RUSSIA',1992,47672831.5329 +'SAUDI ARABIA',1998,27113516.8424 +'SAUDI ARABIA',1997,46690468.9649 +'SAUDI ARABIA',1996,47775782.6670 +'SAUDI ARABIA',1995,46657107.8287 +'SAUDI ARABIA',1994,48181672.8100 +'SAUDI ARABIA',1993,45692556.4438 +'SAUDI ARABIA',1992,48924913.2717 +'UNITED KINGDOM',1998,26366682.8786 +'UNITED KINGDOM',1997,44518130.1851 +'UNITED KINGDOM',1996,45539729.6166 +'UNITED KINGDOM',1995,46845879.3390 +'UNITED KINGDOM',1994,43081609.5737 +'UNITED KINGDOM',1993,44770146.7555 +'UNITED KINGDOM',1992,44123402.5484 +'UNITED STATES',1998,27826593.6825 +'UNITED STATES',1997,46638572.3648 +'UNITED STATES',1996,46688280.5474 +'UNITED STATES',1995,48951591.6156 +'UNITED STATES',1994,45099092.0598 +'UNITED STATES',1993,46181600.5278 +'UNITED STATES',1992,46168214.0901 +'VIETNAM',1998,27281931.0011 +'VIETNAM',1997,48735914.1796 +'VIETNAM',1996,47824595.9040 +'VIETNAM',1995,48235135.8016 +'VIETNAM',1994,47729256.3324 +'VIETNAM',1993,45352676.8672 +'VIETNAM',1992,47846355.6485 +---- TYPES +STRING, INT, DECIMAL +==== http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/95f5fb75/tests/query_test/test_tpch_nested_queries.py ---------------------------------------------------------------------- diff --git a/tests/query_test/test_tpch_nested_queries.py b/tests/query_test/test_tpch_nested_queries.py index 28e6ac3..84c7b46 100644 --- a/tests/query_test/test_tpch_nested_queries.py +++ b/tests/query_test/test_tpch_nested_queries.py @@ -34,67 +34,67 @@ class TestTpchNestedQuery(ImpalaTestSuite): v.get_value('table_format').file_format in ['parquet']) def test_tpch_q1(self, vector): - self.run_test_case('tpch-q1', vector) + self.run_test_case(self.get_workload() + '-q1', vector) def test_tpch_q2(self, vector): - self.run_test_case('tpch-q2', vector) + self.run_test_case(self.get_workload() + '-q2', vector) def test_tpch_q3(self, vector): - self.run_test_case('tpch-q3', vector) + self.run_test_case(self.get_workload() + '-q3', vector) def test_tpch_q4(self, vector): - self.run_test_case('tpch-q4', vector) + self.run_test_case(self.get_workload() + '-q4', vector) def test_tpch_q5(self, vector): - self.run_test_case('tpch-q5', vector) + self.run_test_case(self.get_workload() + '-q5', vector) def test_tpch_q6(self, vector): - self.run_test_case('tpch-q6', vector) + self.run_test_case(self.get_workload() + '-q6', vector) def test_tpch_q7(self, vector): - self.run_test_case('tpch-q7', vector) + self.run_test_case(self.get_workload() + '-q7', vector) def test_tpch_q8(self, vector): - self.run_test_case('tpch-q8', vector) + self.run_test_case(self.get_workload() + '-q8', vector) def test_tpch_q9(self, vector): - self.run_test_case('tpch-q9', vector) + self.run_test_case(self.get_workload() + '-q9', vector) def test_tpch_q10(self, vector): - self.run_test_case('tpch-q10', vector) + self.run_test_case(self.get_workload() + '-q10', vector) def test_tpch_q11(self, vector): - self.run_test_case('tpch-q11', vector) + self.run_test_case(self.get_workload() + '-q11', vector) def test_tpch_q12(self, vector): - self.run_test_case('tpch-q12', vector) + self.run_test_case(self.get_workload() + '-q12', vector) def test_tpch_q13(self, vector): - self.run_test_case('tpch-q13', vector) + self.run_test_case(self.get_workload() + '-q13', vector) def test_tpch_q14(self, vector): - self.run_test_case('tpch-q14', vector) + self.run_test_case(self.get_workload() + '-q14', vector) def test_tpch_q15(self, vector): - self.run_test_case('tpch-q15', vector) + self.run_test_case(self.get_workload() + '-q15', vector) def test_tpch_q16(self, vector): - self.run_test_case('tpch-q16', vector) + self.run_test_case(self.get_workload() + '-q16', vector) def test_tpch_q17(self, vector): - self.run_test_case('tpch-q17', vector) + self.run_test_case(self.get_workload() + '-q17', vector) def test_tpch_q18(self, vector): - self.run_test_case('tpch-q18', vector) + self.run_test_case(self.get_workload() + '-q18', vector) def test_tpch_q19(self, vector): - self.run_test_case('tpch-q19', vector) + self.run_test_case(self.get_workload() + '-q19', vector) def test_tpch_q20(self, vector): - self.run_test_case('tpch-q20', vector) + self.run_test_case(self.get_workload() + '-q20', vector) def test_tpch_q21(self, vector): - self.run_test_case('tpch-q21', vector) + self.run_test_case(self.get_workload() + '-q21', vector) def test_tpch_q22(self, vector): - self.run_test_case('tpch-q22', vector) + self.run_test_case(self.get_workload() + '-q22', vector)
