clickhouse benchmark

keepalive.sh

#!/bin/bash
input="test.sql"
curl_config="/tmp/curl_config_file.txt"

echo > $curl_config
while IFS= read -r line
do
    echo "next" >> $curl_config
    echo "url=http://192.168.1.129:8123/?user=test&password=test&default_format=Null" >> $curl_config
    echo "data=\"${line}\""  >> $curl_config
done < "${input}"

curl -K $curl_config

multiquery.sh

#!/bin/bash

cat test.sql | curl -H 'Multi-Query: true'  -sSg 'http://192.168.1.129:8123/?user=test&password=test' -d @-

nokeepalive.sh

#!/bin/bash
input="test.sql"

while IFS= read -r line
do
    echo "${line}" | curl --no-keepalive -sSg 'http://192.168.1.129:8123/?user=test&password=test' -d @-
done < "${input}"

test.sql

drop table if exists test.sequence_test;
drop table if exists test.sequence_updated;
create table test.sequence_test(x Integer, y Integer, z Integer) Engine=Memory;
insert into test.sequence_test select a.number as x, b.number as y, 1 as z from numbers(100) a cross join numbers(1000) b;
create table test.sequence_updated(x Integer, y Integer, z Integer) Engine=Memory;
insert into test.sequence_updated select x, y, z from test.sequence_test where x = 0;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  1 and b.x =  0;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  2 and b.x =  1;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  3 and b.x =  2;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  4 and b.x =  3;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  5 and b.x =  4;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  6 and b.x =  5;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  7 and b.x =  6;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  8 and b.x =  7;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x =  9 and b.x =  8;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 10 and b.x =  9;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 11 and b.x = 10;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 12 and b.x = 11;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 13 and b.x = 12;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 14 and b.x = 13;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 15 and b.x = 14;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 16 and b.x = 15;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 17 and b.x = 16;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 18 and b.x = 17;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 19 and b.x = 18;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 20 and b.x = 19;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 21 and b.x = 20;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 22 and b.x = 21;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 23 and b.x = 22;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 24 and b.x = 23;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 25 and b.x = 24;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 26 and b.x = 25;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 27 and b.x = 26;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 28 and b.x = 27;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 29 and b.x = 28;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 30 and b.x = 29;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 31 and b.x = 30;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 32 and b.x = 31;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 33 and b.x = 32;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 34 and b.x = 33;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 35 and b.x = 34;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 36 and b.x = 35;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 37 and b.x = 36;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 38 and b.x = 37;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 39 and b.x = 38;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 40 and b.x = 39;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 41 and b.x = 40;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 42 and b.x = 41;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 43 and b.x = 42;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 44 and b.x = 43;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 45 and b.x = 44;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 46 and b.x = 45;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 47 and b.x = 46;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 48 and b.x = 47;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 49 and b.x = 48;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 50 and b.x = 49;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 51 and b.x = 50;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 52 and b.x = 51;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 53 and b.x = 52;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 54 and b.x = 53;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 55 and b.x = 54;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 56 and b.x = 55;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 57 and b.x = 56;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 58 and b.x = 57;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 59 and b.x = 58;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 60 and b.x = 59;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 61 and b.x = 60;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 62 and b.x = 61;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 63 and b.x = 62;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 64 and b.x = 63;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 65 and b.x = 64;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 66 and b.x = 65;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 67 and b.x = 66;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 68 and b.x = 67;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 69 and b.x = 68;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 70 and b.x = 69;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 71 and b.x = 70;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 72 and b.x = 71;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 73 and b.x = 72;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 74 and b.x = 73;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 75 and b.x = 74;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 76 and b.x = 75;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 77 and b.x = 76;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 78 and b.x = 77;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 79 and b.x = 78;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 80 and b.x = 79;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 81 and b.x = 80;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 82 and b.x = 81;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 83 and b.x = 82;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 84 and b.x = 83;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 85 and b.x = 84;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 86 and b.x = 85;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 87 and b.x = 86;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 88 and b.x = 87;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 89 and b.x = 88;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 90 and b.x = 89;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 91 and b.x = 90;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 92 and b.x = 91;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 93 and b.x = 92;
insert into test.sequence_updated select a.x as x , a.y as y, a.z + b.z from test.sequence_test a any left join test.sequence_updated b using(y) where a.x = 94 and b.x = 93;