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]

Reply via email to