# TPCH 0.2 result on CHSpark+MergeTree, unchecked # Q1 +------------+------------+-----------+---------------------+---------------------+---------------------+------------------+------------------+--------------------+-----------+ |L_RETURNFLAG|L_LINESTATUS|SUM_QTY |SUM_BASE_PRICE |SUM_DISC_PRICE |SUM_CHARGE |AVG_QTY |AVG_PRICE |AVG_DISC |COUNT_ORDER| +------------+------------+-----------+---------------------+---------------------+---------------------+------------------+------------------+--------------------+-----------+ |A |F |7560075.0 |1.0733757366570068E10|1.0733742537612368E10|1.0733754386450478E10|25.542088281500753|36264.53153561859 |0.05010037670829274 |295985 | |N |F |195505.0 |2.763066185930176E8 |2.7630623399301386E8 |2.7630654086301494E8 |25.281908702961335|35730.84425100447 |0.049734902366480954|7733 | |N |O |1.4897242E7|2.1148613492948486E10|2.114858429110872E10 |2.1148607655495037E10|25.5334164037152 |36248.075628809915|0.050051024868034186|583441 | |R |F |7549344.0 |1.072146214706836E10 |1.0721447343530666E10|1.0721459183048895E10|25.52221639987153 |36246.2588856078 |0.05004662012543813 |295795 | +------------+------------+-----------+---------------------+---------------------+---------------------+------------------+------------------+--------------------+-----------+ # Q2 +---------+------------------+--------------+---------+--------------+----------------------------------------+---------------+---------------------------------------------------------------------------------------------------+ |S_ACCTBAL|S_NAME |N_NAME |P_PARTKEY|P_MFGR |S_ADDRESS |S_PHONE |S_COMMENT | +---------+------------------+--------------+---------+--------------+----------------------------------------+---------------+---------------------------------------------------------------------------------------------------+ |9767.99 |Supplier#000000135|GERMANY |1634 |Manufacturer#2|F4Uy ZQNU6ESTmO3mrL,mI |17-290-812-8855|courts wake slyly instructions. furiously silent requests cajol | |9759.38 |Supplier#000000044|GERMANY |39005 |Manufacturer#2|kERxlLDnlIZJdN66zAPHklyL |17-713-930-5667|x. carefully quiet account | |9651.4 |Supplier#000001099|RUSSIA |23098 |Manufacturer#5|Ttj R 9PUekFZI 3zq |32-784-328-6730| the permanently final foxes. quickly express excuses around the furiously close requests | |9459.29 |Supplier#000000645|GERMANY |34644 |Manufacturer#5|blbALMoy2OihlkvD7FtkLXPvTShY9JVtsWT |17-742-832-9508|accounts. blithely unusual pinto beans at the blithely | |9453.01 |Supplier#000000802|ROMANIA |5797 |Manufacturer#1|,6HYXb4uaHITmtMBj4Ak57Pd |29-342-882-6463|gular frets. permanently special multipliers believe blithely alongs | |9202.57 |Supplier#000000062|ROMANIA |37025 |Manufacturer#5|bSmlFYUKBeRsqJxwC9 zS6xpFdEf5jNTb |29-603-653-2494|ts. furiously ironic pinto beans are permanently after the bold ideas. regular, express f | |9032.15 |Supplier#000000959|GERMANY |4958 |Manufacturer#4|8grA EHBnwOZhO |17-108-642-3106|nding dependencies nag furiou | |8702.02 |Supplier#000000333|RUSSIA |21822 |Manufacturer#5|MaVf XgwPdkiX4nfJGOis8Uu2zKiIZH |32-508-202-6136|oss the deposits cajole carefully even pinto beans. regular foxes detect alo | |8546.98 |Supplier#000001941|FRANCE |28912 |Manufacturer#2|h8VV3OEcSykk |16-316-553-7611|eposits. carefully regular dependencies need to cajo | |7815.06 |Supplier#000000939|UNITED KINGDOM|20428 |Manufacturer#4|mWBKbdzDn3yJNpOT8p |33-487-125-3117|efully. final requests after the unusual requests wake fluffily after the furiously r | |7727.83 |Supplier#000000179|ROMANIA |5174 |Manufacturer#1|d3le3XaTUC |29-560-587-5604|kages solve carefully alongside of the furiously regular patterns. blithe | |7431.0 |Supplier#000000311|RUSSIA |35276 |Manufacturer#3|yjGDnCKi4Wmtim H3n9p |32-445-679-8585|uriously final requests integrate. sheaves against the furiously final accounts are evenly abo | |7384.86 |Supplier#000001140|UNITED KINGDOM|4637 |Manufacturer#5|8y7JNE7iXHBQhVaXtdye5iKZUI |33-927-817-5355|equests. furiously regular deposits after the requests sleep carefully special deposits. qu | |7170.44 |Supplier#000001656|FRANCE |7655 |Manufacturer#2|HPkORETlxwqmcVjpGe1nbuzQ3Zr4R 5,b7Oks |16-238-996-5507|uriously blithely special pinto beans-- ir | |7170.44 |Supplier#000001656|FRANCE |25655 |Manufacturer#2|HPkORETlxwqmcVjpGe1nbuzQ3Zr4R 5,b7Oks |16-238-996-5507|uriously blithely special pinto beans-- ir | |6888.65 |Supplier#000000658|RUSSIA |2156 |Manufacturer#5|kw9Ts9s38tEPf,IKi6kXNEv02 |32-991-641-3699|ular notornis integrate. permanently final accounts wake final | |6864.66 |Supplier#000001750|FRANCE |249 |Manufacturer#4|r5RrPrq7oX2xG2xqhHM6tddxzXX4kAPUtwWvYTcb|16-689-978-9301| fluffily bold packages. even, final foxes na | |6860.29 |Supplier#000001968|FRANCE |28425 |Manufacturer#3|EpUTyZuUEb6YKRCQYhGqrp0WrsSiA |16-140-133-7640|ffix slyly after the slyly special accounts. regular ideas among the fu | |6820.35 |Supplier#000000007|UNITED KINGDOM|26006 |Manufacturer#3|s,4TicNGB4uO6PaSqNBUq |33-990-965-2201|s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit| |6116.81 |Supplier#000000756|GERMANY |21225 |Manufacturer#4|ySXGqbQpYbXLoaFMKqIdH5Pai |17-726-757-7711|out the final, express id | +---------+------------------+--------------+---------+--------------+----------------------------------------+---------------+---------------------------------------------------------------------------------------------------+ # Q3 +----------+------------------+---------------------+--------------+ |L_ORDERKEY|REVENUE |O_ORDERDATE |O_SHIPPRIORITY| +----------+------------------+---------------------+--------------+ |937091 |377225.95195312495|1995-02-22 08:00:00.0|0 | |837895 |357509.50501953124|1995-03-05 08:00:00.0|0 | |303360 |347143.903671875 |1995-03-14 08:00:00.0|0 | |506021 |340592.83578125003|1995-03-10 08:00:00.0|0 | |993600 |331148.8059375 |1995-03-05 08:00:00.0|0 | |474086 |324786.30328125 |1995-03-13 08:00:00.0|0 | |754912 |323646.625649414 |1995-02-14 08:00:00.0|0 | |299973 |322061.84967285156|1995-02-22 08:00:00.0|0 | |389344 |320626.5167089844 |1995-03-13 08:00:00.0|0 | |923942 |317208.96476562496|1995-03-12 08:00:00.0|0 | |928 |314128.618671875 |1995-03-02 08:00:00.0|0 | |453858 |313094.7897363281 |1995-03-10 08:00:00.0|0 | |132774 |311505.6181738281 |1995-02-27 08:00:00.0|0 | |421636 |306851.7415917969 |1995-03-11 08:00:00.0|0 | |820962 |301458.5813671875 |1995-02-11 08:00:00.0|0 | |1197380 |295232.3549609375 |1995-02-16 08:00:00.0|0 | |259840 |293803.2448828125 |1995-01-14 08:00:00.0|0 | |667431 |293795.3109375 |1995-03-14 08:00:00.0|0 | |751681 |293155.7831640625 |1995-02-06 08:00:00.0|0 | |864000 |290941.8272607422 |1995-02-27 08:00:00.0|0 | +----------+------------------+---------------------+--------------+ # Q4 +---------------+-----------+ |O_ORDERPRIORITY|ORDER_COUNT| +---------------+-----------+ |1-URGENT |2068 | |2-HIGH |1981 | |3-MEDIUM |2047 | |4-NOT SPECIFIED|2052 | |5-LOW |2148 | +---------------+-----------+ # Q5 +---------+-------------------+ |N_NAME |REVENUE | +---------+-------------------+ |CHINA |3.895307073709164E7| |VIETNAM |3.398076757233582E7| |INDONESIA|3.379597722636413E7| |INDIA |3.111527966942077E7| |JAPAN |3.048622959725279E7| +---------+-------------------+ # Q6 +------------------+ |REVENUE | +------------------+ |2.35862828993634E7| +------------------+ # Q7 +-----------+-----------+------+--------------------+ |SUPP_NATION|CUST_NATION|L_YEAR|REVENUE | +-----------+-----------+------+--------------------+ |INDIA |JAPAN |1995 |1.0930441890371097E7| |INDIA |JAPAN |1996 |1.1914455194367673E7| |JAPAN |INDIA |1995 |1.010593464946716E7 | |JAPAN |INDIA |1996 |1.0275758783603515E7| +-----------+-----------+------+--------------------+ # Q8 +------+--------------------+ |O_YEAR|MKT_SHARE | +------+--------------------+ |1995 |0.053084962744543135| |1996 |0.05165958432673614 | +------+--------------------+ # Q9 +---------+------+------------------+ |NATION |O_YEAR|SUM_PROFIT | +---------+------+------------------+ |ALGERIA |1998 |5122411.651564941 | |ALGERIA |1997 |9087270.711031495 | |ALGERIA |1996 |8280131.5571911605| |ALGERIA |1995 |9035931.041203003 | |ALGERIA |1994 |8880194.1987854 | |ALGERIA |1993 |8164215.40902832 | |ALGERIA |1992 |9142418.725242918 | |ARGENTINA|1998 |4369300.452207032 | |ARGENTINA|1997 |7914327.636294556 | |ARGENTINA|1996 |8070217.236645508 | |ARGENTINA|1995 |6818752.101572264 | |ARGENTINA|1994 |7972709.372528074 | |ARGENTINA|1993 |8406380.220759278 | |ARGENTINA|1992 |7789221.61597168 | |BRAZIL |1998 |5229376.666762697 | |BRAZIL |1997 |8237865.165096435 | |BRAZIL |1996 |8199901.521447753 | |BRAZIL |1995 |8734470.253615724 | |BRAZIL |1994 |9046301.005001223 | |BRAZIL |1993 |8339716.432081299 | +---------+------+------------------+ # Q10 +---------+------------------+------------------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ |C_CUSTKEY|C_NAME |REVENUE |C_ACCTBAL|N_NAME |C_ADDRESS |C_PHONE |C_COMMENT | +---------+------------------+------------------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ |29755 |Customer#000029755|901.1979272460937 |2454.5 |PERU |nu8if56rKyJbmPjp2uInAw4 |27-550-968-6026|y foxes. ideas boost furiously into the theodolites. unusual requests | |21118 |Customer#000021118|985.0002136230468 |5344.49 |ETHIOPIA |4guHWC1cXrOuUUqGj3BquPxJZoHnOHXC3jBR8H|15-243-256-4341|quickly against the dependencies. blithely express requests sleep. furiousl | |1336 |Customer#000001336|1078.46103515625 |1490.21 |MOZAMBIQUE |E4MeTLnSTIOlWkLDwmG7QPf 9Dq |26-350-110-5043|ts after the deposits are quickly deposits! blithely regular theodolites integrate above the slyly pending | |19607 |Customer#000019607|1100.079052734375 |-289.16 |ETHIOPIA |ytZTeZBWqkoaQrHwXRA07N50m7RDJMH7nD |15-995-418-3724|cajole above the slyly silent deposit | |28882 |Customer#000028882|1154.169609375 |2451.31 |ETHIOPIA |PV9bO5gMpR4VNkEDZF4kYswNmD2iDEvD |15-428-501-5032|ly against the blithely express deposits. ironic frets are furious | |18181 |Customer#000018181|1171.2239868164063|2387.83 |ARGENTINA |4EoqiCT3YeaA575,Dsa8y2bCK7d5 |11-487-506-6164|ons about the slyly bold hockey players nag blithely idly final requests. close, thin hockey players after the bold | |8809 |Customer#000008809|1202.4558044433595|7364.6 |JAPAN |fjPYt1,zMk |22-326-546-2871|ironic pinto beans x-ray fluffily-- slyly regular requests x-ray. | |29246 |Customer#000029246|1217.169030761719 |6874.62 |ETHIOPIA |A3NhvrB8LRcBvyqa9ynoO |15-532-928-4098|fluffily regular depths alongside of the even theodolites are aga | |2725 |Customer#000002725|1265.3276733398438|3206.75 |JAPAN |JNCWZz8RerBgWEnpo193ogF9RrVMSyI |22-415-166-7713|dolphins. carefully final ideas wake. silently ironic accounts cajole slyly. iron | |4435 |Customer#000004435|1270.1180236816406|3151.45 |PERU |Jn4mRWpJltRdodPJ7riAfa7g9QTe8B |27-270-494-1046|uriously final pearls according to the ironic ideas cajole slyly pendin | |3515 |Customer#000003515|1306.1477636718748|2795.86 |INDIA |XyyX9Gb3kUcTGf0xkJbnoicM7hEG |18-466-804-4263|ans. furiously ironic requests use blithely regular ideas. pending platelets across the theodolites detect near the | |8803 |Customer#000008803|1315.7467431640625|2557.36 |GERMANY |sacwkQA7qhJxt,xbRZywTZ0B2aBYbd |17-432-751-8196|thely. regular, express pinto beans above the special foxes wake slyly slyly final packages. i | |9610 |Customer#000009610|1364.866044921875 |9402.91 |ETHIOPIA |l28vM2WqS gf1,l sauoztf9pk,kW9g |15-852-759-4965|ests should boost slyly. blithely | |14626 |Customer#000014626|1441.7199768066405|668.48 |ARGENTINA |QZZbw2f 8GrGBzm8Ch2wj |11-342-750-1407|ckages. deposits sleep slyly blithely pending gifts. furiously silent ins | |4180 |Customer#000004180|1465.5400390625 |5227.9 |SAUDI ARABIA |ynLS1YuKZo8lDC44J1g3wszOAMxgx5UihW |30-367-598-9323|n multipliers sleep blithely. quickly silent instructions use abo | |7850 |Customer#000007850|1469.2699768066404|-395.36 |MOROCCO |R6440s8tiGh3gwW9s9niSxWKXz |25-401-292-1403|ts cajole. slyly final instructions wake carefully final instructions. regular, ironic ideas are. unusual | |13424 |Customer#000013424|1513.0842822265627|9551.8 |MOZAMBIQUE |,Rs70lnEG MjHW1eBRLy FIhbu |26-317-751-5151|ts. slyly bold sentiments alongside of the carefully special requests wake slyly furio | |21230 |Customer#000021230|1566.8174999999999|5649.32 |FRANCE |K7Umul,qNdvUDdPqwdKEbuT3IS |16-942-366-7487|packages are ironic requests. careful | |9265 |Customer#000009265|1571.3698266601564|2547.15 |UNITED KINGDOM|D,BX4fDc 876mLpP |33-262-984-4894|ly final platelets detect carefully quickly regular requests. | |82 |Customer#000000082|1580.5434814453124|9468.34 |CHINA |zhG3EZbap4c992Gj3bK,3Ne,Xn |28-159-442-5305|s wake. bravely regular accounts are furiously. regula | +---------+------------------+------------------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ # Q11 +----------+--------------------+ |PS_PARTKEY|VALUE | +----------+--------------------+ |8391 |1.7366106720000003E7| |3646 |1.6606432559999999E7| |2147 |1.469568222E7 | |12147 |1.33805187E7 | |4628 |1.290117642E7 | |17628 |1.213178657E7 | |30532 |1.200702506E7 | |403 |1.200130451E7 | |29620 |1.187127555E7 | |37145 |1.179672443E7 | |771 |1.1738576700000001E7| |18257 |1.147478419E7 | |38590 |1.1450309870000001E7| |9399 |1.139364634E7 | |32631 |1.135805384E7 | |24084 |1.134257895E7 | |9620 |1.125444834E7 | |18253 |1.121606266E7 | |4157 |1.0997728719999999E7| |7926 |1.0921232899999999E7| +----------+--------------------+ # Q12 +----------+---------------+--------------+ |L_SHIPMODE|HIGH_LINE_COUNT|LOW_LINE_COUNT| +----------+---------------+--------------+ |MAIL |1267 |1860 | |SHIP |1247 |1875 | +----------+---------------+--------------+ # Q13 +-------+--------+ |C_COUNT|CUSTDIST| +-------+--------+ |0 |10001 | |10 |1328 | |9 |1314 | |8 |1223 | |11 |1179 | |12 |1112 | |13 |987 | |7 |934 | |14 |933 | |19 |915 | |18 |915 | |16 |915 | |20 |913 | |17 |865 | |15 |864 | |21 |790 | |22 |730 | |23 |647 | |6 |644 | |24 |541 | +-------+--------+ # Q14 +-----------------+ |PROMO_REVENUE | +-----------------+ |16.83208207576802| +-----------------+ # Q15 TODO # Q16 +--------+-----------------------+------+------------+ |P_BRAND |P_TYPE |P_SIZE|SUPPLIER_CNT| +--------+-----------------------+------+------------+ |Brand#11|ECONOMY ANODIZED BRASS |23 |16 | |Brand#25|PROMO POLISHED COPPER |14 |16 | |Brand#11|LARGE POLISHED COPPER |49 |12 | |Brand#11|SMALL ANODIZED TIN |45 |12 | |Brand#12|PROMO ANODIZED BRASS |45 |12 | |Brand#12|STANDARD ANODIZED BRASS|3 |12 | |Brand#13|ECONOMY PLATED NICKEL |3 |12 | |Brand#14|SMALL ANODIZED NICKEL |45 |12 | |Brand#22|ECONOMY ANODIZED TIN |49 |12 | |Brand#22|SMALL BURNISHED BRASS |19 |12 | |Brand#24|ECONOMY ANODIZED BRASS |19 |12 | |Brand#24|ECONOMY BURNISHED STEEL|45 |12 | |Brand#24|SMALL ANODIZED NICKEL |19 |12 | |Brand#25|MEDIUM BURNISHED TIN |3 |12 | |Brand#25|SMALL BURNISHED STEEL |14 |12 | |Brand#31|LARGE PLATED TIN |14 |12 | |Brand#34|LARGE BURNISHED TIN |49 |12 | |Brand#34|LARGE POLISHED NICKEL |49 |12 | |Brand#35|LARGE ANODIZED NICKEL |3 |12 | |Brand#35|LARGE ANODIZED STEEL |45 |12 | +--------+-----------------------+------+------------+ # Q17 TODO # Q18 +------------------+---------+----------+---------------------+------------+---------------+ |C_NAME |C_CUSTKEY|O_ORDERKEY|O_ORDERDATE |O_TOTALPRICE|sum(L_QUANTITY)| +------------------+---------+----------+---------------------+------------+---------------+ |Customer#000013307|13307 |29158 |1995-10-21 08:00:00.0|460734.37 |305.0 | |Customer#000002452|2452 |735366 |1993-11-24 08:00:00.0|440880.16 |309.0 | |Customer#000028220|28220 |565574 |1995-09-24 08:00:00.0|431713.59 |301.0 | |Customer#000016489|16489 |857959 |1994-02-07 08:00:00.0|428432.11 |305.0 | |Customer#000003550|3550 |6882 |1997-04-09 08:00:00.0|424943.0 |303.0 | |Customer#000003277|3277 |502886 |1994-04-12 08:00:00.0|421670.91 |312.0 | |Customer#000017776|17776 |983201 |1993-12-30 08:00:00.0|396319.81 |304.0 | |Customer#000022627|22627 |967334 |1995-12-15 08:00:00.0|393949.36 |301.0 | |Customer#000022918|22918 |551136 |1993-05-19 08:00:00.0|385794.89 |308.0 | +------------------+---------+----------+---------------------+------------+---------------+ # Q19 +------------------+ |REVENUE | +------------------+ |503605.66920410155| +------------------+ # Q20 +------------------+----------------------------------------+ |S_NAME |S_ADDRESS | +------------------+----------------------------------------+ |Supplier#000000013|HK71HQyWoqRWOX8GI FpgAifW,2PoH | |Supplier#000000157|,mEGorBfVIm | |Supplier#000000197|YC2Acon6kjY3zj3Fbxs2k4Vdf7X0cd2F | |Supplier#000000285|Br7e1nnt1yxrw6ImgpJ7YdhFDjuBf | |Supplier#000000287|7a9SP7qW5Yku5PvSg | |Supplier#000000378|FfbhyCxWvcPrO8ltp9 | |Supplier#000000431|WoeV,NINojE6hJjauAdrl5fGcdxX5JUPLnrim | |Supplier#000000475|xw4V6,4QQW LI5Qg EOKy4JD B4Cq1tjzaOma9Y | |Supplier#000000532|ep92hT7VLaVlDKM7lgbj02kIL | |Supplier#000000555|TfB,a5bfl3Ah 3Z 74GqnNs6zKVGM | |Supplier#000000557|jj0wUYh9K3fG5Jhdhrkuy ,4 | |Supplier#000000640|mvvtlQKsTOsJj5Ihk7,cq | |Supplier#000000710|f19YPvOyb QoYwjKC,oPycpGfieBAcwKJo | |Supplier#000000729|pqck2ppy758TQpZCUAjPvlU55K3QjfL7Bi | |Supplier#000000761|zlSLelQUj2XrvTTFnv7WAcYZGvvMTx882d4 | |Supplier#000000884|bmhEShejaS | |Supplier#000000971|23XaUVLYuC3tQIPHCuLLgM5UawL | |Supplier#000000975|,AC e,tBpNwKb5xMUzeohxlRn, hdZJo73gFQF8y| |Supplier#000000997|7eUWMrOCKCp2JYas6P4mL93eaWIOtKKWtTX | |Supplier#000001245|bztTCfHZnsLafgtZWe,isV Gr 4IFg | +------------------+----------------------------------------+ # Q21 +------------------+-------+ |S_NAME |NUMWAIT| +------------------+-------+ |Supplier#000000436|17 | |Supplier#000000578|17 | |Supplier#000001083|16 | |Supplier#000001435|16 | |Supplier#000001809|16 | |Supplier#000000460|15 | |Supplier#000001393|15 | |Supplier#000000889|14 | |Supplier#000001452|14 | |Supplier#000000427|13 | |Supplier#000000762|13 | |Supplier#000001724|13 | |Supplier#000001916|13 | |Supplier#000000445|12 | |Supplier#000000472|12 | |Supplier#000000500|12 | |Supplier#000000610|12 | |Supplier#000000633|12 | |Supplier#000000648|12 | |Supplier#000000687|12 | +------------------+-------+ # Q22 +---------+-------+------------------+ |CNTRYCODE|NUMCUST|TOTACCTBAL | +---------+-------+------------------+ |20 |190 |1418449.24 | |21 |208 |1565444.149999999 | |22 |195 |1431625.7099999995| |30 |177 |1316538.54 | +---------+-------+------------------+