跳到主要内容
版本:2.3.2

Clickhouse

Clickhouse source connector

Description

Used to read data from Clickhouse.

Key features

supports query SQL and can achieve projection effect.

Options

nametyperequireddefault value
hoststringyes-
databasestringyes-
sqlstringyes-
usernamestringyes-
passwordstringyes-
common-optionsno-

host [string]

ClickHouse cluster address, the format is host:port , allowing multiple hosts to be specified. Such as "host1:8123,host2:8123" .

database [string]

The ClickHouse database

sql [string]

The query sql used to search data though Clickhouse server

username [string]

ClickHouse user username

password [string]

ClickHouse user password

common options

Source plugin common parameters, please refer to Source Common Options for details

Examples

source {

Clickhouse {
host = "localhost:8123"
database = "default"
sql = "select * from test where age = 20 limit 100"
username = "default"
password = ""
result_table_name = "test"
}

}

Changelog

2.2.0-beta 2022-09-26

  • Add ClickHouse Source Connector

2.3.0-beta 2022-10-20

  • [Improve] Clickhouse Source random use host when config multi-host (3108)

next version

  • [Improve] Clickhouse Source support nest type and array type(3047)

  • [Improve] Clickhouse Source support geo type(3141)