ClickHouse Data Source
|
Collect
1. Overview
After configuring the ClickHouse data source, you can use Data Fusion > Task Management function to import its data into the divine data table or entity, easy to use in the report, analysis model, intelligent operations and other modules.
Before configuring a data source, please refer to the following to confirm that your ClickHouse data source meets the requirements:
Data Source Type | Data Source Name | Version Requirement | User Permission Requirement | Other Requirements |
---|---|---|---|---|
Database Class | ClickHouse | 23.X version | SELECT Permission | None |
2. Add ClickHouse Data Source
- Select Data Fusion > Universal Data Access > Data Source Management.
- Click All Data Sources Tab page.
- Click ClickHouse data source.
- Click on the top right corner Create button.
- Fill inClickHouse connection information.
- Data Source Connection Name: User-defined by you, is the unique identification of the data source connection in the platform.
- Server : IP address and port for connecting to the data source. In cluster scenarios, you can configure multiple server addresses. Use commas to separate the IP addresses.
- User name: Valid user name for the data source connection.
- Password: Specifies the valid password of the user name, optional.
- Connection parameters:Optional, you can customize the connection parameters of the data source, please use when multiple parameters& to divide, for example: key1=true&key2=false.
- Click Test Connection button.
- Click Submit button.
3. Manage Data Sources
- Select Data Fusion > Universal Data Access > Data Source Management.
- Click Added data source Tab page.
- ClickClickHouse data source.
- Edit: Support modifying all configuration parameters of data connection.
- Delete: Delete the current connection.
If the current data connection is in use by a task, modifying or deleting the connection will cause the task to fail.
4. Mapping rules for data table field types
When importing data from a ClickHouse data source to the Oracle data table, a field type mapping error may result in a content conversion error or a task execution failure. Configure the field mapping according to the following rules, and the data conversion is safe:
Original Field Type | Data Table Field Type |
---|---|
UInt8 | NUMBER / INT / BIGINT |
UInt16 | NUMBER / INT / BIGINT |
UInt32 | NUMBER / BIGINT |
UInt64 | NUMBER / BIGINT |
Int8 | NUMBER / INT / BIGINT |
Int16 | NUMBER / INT / BIGINT |
Int32 | NUMBER / INT / BIGINT |
Int64 | NUMBER / BIGINT |
Float32 | NUMBER |
Float64 | NUMBER |
Decimal | NUMBER |
String | STRING |
FixedString | STRING |
Date | TIMESTAMP |
DateTime | TIMESTAMP |
DateTime64 | TIMESTAMP |
UUID | STRING |
Enum | STRING |
Domain | STRING |
Instructions
- The primitive types mentioned above are currently supported ClickHouse field types
- If a task is imported with an unsupported type field, the task fails to be executed
Note: The content of this document is a technical document that provides details on how to use the Sensors product and does not include sales terms; the specific content of enterprise procurement products and technical services shall be subject to the commercial procurement contract.