search

AlexGruPerm / ora_ch

Data loader from oracle to clickhouse and back.
1 stars 0 forks source link

replace recreate: Int = 0,1 to operation String #9

Closed AlexGruPerm closed 7 months ago

AlexGruPerm commented 9 months ago

Now in this json (one task) we can't make multiple operation on one table, f.e. append data and next update data.

Also table ora_to_ch_tasks_tables has u.k. 

alter table ORA_TO_CH_TASKS_TABLES
  add constraint UK_ORA_TO_CH_TASKS_TABLES unique (ID_TASK, SCHEMA_NAME, TABLE_NAME)

May be change recreate: Int = 0,1 to String parameter "operation" with possible values: recreate, append, update ?

AlexGruPerm commented 7 months ago

Done by issue_21