clickhouse linux安装使用以及Oracle数据库导入

最新推荐文章于 2024-11-16 11:09:40 发布

原创

最新推荐文章于 2024-11-16 11:09:40 发布 · 1.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#clickhouse #oracle #jdbc #安装使用 #数据导入

本文详细介绍了如何在Linux环境下安装ClickHouse，包括YUM安装、配置文件编辑及服务启动。接着展示了使用ClickHouse进行简单查询操作。然后，通过创建表结构和下载相关驱动，演示了从Oracle数据库导入数据到ClickHouse的过程，并解决了字段大小写敏感问题。最后，给出了数据迁移时的注意事项和FAQ。

                    
                        
                    
                    安装 
下载clickhouse
 yum install clickhouse-server clickhouse-client
编辑配置文档
 vi /etc/clickhouse-server/config.xml
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml
su -s /bin/sh 'clickhouse' -c '/usr/bin/clickhouse-server --config-file /etc/clickhouse-server/confi--pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon'[root@izbp15488qcahuq3k0n0qiz ~]# ps -ef | grep clickhouse
clickho+ 17234     1  0 15:23 ?        00:00:00 clickhouse-watchdog        --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid
clickho+ 17235 17234  2 15:23 ?        00:00:02 /usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid
root     17889 14123  0 15:25 pts/0    00:00:00 grep --color=auto clickhouse
 
 
 
简单查询 
/usr/bin/./clickhouse-client 进入客户端[root@izbp15488qcahuq3k0n0qiz ~]# /usr/bin/./clickhouse-client
ClickHouse client version 21.8.4.51 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.8.4 revision 54449.

izbp15488qcahuq3k0n0qiz :) select 1;

SELECT 1

Query id: 62d7634c-c267-44e9-a6bd-734e29d07bfc

┌─1─┐
│ 1 │
└───┘

1 rows in set. Elapsed: 0.003 sec.

izbp15488qcahuq3k0n0qiz :) select version();

SELECT version()

Query id: e1329c81-add7-43d3-b090-207dd34226ca

┌─version()─┐
│ 21.8.4.51 │
└───────────┘

1 rows in set. Elapsed: 0.003 sec.

izbp15488qcahuq3k0n0qiz :) show databases;

SHOW DATABASES

Query id: 79800762-98a2-4e75-9898-566ad5212e29

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

2 rows in set. Elapsed: 0.003 sec.

izbp15488qcahuq3k0n0qiz :) use default ;

USE default

Query id: dc4481c7-6ea9-4cc1-8f68-48c013cb0e45

Ok.

0 rows in set. Elapsed: 0.001 sec.

izbp15488qcahuq3k0n0qiz 

                

最低0.47元/天解锁文章