#头条创作挑战赛#

客户端命令行参数

我们可以通过clickhouse client来连接启动的clickhouse服务，连接服务时，我们可以指定以下参数，这里指定的参数会覆盖默认值和配置文件中的配置。

• --host，-h:

使用-h指定ip或者host名称时，需要在
/etc/clickhouse-server/config.xml配置文件中114行配置：:: ，代表可以任意ip可访问。配置完成后需要重启当期clickhouse节点生效。

clickhouse-client  -h node1

ClickHouse client version 20.8.3.18.

Connecting to node1:9000 as user default.

Connected to ClickHouse server version 20.8.3 revision 54438.

node1 :)

• --query，-q

clickhouse-client -q "show databases"

_temporary_and_external_tables

default

system

• --database, -d:

clickhouse-client -d "system" -q "show tables"

aggregate_function_combinators

asynchronous_metric_log

asynchronous_metrics

build_options

... ....

• --multiline, -m:

clickhouse-client -m

ClickHouse client version 20.8.3.18.

Connecting to localhost:9000 as user default.

Connected to ClickHouse server version 20.8.3 revision 54438.



node1 :) select

:-] 1+1

:-] ;



SELECT 1 + 1

┌─plus(1, 1)─┐

│          2 │

└────────────┘

1 rows in set. Elapsed: 0.004 sec.

• --time, -t:

clickhouse-client -t -q "show databases"

_temporary_and_external_tables

default

system

0.004

• --stacktrace:

clickhouse-client --stacktrace

ClickHouse client version 20.8.3.18.

Connecting to localhost:9000 as user default.

Connected to ClickHouse server version 20.8.3 revision 54438.



node1 :) use aaa;

USE aaa

Received exception from server (version 20.8.3):

Code: 81. DB::Exception: Received from localhost:9000. DB::Exception: Database aaa doesn't exist. Stack trace:

Poco::Exception::Exception(std::__1 ... ....
... ....

• --multiquery，-n

[root@node1 ~]# clickhouse-client  -n -q "show databases;use default;"

_temporary_and_external_tables

default

system