I am using JDBC input plugin with
use_column_value => true
tracking_column => "id".
But the problem is that my id column is not an incremental all the time. For example it may be as 1,2,3,5,6,7,10,9,8. So what does the file for last_run_metadata_path contain? 8 or 10?
Can someone please help me understand this?