sql_last_value
The value used to calculate which rows to query. Before any query is run, this is set to Thursday, 1 January 1970, or 0 if use_column_value
is true and tracking_column
is set. It is updated accordingly after subsequent queries are run.
该值用来计算行的值,在执行任何查询前,这个会被设置为1970年1月1日星期四,如果use_column_value为true并且设置了tracking_column,则为0。 在运行后续查询后,它会相应更新。Example:
input {
jdbc {
statement => "SELECT id, mycolumn1, mycolumn2 FROM my_table WHERE id > :sql_last_value"
use_column_value => true
tracking_column => "id"
# ... other configuration bits
}
}
图艺博知识网