Hi,
When i try to schedule my Elastic engine db update with river schedule by making a my primary key as _id
it works fine with it, it updates the same _id everytime and does not add duplicate records.
i m using river like this :-
{
"type": "jdbc",
"jdbc": {
"driver": "org.postgresql.Driver",
"url": "jdbc:postgresql://localhost:5433/NGP_DB",
"user": "jdbcusr",
"password": "password",
"index": "constituent",
"type": "user",
"sql": "select id AS _id, dtype as dt from ngp.constituent",
"schedule" : "0 0-59 0-23 ? * *"
}
}
But when i try with h2 with same combination , the river keeps on duplicating data in place of updating the same data, river is like this
{
"type": "jdbc",
"jdbc": {
"driver": "org.h2.Driver",
"url": "jdbc:h2:tcp://localhost:9092/cx-h2-admissions",
"user": "jxadmin",
"password": "jxadmin",
"index": "constituent",
"type": "user",
"sql": "select id as _id, fullname , lastname , firstname , middlename , city , st, zip , ctry , ss_no , phone , mail , phone_ext as areaCode from schema.id_rec",
"schedule" : "0 0-59 0-23 ? * *"
}
}
can anybody help.