How to set the where filter about sql_last_value?

Elastic Stack Logstash
1

I have been already installed Logstash JDBC Input Plugin successfully.
And I set sql as follows:

select *
from 
	cc
where cc.last_modify_time >= :smile: sql_last_value

I already know the cc.last_modify_time setting is wrong, How can I correct it ?
for another thing, how to set the where filter?

I searched google for long time, but I have no result.

Thank you very much?

2

There's an example here - https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_predefined_parameters

However you config has been mangled, used the </> button to properly format posts.

3

Tks, I already fixed the above bug by add the new column last_modify_time to my table cc, just like:

mysql> alter table cc add column modified_at TIMESTAMP NOT NULL default CURRENT_TIMESTAMP;