# 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.00 |10733757363.85|10195830091.4455|10603894434.223462|25.542088|36264.531526|0.050100|295985 | |N |F |195505.00 |276306618.49 |262556145.4490 |272961280.382985 |25.281909|35730.844238|0.049735|7733 | |N |O |14897242.00|21148613488.82|20090504332.4338|20894734378.877690|25.533416|36248.075622|0.050051|583441 | |R |F |7549344.00 |10721462145.45|10185802445.3386|10593360066.262245|25.522216|36246.258880|0.050047|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.40 |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.00 |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.9470|1995-02-22 |0 | |837895 |357509.5058|1995-03-05 |0 | |303360 |347143.9051|1995-03-14 |0 | |506021 |340592.8338|1995-03-10 |0 | |993600 |331148.8062|1995-03-05 |0 | |474086 |324786.3051|1995-03-13 |0 | |754912 |323646.6325|1995-02-14 |0 | |299973 |322061.8479|1995-02-22 |0 | |389344 |320626.5166|1995-03-13 |0 | |923942 |317208.9657|1995-03-12 |0 | |928 |314128.6167|1995-03-02 |0 | |453858 |313094.7897|1995-03-10 |0 | |132774 |311505.6171|1995-02-27 |0 | |421636 |306851.7376|1995-03-11 |0 | |820962 |301458.5795|1995-02-11 |0 | |1197380 |295232.3520|1995-02-16 |0 | |259840 |293803.2462|1995-01-14 |0 | |667431 |293795.3108|1995-03-14 |0 | |751681 |293155.7882|1995-02-06 |0 | |864000 |290941.8284|1995-02-27 |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 |38953070.7744| |VIETNAM |33980767.5434| |INDONESIA|33795977.2025| |INDIA |31115279.6571| |JAPAN |30486229.5231| +---------+-------------+ # Q6 +-------------+ |REVENUE | +-------------+ |23586282.8967| +-------------+ # Q7 +-----------+-----------+------+-------------+ |SUPP_NATION|CUST_NATION|L_YEAR|REVENUE | +-----------+-----------+------+-------------+ |INDIA |JAPAN |1995 |10930441.8861| |INDIA |JAPAN |1996 |11914455.2144| |JAPAN |INDIA |1995 |10105934.6354| |JAPAN |INDIA |1996 |10275758.7869| +-----------+-----------+------+-------------+ # Q8 +------+---------+ |O_YEAR|MKT_SHARE| +------+---------+ |1995 |0.053085 | |1996 |0.051660 | +------+---------+ # Q9 +---------+------+------------+ |NATION |O_YEAR|SUM_PROFIT | +---------+------+------------+ |ALGERIA |1998 |5122411.6569| |ALGERIA |1997 |9087270.7119| |ALGERIA |1996 |8280131.5290| |ALGERIA |1995 |9035931.0630| |ALGERIA |1994 |8880194.2245| |ALGERIA |1993 |8164215.3819| |ALGERIA |1992 |9142418.7325| |ARGENTINA|1998 |4369300.4432| |ARGENTINA|1997 |7914327.5925| |ARGENTINA|1996 |8070217.2210| |ARGENTINA|1995 |6818752.1457| |ARGENTINA|1994 |7972709.3438| |ARGENTINA|1993 |8406380.2320| |ARGENTINA|1992 |7789221.6032| |BRAZIL |1998 |5229376.6632| |BRAZIL |1997 |8237865.1346| |BRAZIL |1996 |8199901.5171| |BRAZIL |1995 |8734470.2715| |BRAZIL |1994 |9046301.0121| |BRAZIL |1993 |8339716.4428| +---------+------+------------+ # Q10 +---------+------------------+---------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ |C_CUSTKEY|C_NAME |REVENUE |C_ACCTBAL|N_NAME |C_ADDRESS |C_PHONE |C_COMMENT | +---------+------------------+---------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ |29755 |Customer#000029755|901.1979 |2454.50 |PERU |nu8if56rKyJbmPjp2uInAw4 |27-550-968-6026|y foxes. ideas boost furiously into the theodolites. unusual requests | |21118 |Customer#000021118|985.0002 |5344.49 |ETHIOPIA |4guHWC1cXrOuUUqGj3BquPxJZoHnOHXC3jBR8H|15-243-256-4341|quickly against the dependencies. blithely express requests sleep. furiousl | |1336 |Customer#000001336|1078.4610|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.0790|-289.16 |ETHIOPIA |ytZTeZBWqkoaQrHwXRA07N50m7RDJMH7nD |15-995-418-3724|cajole above the slyly silent deposit | |28882 |Customer#000028882|1154.1696|2451.31 |ETHIOPIA |PV9bO5gMpR4VNkEDZF4kYswNmD2iDEvD |15-428-501-5032|ly against the blithely express deposits. ironic frets are furious | |18181 |Customer#000018181|1171.2240|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.4558|7364.60 |JAPAN |fjPYt1,zMk |22-326-546-2871|ironic pinto beans x-ray fluffily-- slyly regular requests x-ray. | |29246 |Customer#000029246|1217.1690|6874.62 |ETHIOPIA |A3NhvrB8LRcBvyqa9ynoO |15-532-928-4098|fluffily regular depths alongside of the even theodolites are aga | |2725 |Customer#000002725|1265.3277|3206.75 |JAPAN |JNCWZz8RerBgWEnpo193ogF9RrVMSyI |22-415-166-7713|dolphins. carefully final ideas wake. silently ironic accounts cajole slyly. iron | |4435 |Customer#000004435|1270.1180|3151.45 |PERU |Jn4mRWpJltRdodPJ7riAfa7g9QTe8B |27-270-494-1046|uriously final pearls according to the ironic ideas cajole slyly pendin | |3515 |Customer#000003515|1306.1478|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.7468|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.8660|9402.91 |ETHIOPIA |l28vM2WqS gf1,l sauoztf9pk,kW9g |15-852-759-4965|ests should boost slyly. blithely | |14626 |Customer#000014626|1441.7200|668.48 |ARGENTINA |QZZbw2f 8GrGBzm8Ch2wj |11-342-750-1407|ckages. deposits sleep slyly blithely pending gifts. furiously silent ins | |4180 |Customer#000004180|1465.5400|5227.90 |SAUDI ARABIA |ynLS1YuKZo8lDC44J1g3wszOAMxgx5UihW |30-367-598-9323|n multipliers sleep blithely. quickly silent instructions use abo | |7850 |Customer#000007850|1469.2700|-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.0843|9551.80 |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.8175|5649.32 |FRANCE |K7Umul,qNdvUDdPqwdKEbuT3IS |16-942-366-7487|packages are ironic requests. careful | |9265 |Customer#000009265|1571.3698|2547.15 |UNITED KINGDOM|D,BX4fDc 876mLpP |33-262-984-4894|ly final platelets detect carefully quickly regular requests. | |82 |Customer#000000082|1580.5435|9468.34 |CHINA |zhG3EZbap4c992Gj3bK,3Ne,Xn |28-159-442-5305|s wake. bravely regular accounts are furiously. regula | +---------+------------------+---------+---------+--------------+--------------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------+ # Q11 +----------+-----------+ |PS_PARTKEY|VALUE | +----------+-----------+ |8391 |17366106.72| |3646 |16606432.56| |2147 |14695682.22| |12147 |13380518.70| |4628 |12901176.42| |17628 |12131786.57| |30532 |12007025.06| |403 |12001304.51| |29620 |11871275.55| |37145 |11796724.43| |771 |11738576.70| |18257 |11474784.19| |38590 |11450309.87| |9399 |11393646.34| |32631 |11358053.84| |24084 |11342578.95| |9620 |11254448.34| |18253 |11216062.66| |4157 |10997728.72| |7926 |10921232.90| +----------+-----------+ # 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.832082 | +-------------+ # Q15 +---------+------------------+-----------------+---------------+-------------+ |S_SUPPKEY|S_NAME |S_ADDRESS |S_PHONE |TOTAL_REVENUE| +---------+------------------+-----------------+---------------+-------------+ |1828 |Supplier#000001828|mUsKWGSmdFwgQLp4Q|25-884-510-9495|1696230.5714 | +---------+------------------+-----------------+---------------+-------------+ # 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 +------------+ |AVG_YEARLY | +------------+ |52924.490000| +------------+ # Q18 +------------------+---------+----------+-----------+------------+---------------+ |C_NAME |C_CUSTKEY|O_ORDERKEY|O_ORDERDATE|O_TOTALPRICE|sum(L_QUANTITY)| +------------------+---------+----------+-----------+------------+---------------+ |Customer#000013307|13307 |29158 |1995-10-21 |460734.37 |305.00 | |Customer#000002452|2452 |735366 |1993-11-24 |440880.16 |309.00 | |Customer#000028220|28220 |565574 |1995-09-24 |431713.59 |301.00 | |Customer#000016489|16489 |857959 |1994-02-07 |428432.11 |305.00 | |Customer#000003550|3550 |6882 |1997-04-09 |424943.00 |303.00 | |Customer#000003277|3277 |502886 |1994-04-12 |421670.91 |312.00 | |Customer#000017776|17776 |983201 |1993-12-30 |396319.81 |304.00 | |Customer#000022627|22627 |967334 |1995-12-15 |393949.36 |301.00 | |Customer#000022918|22918 |551136 |1993-05-19 |385794.89 |308.00 | +------------------+---------+----------+-----------+------------+---------------+ # Q19 +-----------+ |REVENUE | +-----------+ |503605.6686| +-----------+ # 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.15| |22 |195 |1431625.71| |30 |177 |1316538.54| +---------+-------+----------+