ClickHouse初探(单点)

软件准备

到https://packagecloud.io/Altinity/clickhouse下载适合自己服务器版本的RPM包

clickhouse-client-18.12.13-1.el6.x86_64.rpm
clickhouse-common-static-18.12.13-1.el6.x86_64.rpm
clickhouse-compressor-1.1.54336-3.el6.x86_64.rpm
clickhouse-debuginfo-18.12.13-1.el6.x86_64.rpm
clickhouse-server-18.12.13-1.el6.x86_64.rpm
clickhouse-server-common-18.12.13-1.el6.x86_64.rpm
clickhouse-test-18.12.13-1.el6.x86_64.rpm
yum -y install openssl unixODBC libicu

rpm -ivh clickhouse-server-common-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-server-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-common-static-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-compressor-1.1.54336-3.el6.x86_64.rpm
rpm -ivh clickhouse-debuginfo-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-client-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-test-18.12.13-1.el6.x86_64.rpm
配置/etc/clickhouse-server/config.xml
配置:
<log>/var/log/clickhouse-server/clickhouse-server.log</log>

<errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
<path>/data/clickhouse/</path>

<tmp_path>/data/clickhouse/tmp/</tmp_path>

<user_files_path>/data/clickhouse/user_files/</user_files_path>

然后把各个目录都赋权给clickhouse
chown -R clickhouse:clickhouse 目录
启动

 /etc/init.d/clickhouse-server start
 
 
[root@test clickhouse-server]# clickhouse-client 
ClickHouse client version 18.12.13.
Connecting to localhost:9000.
Connected to ClickHouse server version 18.12.13 revision 54407.

test :) show databases;

SHOW DATABASES

┌─name────┐
│ default │
│ system  │
└─────────┘

2 rows in set. Elapsed: 0.002 sec. 

test :) use system;

USE system

Ok.

0 rows in set. Elapsed: 0.001 sec. 

test :) show tables;

SHOW TABLES

┌─name───────────────────────────┐
│ aggregate_function_combinators │
│ asynchronous_metrics           │
│ build_options                  │
│ clusters                       │
│ collations                     │
│ columns                        │
│ data_type_families             │
│ databases                      │
│ dictionaries                   │
│ events                         │
│ formats                        │
│ functions                      │
│ graphite_retentions            │
│ macros                         │
│ merge_tree_settings            │
│ merges                         │
│ metrics                        │
│ models                         │
│ mutations                      │
│ numbers                        │
│ numbers_mt                     │
│ one                            │
│ parts                          │
│ parts_columns                  │
│ processes                      │
│ query_thread_log               │
│ replicas                       │
│ replication_queue              │
│ settings                       │
│ table_engines                  │
│ table_functions                │
│ tables                         │
└────────────────────────────────┘

32 rows in set. Elapsed: 0.002 sec. 

test :) desc tables;

DESCRIBE TABLE tables

┌─name───────────────────────┬─type──────────┬─default_type─┬─default_expression─┐
│ database                   │ String        │              │                    │
│ name                       │ String        │              │                    │
│ engine                     │ String        │              │                    │
│ is_temporary               │ UInt8         │              │                    │
│ data_path                  │ String        │              │                    │
│ metadata_path              │ String        │              │                    │
│ metadata_modification_time │ DateTime      │              │                    │
│ dependencies_database      │ Array(String) │              │                    │
│ dependencies_table         │ Array(String) │              │                    │
│ create_table_query         │ String        │              │                    │
│ engine_full                │ String        │              │                    │
└────────────────────────────┴───────────────┴──────────────┴────────────────────┘

11 rows in set. Elapsed: 0.001 sec. 

test :)

单点基本搭建完成

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值