Logstash - JDBC Plugin - __$seqval

Elastic Stack Logstash
1

Hello,

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:
cat /tmp/.logstash_jdbc_last_run
--- 0

Appreciate any suggestions you may have ...

Thanks

2

Pls note the __ in __$seqval got removed from the Select statement and the tracking column when I posted the question

3

I don't have an easy way to quote this, but you should read this. Learn a little bit of markdown if you want help.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.