Skip to main content

JDBC_29 - Query must include (column) in WHERE clause and in ORDER BY clause before other columns.

  • October 19, 2021
  • 0 replies
  • 228 views

  • StreamSets Employee
  • 3 replies

In JDBC Query Consumer, in Incremental mode, this error indicates that the specified column name must be included in the WHERE clause and it must also be included in the ORDER BY clause.  In the ORDER BY clause it should be the first column specified, so that it is the column that sets the order for the returned rows.

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply