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

  • 19 October 2021
  • 0 replies
  • 209 views

Userlevel 1
  • 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.


0 replies

Be the first to reply!

Reply