Ask Your Question
0

JDBC_29 - Query must include '200' in WHERE clause and in ORDER BY clause before other columns.

asked 2018-09-28 22:34:46 -0600

image description

JDBC QUERY CONSUMER

edit retag flag offensive close merge delete

Comments

1

explain your question as the image you posted is not visible

Maithri gravatar imageMaithri ( 2018-09-30 01:31:24 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
1

answered 2018-09-30 01:35:53 -0600

Maithri gravatar image

updated 2018-09-30 01:45:38 -0600

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/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-28 22:34:46 -0600

Seen: 40 times

Last updated: Sep 30