databend_bench_sqls

b.sh

#!/bin/bash

cat << EOF > bench.sql
SELECT avg(number) FROM numbers_mt(100000000000)                                                                
SELECT sum(number) FROM numbers_mt(100000000000)                                                                
SELECT min(number) FROM numbers_mt(100000000000)                                                                
SELECT max(number) FROM numbers_mt(100000000000)                                                                
SELECT count(number) FROM numbers_mt(100000000000)                                                              
SELECT sum(number+number+number) FROM numbers_mt(100000000000)                                                  
SELECT sum(number) / count(number) FROM numbers_mt(100000000000)                                                
SELECT sum(number) / count(number), max(number), min(number) FROM numbers_mt(100000000000)                      
SELECT number FROM numbers_mt(10000000000) ORDER BY number DESC LIMIT 10                                        
SELECT max(number), sum(number) FROM numbers_mt(1000000000) GROUP BY number % 3, number % 4, number % 5 LIMIT 10
EOF


WARMUP=3
RUN=10

export script="hyperfine -w $WARMUP -r $RUN"

script=""
function run() {
        port=$1
        result=$2
        script="hyperfine -w $WARMUP -r $RUN"
        while read SQL; do
                s="clickhouse-client --host 127.0.0.1 --port $port --query=\"$SQL\" "
                script="$script '$s'"
        done <<< $(cat bench.sql)

        script="$script  --export-markdown $result"
        echo $script | bash -x
}


run "9000"  "datavalues2.md"
run "9001"  "main.md"