Updated on 2023-04-28 GMT+08:00

ClickHouse Output

Overview

The ClickHouse Output operator exports existing fields to specified columns of a ClickHouse table.

Input and Output

  • Input: fields to be exported
  • Output: ClickHouse table

Parameters

Table 1 Operator parameters

Parameter

Description

Type

Mandatory

Default Value

ClickHouse database name

Database where the ClickHouse table is located.

string

Yes

default

ClickHouse table name

Name of the ClickHouse table to which data is written.

string

Yes

None

Data Processing Rule

The field values are exported to the ClickHouse table.

Example

Use the CSV File Input operator to generate 12 fields.

The following figure shows the source file.

Run the following statements to create a ClickHouse table:

CREATE TABLE IF NOT EXISTS testck4 ON CLUSTER default_cluster(

a Int32,

b VARCHAR(100) NOT NULL,

c char(100),

d DateTime,

e DateTime,

f DateTime,

g smallint,

h bigint,

l Float32,

j Float64,

k decimal(10,2),

m boolean

)

ENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/default/testck4', '{replica}')

PARTITION BY toYYYYMM(d)ORDER BY a;

Configure the ClickHouse Output operator, as shown in the following figure.

After the job execution is complete, view the data in the testck4 table.