|
Build tested: 1.5.0-1 (drone build #120)
database: dbt3 1mb
query:
select
c_custkey,
c_name,
sum(l_extendedprice * (1 - l_discount)) as revenue,
c_acctbal,
n_name,
c_address,
c_phone,
c_comment
from
customer,
orders,
lineitem,
nation
where
c_custkey = o_custkey
and l_orderkey = o_orderkey
and o_orderdate >= '1994-12-01'
and o_orderdate < date_add( '1994-12-01' , interval 3 month)
and l_returnflag = 'R'
and c_nationkey = n_nationkey
group by
c_custkey,
c_name,
c_acctbal,
c_phone,
n_name,
c_address,
c_comment
order by
revenue desc
LIMIT 20;
ColumnStore returned:
----------------------------------------------------------------------------------------------------+
| c_custkey |
c_name |
revenue |
c_acctbal |
n_name |
c_address |
c_phone |
c_comment |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 95 |
Customer#000000095 |
138209.6028 |
5327.38 |
MOROCCO |
EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 |
25-923-255-2929 |
ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the |
| 113 |
Customer#000000113 |
117107.1886 |
2912.00 |
JAPAN |
eaOl5UBXIvdY57rglaIzqvfPD,MYfK |
22-302-930-4756 |
usly regular theodolites boost furiously doggedly pending instructio |
| 52 |
Customer#000000052 |
94407.0535 |
5630.28 |
IRAQ |
7 QOqGqqSy9jfV51BC71jcHJSD0 |
21-186-284-5998 |
ic platelets use evenly even accounts. stealthy theodolites cajole furiou |
| 124 |
Customer#000000124 |
80480.2608 |
1842.49 |
CHINA |
aTbyVAW5tCd,v09O |
28-183-750-7809 |
le fluffily even dependencies. quietly s |
| 122 |
Customer#000000122 |
53607.8100 |
7865.46 |
CANADA |
yp5slqoNd26lAENZW3a67wSfXA6hTF |
13-702-694-4520 |
the special packages hinder blithely around the permanent requests. bold depos |
| 133 |
Customer#000000133 |
50900.7590 |
2314.67 |
PERU |
IMCuXdpIvdkYO92kgDGuyHgojcUs88p |
27-408-997-8430 |
t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu |
| 139 |
Customer#000000139 |
48305.0910 |
7897.78 |
INDONESIA |
3ElvBwudHKL02732YexGVFVt |
19-140-352-1403 |
nstructions. quickly ironic ideas are carefully. bold, |
| 100 |
Customer#000000100 |
46388.7744 |
9889.89 |
SAUDI ARABIA |
fptUABXcmkC5Wx |
30-749-445-4907 |
was furiously fluffily quiet deposits. silent, pending requests boost against |
| 97 |
Customer#000000097 |
34023.7184 |
2164.48 |
PERU |
OApyejbhJG,0Iw3j rd1M |
27-588-919-5638 |
haggle slyly. bold, special ideas are blithely above the thinly bold theo |
| 88 |
Customer#000000088 |
29371.8645 |
8031.44 |
MOZAMBIQUE |
wtkjBN9eyrFuENSMmMFlJ3e7jE5KXcg |
26-516-273-2566 |
s are quickly above the quickly ironic instructions; even requests about the carefully final deposi |
| 61 |
Customer#000000061 |
21924.4050 |
1536.24 |
PERU |
9kndve4EAJxhg3veF BfXr7AqOsT39o gtqjaYE |
27-626-559-8599 |
egular packages shall have to impress along the |
| 35 |
Customer#000000035 |
13721.6970 |
1228.24 |
PERU |
TEjWGE4nBzJL2 |
27-566-888-7431 |
requests. special, express requests nag slyly furiousl |
| 148 |
Customer#000000148 |
8841.7920 |
2135.60 |
IRAQ |
BhSPlEWGvIJyT9swk vCWE |
21-562-498-6636 |
ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious |
| 91 |
Customer#000000091 |
6407.4458 |
4643.14 |
INDIA |
S8OMYFrpHwoNHaGBeuS6E 6zhHGZiprw1b7 q |
18-239-400-3677 |
onic accounts. fluffily silent pinto beans boost blithely according to the fluffily exp |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.056 sec)
InnoDB returned:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| c_custkey |
c_name |
revenue |
c_acctbal |
n_name |
c_address |
c_phone |
c_comment |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 95 |
Customer#000000095 |
159993.5628 |
5327.38 |
MOROCCO |
EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 |
25-923-255-2929 |
ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the |
| 133 |
Customer#000000133 |
130454.2784 |
2314.67 |
PERU |
IMCuXdpIvdkYO92kgDGuyHgojcUs88p |
27-408-997-8430 |
t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu |
| 49 |
Customer#000000049 |
122242.8362 |
4573.94 |
IRAN |
cNgAeX7Fqrdf7HQN9EwjUa4nxT,68L FKAxzl |
20-908-631-4424 |
nusual foxes! fluffily pending packages maintain to the regular |
| 113 |
Customer#000000113 |
117107.1886 |
2912.00 |
JAPAN |
eaOl5UBXIvdY57rglaIzqvfPD,MYfK |
22-302-930-4756 |
usly regular theodolites boost furiously doggedly pending instructio |
| 115 |
Customer#000000115 |
115503.9282 |
7508.92 |
INDIA |
0WFt1IXENmUT2BgbsB0ShVKJZt0HCBCbFl0aHc |
18-971-699-1843 |
sits haggle above the carefully ironic theodolite |
| 62 |
Customer#000000062 |
111701.0967 |
595.61 |
GERMANY |
upJK2Dnw13, |
17-361-978-7059 |
kly special dolphins. pinto beans are slyly. quickly regular accounts are furiously a |
| 148 |
Customer#000000148 |
105971.4034 |
2135.60 |
IRAQ |
BhSPlEWGvIJyT9swk vCWE |
21-562-498-6636 |
ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious |
| 121 |
Customer#000000121 |
98942.3170 |
6428.32 |
PERU |
tv nCR2YKupGN73mQudO |
27-411-990-2959 |
uriously stealthy ideas. carefully final courts use carefully |
| 52 |
Customer#000000052 |
94407.0535 |
5630.28 |
IRAQ |
7 QOqGqqSy9jfV51BC71jcHJSD0 |
21-186-284-5998 |
ic platelets use evenly even accounts. stealthy theodolites cajole furiou |
| 134 |
Customer#000000134 |
91440.2266 |
4608.90 |
IRAQ |
sUiZ78QCkTQPICKpA9OBzkUp2FM |
21-200-159-5932 |
yly fluffy foxes boost final ideas. b |
| 124 |
Customer#000000124 |
80480.2608 |
1842.49 |
CHINA |
aTbyVAW5tCd,v09O |
28-183-750-7809 |
le fluffily even dependencies. quietly s |
| 89 |
Customer#000000089 |
74578.7108 |
1530.76 |
KENYA |
dtR, y9JQWUO6FoJExyp8whOU |
24-394-451-5404 |
counts are slyly beyond the slyly final accounts. quickly final ideas wake. r |
| 142 |
Customer#000000142 |
73704.2692 |
2209.81 |
INDONESIA |
AnJ5lxtLjioClr2khl9pb8NLxG2, |
19-407-425-2584 |
. even, express theodolites upo |
| 73 |
Customer#000000073 |
68108.4300 |
4288.50 |
ALGERIA |
8IhIxreu4Ug6tt5mog4 |
10-473-439-3214 |
usual, unusual packages sleep busily along the furiou |
| 79 |
Customer#000000079 |
64295.2946 |
5121.28 |
MOROCCO |
n5hH2ftkVRwW8idtD,BmM2 |
25-147-850-4166 |
es. packages haggle furiously. regular, special requests poach after the quickly express ideas. blithely pending re |
| 118 |
Customer#000000118 |
60621.8265 |
3582.37 |
CHINA |
OVnFuHygK9wx3xpg8 |
28-639-943-7051 |
uick packages alongside of the furiously final deposits haggle above the fluffily even foxes. blithely dogged dep |
| 131 |
Customer#000000131 |
60393.0600 |
8595.53 |
IRAQ |
jyN6lAjb1FtH10rMC,XzlWyCBrg75 |
21-840-210-3572 |
jole special packages. furiously final dependencies about the furiously speci |
| 137 |
Customer#000000137 |
59509.9566 |
7838.30 |
MOZAMBIQUE |
cdW91p92rlAEHgJafqYyxf1Q |
26-777-409-5654 |
carefully regular theodolites use. silent dolphins cajo |
| 122 |
Customer#000000122 |
53607.8100 |
7865.46 |
CANADA |
yp5slqoNd26lAENZW3a67wSfXA6hTF |
13-702-694-4520 |
the special packages hinder blithely around the permanent requests. bold depos |
| 139 |
Customer#000000139 |
48305.0910 |
7897.78 |
INDONESIA |
3ElvBwudHKL02732YexGVFVt |
19-140-352-1403 |
nstructions. quickly ironic ideas are carefully. bold, |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
20 rows in set (0.051 sec)
|