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

  • 19 October 2021
  • 0 replies

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

This topic has been closed for comments