From MRS ClickHouse
If the source link of a job is an MRS ClickHouse link, configure the source job parameters based on Table 1.
Category |
Parameter |
Description |
Example Value |
---|---|---|---|
Basic parameters |
Source Link Name |
MRS ClickHouse link |
ck_from_cdm |
Schema/Tablespace |
Click the icon next to the text box to go to the page for selecting a schema or directly enter a schema or tablespace. If the desired schema or tablespace is not displayed, check whether the login account has the permissions required to query metadata.
NOTE:
This parameter can be set to a regular expression to export all databases that meet the rule. |
default |
|
Table Name |
Click the icon next to the text box to go to the page for selecting the table or directly enter a table name. If the desired table is not displayed, check whether the table exists or whether the login account has the permission to query metadata.
NOTE:
This parameter can be set to a regular expression to export all databases that meet the rule. |
TBL_E |
|
Advanced attributes |
WHERE Clause |
This parameter indicates the WHERE clause to be extracted. If this parameter is not set, the entire table is extracted. If the table to be migrated does not contain the fields specified by the WHERE clause, the migration will fail. You can set a date macro variable to extract data generated on a specific date. For details, see Incremental Migration of Relational Databases.
NOTE:
If you have configured a macro variable of date and time and schedule a CDM job through DataArts Studio DataArts Factory, the system replaces the macro variable of date and time with (Planned start time of the data development job – Offset) rather than (Actual start time of the CDM job – Offset). |
age > 18 and age <= 60 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot