Skip to main content
Version: 2.3.1

Clickhouse

Clickhouse source connector

Description​

Used to read data from Clickhouse.

Key features​

supports query SQL and can achieve projection effect.

tip

Reading data from Clickhouse can also be done using JDBC

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)