Incremental updates using the river plugin

In order to get the incremental updates form the db, the river query has
the following timestamp attribute.

"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "",
"password" : "",
"sql" : [
"statement" : "select * from "products" where "mytimestamp" > ?",
"parameter" : [ "$river.state.last_active_begin" ]
"index" : "my_jdbc_river_index",
"type" : "my_jdbc_river_type"

Do I need to have a "mytimestamp" column in my db with the value as time of the insert of that particular row? Or is this a predefined attribute in elasticsearch?

Thank you.

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
For more options, visit