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

Viewed 306

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 Answers
Related