Ask Your Question

Revision history [back]

I doubt you have set the offset column as 200 instead of the offset column name,Normally where clause and order by expects the offset column name in the query.(When using incremental load)

Example: my offset column is employee_id
select * from employee_table where employee_id>${offset} order by employee_id

I doubt you have set the offset column as 200 instead of the offset column name,Normally name.You can set the initial offset value in the Initial Offset . Normally where clause and order by expects the offset column name in the query.(When using incremental load)

Example: my offset column is employee_id
select * from employee_table where employee_id>${offset} order by employee_id

I doubt you have set the offset column as 200 instead of the offset column name.You can set the initial offset value in the Initial Offset . Normally where clause and order by expects the offset column name in the query.(When using incremental load)

Example: my offset column is employee_id
select * from employee_table where employee_id>${offset} order by employee_id

image description

Refer to: https://streamsets.com/documentation/datacollector/3.4.1/help/datacollector/UserGuide/Origins/JDBCConsumer.html