Clickhouse

Clickhouse source connector

Description

Used to read data from Clickhouse.

Key features

• [x] batch
• [ ] stream
• [ ] exactly-once
• [x] schema projection

supports query SQL and can achieve projection effect.

• [ ] parallelism
• [ ] support user-defined split

:::tip

Reading data from Clickhouse can also be done using JDBC

:::

Options

name	type	required	default value
host	string	yes	-
database	string	yes	-
sql	string	yes	-
username	string	yes	-
password	string	yes	-
common-options	string	yes	-

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 [string]

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"
  }
  
}