tencent cloud

sh gen-tpch-data.sh -s 100 -c 10

# cat doris-cluster.conf

# Any of FE host
export FE_HOST='127.0.0.1'
# http_port in fe.conf
export FE_HTTP_PORT=8030
# query_port in fe.conf
export FE_QUERY_PORT=9030
# Doris username
export USER='root'
# Doris password
export PASSWORD=''
# The database where TPC-H tables located
export DB='tpch_100g_decimalv3'
# The scale of testing data
export SCALE='100g' # only support '100g' or '1t'

sh create-tpch-tables.sh

sh load-tpch-data.sh


MySQL [tpch100g]> show data;
+-----------+-------------+--------------+
| TableName | Size        | ReplicaCount |
+-----------+-------------+--------------+
| customer  | 1.317 GB    | 24           |
| lineitem  | 20.880 GB   | 96           |
| nation    | 2.571 KB    | 1            |
| orders    | 6.302 GB    | 96           |
| part      | 752.470 MB  | 24           |
| partsupp  | 4.375 GB    | 24           |
| region    | 1.090 KB    | 1            |
| supplier  | 85.528 MB   | 12           |
| Total     | 33.693 GB   | 278          |
| Quota     | 1024.000 TB | 1073741824   |
| Left      | 1023.967 TB | 1073741546   |
+-----------+-------------+--------------+
11 rows in set (0.00 sec)

[root@9 tpch-tools]# sh bin/run-tpch-queries.sh 
q1: 2103
q2: 305
q3: 792
q4: 516
q5: 1036
q6: 60
q7: 493
q8: 954
q9: 4411
q10: 870
q11: 183
q12: 1847
q13: 2886
q14: 165
q15: 255
q16: 398
q17: 520
q18: 1665
q19: 468
q20: 347
q21: 1741
q22: 412
total time: 22427 ms