I'm able to connect to a SQL server DB and query a view from a Linux Logstash server. The CDC feature (Change Data Capture) is turned on on the SQL side and I'm trying to use the field __$seqval for :sql_last_value. Although the initial compare is working with a hard coded value but the .logstash_jdbc_last_run file isn't getting updated with the value so the subsequent runs aren't working..
Pls note __$seqval is binary data type and the value looks like 0x0003959B0005DF560004 in SQL Mgmt studio.
Below is the Initial run with the value:
statement => "SELECT [$seqval], [EMP_ID] FROM View_Name where [$seqval] > 0x0003959B0005DF560004 order by [$seqval]"
use_column_value => true
tracking_column => "$seqval"
last_run_metadata_path => "/tmp/.logstash_jdbc_last_run"
The value isn't in the file:
Appreciate any suggestions you may have ...