linux上终端连接clickhouse命令行

1.查看clickhouse的安装目录

#ps aux | grep clickhouse

找到clickhouse的安装目录

2.进入有clickhouse-client的目录

cd /home/clickhouse/software/clickhouse-20.3.8.60/bin/

3.登录

./clickhouse-client -u admin --password XXX

4.选择库

use database;

5.操作

select * from aaa;