Support for partial updates

[timeu]

I am indexing some tables from a postgresql database.
One document that maps to a specific table contains a nested document that is not populated by the jdbc-river but added at a later point via the update API from a different datasource (filesystem)

When the jdb-river runs again the entire document is overwritten and the nested documents are lost.
Is there anyway to support partial updates via the jdbc-river ? I don't think the table strategy can help because also with the table strategy the document is overwritten

[dqduc]

Yes it's good if we have an option like "partial_update = true" in strategies, and the river should "update/override" only fields returned by sql query.

[jprante]

It is not possible to merge partial SQL row data into ES JSON documents.

[lebowitz]

see my repo https://github.com/NGPVAN/dnorml‎

[dqduc]

Since ES support update API now, I think it's possible. Will try to find out how to integrate it

[jprante]

ES update API doesn't help, it's the method how JSON is constructed by SQL column names.

[jprante]

Partial updates are still considered as a feature for future versions.