Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How can I order records in a JDBC query consumer

I select records using a JDBC query consumer and specifically gave an order by clause.

I perform JDBC lookups and stream selector stages downstream.

I tried writing the processed records to a FS and to Kafka, however find that the order I selected the records from, in the first stage(JDBC query consumer) is NOT the order I got writen to the FS or Kafka.

How do I ensure the ordering is preserved at the destination?

Thank you,

How can I order records in a JDBC query consumer

I select records using a JDBC query consumer and specifically gave an order by 'order by' clause.

I perform JDBC lookups and stream selector 'stream selector' stages downstream.

I tried writing the processed records to a FS and to Kafka, however find that the order I selected the records from, in the first stage(JDBC query consumer) is NOT the order I got writen to the FS or Kafka.

How do I ensure the ordering is preserved at the destination?

Thank you,