ClickHouse
What is ClickHouse ?¶
ClickHouse® is a column-oriented database management system (DBMS) for online analytical processing of queries (OLAP). ClickHouse’s performance exceeds all other column-oriented database management systems. It processes billions of rows and tens of gigabytes of data per server per second.
Environment¶
Note
If you need to use this data source, you need to upgrade the DataCap service to >= 1.0.x
Support Time: 2022-09-22
Configure¶
DataCap uses configuration files by default clickhouse.json
Note
If your ClickHouse service version requires other special configurations, please refer to modifying the configuration file and restarting the DataCap service.
| Field | Required | Default Value |
|---|---|---|
Name |
:material-check-circle: | - |
Host |
:material-check-circle: | 127.0.0.1 |
Port |
:material-check-circle: | 9000 |
| Field | Required | Default Value |
|---|---|---|
Username |
:material-close-circle: | - |
Password |
:material-close-circle: | - |
| Field | Required | Default Value |
|---|---|---|
Database |
:material-close-circle: | - |
Note
You can add the already supported ClickHouse parameters by adding Key Value, the parameters can be reference document
Version (Validation)¶
Warning
The online service has not been tested yet, if you have detailed test results, please submit issues to us
- 19.x
- 20.x
- 21.x
Created: January 29, 2023