clickhouse单机读写性能测试（附带运行截图）

使用版本

 

20.10.3.30

云主机配置

 

数据及操作来源

https://clickhouse.tech/docs/zh/getting-started/example-datasets/star-schema/

表类型及数据量

表名	表结构	表定义语句	表数据量
customer		CREATE TABLE customer\ (\ C_CUSTKEY UInt32,\ C_NAME String,\ C_ADDRESS String,\ C_CITY LowCardinality(String),\ C_NATION LowCardinality(String),\ C_REGION LowCardinality(String),\ C_PHONE String,\ C_MKTSEGMENT LowCardinality(String)\ )\ ENGINE = MergeTree ORDER BY (C_CUSTKEY);	30000000
lineorder		CREATE TABLE lineorder\ (\ LO_ORDERKEY UInt32,\ LO_LINENUMBER UInt8,\ LO_CUSTKEY UInt32,\ LO_PARTKEY UInt32,\ LO_SUPPKEY UInt32,\ LO_ORDERDATE Date,\ LO_ORDERPRIORITY LowCardinality(String),\ LO_SHIPPRIORITY UInt8,\ LO_QUANTITY UInt8,\ LO_EXTENDEDPRICE UInt32,\ LO_ORDTOTALPRICE UInt32,\ LO_DISCOUNT UInt8,\ LO_REVENUE UInt32,\ LO_SUPPLYCOST UInt32,\ LO_TAX UInt8,\ LO_COMMITDATE Date,\ LO_SHIPMODE LowCardinality(String)\ )\ ENGINE = MergeTree PARTITION BY toYear(LO_ORDERDATE) ORDER BY (LO_ORDERDATE, LO_ORDERKEY);