Hello ,
i just import my data from my mssql server to ES.
now i am trying to use the the sql_last_value options ,but its not working.
i have a column in my table "myDate", so i want when i update it , iget the updated data to ES!
input {
jdbc {
jdbc_connection_string => "jdbc:sqlserver://localhost:53140;instanceName=SQLEXPRESS;databaseName=db1"
jdbc_user => "root"
jdbc_password => "root"
jdbc_driver_library => "D:\ES\sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
statement => "select * from dbo.testtable where myDate > :sql_last_value"
schedule => "* * * * *"
use_column_value => true
tracking_column => mydate
}
}
filter {
}
output {
stdout { codec => json_lines }
elasticsearch {
#protocol => http
index => "homindex"
document_type => "homdata"
document_id => "%{personid}"
hosts => "localhost"
}
and my document :
Thank you in advance