confluentinc / kafka-connect-jdbc

Kafka Connect connector for JDBC-compatible databases
Other
1.01k stars 953 forks source link

Add mode for incrementing or timestamp #1351

Open nttq1sub opened 12 months ago

nttq1sub commented 12 months ago

Anyone have ideas for a kafka jdbc connector mode is increment OR timestamp both include in one connector?

koaloxixi commented 11 months ago

I guess you means timestamp+incrementing

koaloxixi commented 11 months ago

@luongngochoa

nttq1sub commented 11 months ago

@koaloxixi with the mode you mention above, it generate under query like this

SELECT * from table_name
where ID > $incrementing_offset_val
AND created_at > timestamp

with me it not the mode incrementing or timestamp case, I'm mean to have a connector that query underlying is like

SELECT * from table_name
where ID > $incrementing_offset_val
OR created_at > timestamp