Overview
Some data sources supported by FineDataLink do not support UPDATE or DELETE operations, causing some FDL functions unusable with such databases, which is embodied in the product design.
Functional Limitation on the Target Database of Scheduled Tasks
The functional limitations vary with the characteristic of target databases of scheduled tasks and are explained in the following table.
Characteristic | Restricted Function | Affected Target Database | Functional Design |
|---|---|---|---|
Do not support the physical primary key. | Auto Created Table > Field Mapping > Physical Primary Key Existing Table > Field Mapping > Primary Key
| Jiandaoyun, Public Data, Hive, and Inceptor Note: Some types of Doris and StarRocks tables are also affected. |  |
Do not support the Not Null constraint. | Auto Created Table > Field Mapping > Not Null
| Jiandaoyun, Public Data, Hive, and Inceptor | |
Do not allow emptying the table. | Write Data into Target Table After Emptying It | Jiandaoyun | / |
Do not support primary key comparison (including physical and logical primary keys). | PK-based mapping: 1. Write Data into Target Table Directly > Strategy for Primary Key Conflict
2. Append/Update/Delete Data Based on Identifier Field > Strategy for Primary Key Conflict
| Hive and Inceptor Note: Some types of Doris and StarRocks tables are also affected. | 1. 2.
|
Previous：Data Sources Supported by FineDataLink
