feiyun123-ok commented on issue #7860:
URL: https://github.com/apache/seatunnel/issues/7860#issuecomment-2419243292
schema_save_mode[Enum]
Before the synchronous task is turned on, different treatment schemes are
selected for the existing surface structure of the target side.
Option introduction:
RECREATE_SCHEMA :Will create when the table does not exist, delete and
rebuild when the table is saved
CREATE_SCHEMA_WHEN_NOT_EXIST :Will Created when the table does not exist,
skipped when the table is saved
ERROR_WHEN_SCHEMA_NOT_EXIST :Error will be reported when the table does not
exist
default value is CREATE_SCHEMA_WHEN_NOT_EXIST
ORACLE test_table DDL
CREATE TABLE T_TEST_PARTITION (
sale_id NUMBER,
product_id NUMBER,
sale_date DATE,
amount NUMBER
)
PARTITION BY RANGE (sale_date) (
PARTITION sales_1 VALUES LESS THAN (TO_DATE('2023-01-01', 'YYYY-MM-DD')),
PARTITION sales_2 VALUES LESS THAN (TO_DATE('2024-01-01', 'YYYY-MM-DD')),
PARTITION sales_3 VALUES LESS THAN (TO_DATE('2025-01-01', 'YYYY-MM-DD')),
PARTITION sales_4 VALUES LESS THAN (TO_DATE('2026-01-01', 'YYYY-MM-DD'))
);
add pk and add data
Oracle CDC did not retrieve metadata, other tables without partitions are
normal
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]