Docker安裝ClickHouse并初始化數(shù)據(jù)測(cè)試

clickhouse簡(jiǎn)介

創(chuàng)新互聯(lián)公司是一家專注于網(wǎng)站設(shè)計(jì)制作、網(wǎng)站制作與策劃設(shè)計(jì),元謀網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)公司做網(wǎng)站,專注于網(wǎng)站建設(shè)10年,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:元謀等地區(qū)。元謀做網(wǎng)站價(jià)格咨詢:18980820575

ClickHouse是一個(gè)面向列存儲(chǔ)的數(shù)據(jù)庫(kù)管理系統(tǒng)，可以使用SQL查詢實(shí)時(shí)生成分析數(shù)據(jù)報(bào)告，主要用于OLAP(在線分析處理查詢)場(chǎng)景。關(guān)于clickhouse原理以及基礎(chǔ)知識(shí)在以后學(xué)習(xí)中慢慢總結(jié)。

1、Docker安裝ClickHouse

docker run -d --name some-clickhouse-server \-p 8123:8123 -p 9009:9009 -p 9091:9000 \--ulimit nofile=262144:262144 \-v /home/clickhouse:/var/lib/clickhouse \yandex/clickhouse-server

2、下載SSBM工具

1、git clone https://github.com/vadimtk/ssb-dbgen.git2、cd ssb-dbgen3、make

3、生成數(shù)據(jù)

./dbgen -s 100 -T c./dbgen -s 100 -T p./dbgen -s 100 -T s./dbgen -s 100 -T l./dbgen -s 100 -T d

查看下數(shù)據(jù)

4、建表

CREATE TABLE default.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);CREATE TABLE default.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);CREATE TABLE default.part( P_PARTKEY UInt32, P_NAME String, P_MFGR LowCardinality(String), P_CATEGORY LowCardinality(String), P_BRAND LowCardinality(String), P_COLOR LowCardinality(String), P_TYPE LowCardinality(String), P_SIZE UInt8, P_CONTAINER LowCardinality(String))ENGINE = MergeTree ORDER BY P_PARTKEY;CREATE TABLE default.supplier( S_SUPPKEY UInt32, S_NAME String, S_ADDRESS String, S_CITY LowCardinality(String), S_NATION LowCardinality(String), S_REGION LowCardinality(String), S_PHONE String)ENGINE = MergeTree ORDER BY S_SUPPKEY;

5、導(dǎo)入數(shù)據(jù)

準(zhǔn)備工作：
先把ssb-dbgen(lineorder.tbl,customer.tbl,part.tbl,supplier.tbl)考到clickhouse-server容器里面

clickhouse-client --query "INSERT INTO customer FORMAT CSV" < customer.tblclickhouse-client --query "INSERT INTO part FORMAT CSV" < part.tblclickhouse-client --query "INSERT INTO supplier FORMAT CSV" < supplier.tblclickhouse-client --query "INSERT INTO lineorder FORMAT CSV" < lineorder.tbl

注意：如果此處報(bào)錯(cuò)，檢查clickhouse的配置（端口是否占用，是否設(shè)置用戶和密碼）

6、測(cè)試

官網(wǎng)參考：
https://clickhouse.tech/docs/zh/getting-started/example-datasets/star-schema/#star-schema-benchmark

以上就是Docker創(chuàng)建ClickHouse 并初始化數(shù)據(jù)測(cè)試的詳細(xì)內(nèi)容，更多關(guān)于Docker的資料請(qǐng)關(guān)注腳本之家其它相關(guān)文章！

本文題目：Docker安裝ClickHouse并初始化數(shù)據(jù)測(cè)試
本文路徑：http://m.jiaotiyi.com/article/iogsps.html