How do I give the specified table name to "tracking_column"?

[xizhimen]

For all general issues, please provide the following details for fast resolution:

• Version: logstash 5.6.14
• Operating System: centos 7
• Config File:

  jdbc {
  jdbc_driver_library => "/home/logstashtest/lib/mysql-connector-java-5.1.47/mysql-connector-java-5.1.47-bin.jar"
  jdbc_driver_class => "com.mysql.jdbc.Driver"
  jdbc_connection_string => "jdbc:mysql://192.168.0.1/test"
  jdbc_user => "username"
  jdbc_password => "password"
  schedule => "* * * * *"
  record_last_run => true
  use_column_value => true
  tracking_column => "clock"
  tracking_column_type => numeric
  last_run_metadata_path => "/home/logstashtest/clock"
  statement => "select from_unixtime(history.clock) as timestamp,hosts.hostid as hostid,hosts.host as host,items.key_ as keyword ,history.value as value  from history,items,hosts where items.itemid=history.itemid and items.hostid=hosts.hostid and clock  > :sql_last_value"

  The history table include clock(numeric) column,when i run logstash ,I get the following warn message: [2019-01-28T17:08:00,058][WARN ][logstash.inputs.jdbc ] tracking_column not found in dataset. {:tracking_column=>"clock"}

and the "/home/logstashtest/clock" not update,The logs has been repeated

I made the following attempt: tracking_column => "clock" tracking_column => "history.clock" tracking_column => "[history][clock]"

so, how do I give the specified table name to "tracking_column"?

[panpetedextra]

tracking_column use the field that return from your query. So I think you should use "timestamp", referred to this statement select from_unixtime(history.clock) as **timestamp**

[luizhsalazar]

I have the same issue in my script :( Asked all over around and can't find a way to specify table name to tracking_column