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

最新推荐文章于 2024-08-05 21:57:23 发布

Aiky哇

最新推荐文章于 2024-08-05 21:57:23 发布

阅读量4.8k

点赞数 3

分类专栏： clickhouse 测试调研文章标签：数据仓库

Aiky哇

本文链接：https://blog.csdn.net/qq_35423190/article/details/109714866

版权

本文对ClickHouse 20.10.3.30版本进行了单机读写性能测试。使用了特定的云主机配置和数据仓库示例数据集，发现虽然查询SQL语句执行时间较长，特别是在多表联合查询时，但ClickHouse并未进行语句优化。测试结果显示，ClickHouse在单表查询上的性能优于多表联合查询。

摘要由CSDN通过智能技术生成

使用版本

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_ORDER

表名

表结构

表定义语句

表数据量

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_ORDER