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.
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
Do not allow emptying the table.
Write Data into Target Table After Emptying It
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
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy