使用版本
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); |