Jdbc Kafka connector: How to perform query with OR operator and incrementing column?

Jdbc Kafka connector: How to perform query with OR operator and incrementing column?,jdbc,apache-kafka,apache-kafka-connect,confluent-platform,Jdbc,Apache Kafka,Apache Kafka Connect,Confluent Platform,I am using kafka connect to source data from Oracle db to Kafka topic. I want to fetch data from one table based on increasing id or status column, like SQL statement: SELECT * from TABLE_X where ID > Y or STATUS = 'Z'; Is there any possibility to combine these two or conditions with using incrementing.column.name connector property?

I am using kafka connect to source data from Oracle db to Kafka topic. I want to fetch data from one table based on increasing id or status column, like SQL statement:

SELECT * from TABLE_X where ID > Y or STATUS = 'Z';

Is there any possibility to combine these two

or
conditions with using
incrementing.column.name
connector property?


#1

You can try to use query-based ingest using query property and combine it with incrementing mode.

Source: Kafka Connect Deep Dive – JDBC Source Connector by Robin Moffatt