I'm trying to load some tables from a relational database into ES 2.0 using logstash. I've created the apropriate mappings in ES to reflect the relationships between the tables (basically one is the parent with the other two pointing to it using _parent)
Reading the tables with Logstash is no problem using JDBC, creating the the proper parent-child relationships, however, is. It appears that the Elasticsearch output plugin lacks the ability to properly pass along the parent-id field to the _parent field in ES. In analogy to the "document_id" or "routing" parameters, I would expect to be able to use a "parent" parameter, to which I can pass the value of the parent-id from the database table I'm reading in input.
I've been crawling up and down the web to find a workaround. Even though I found lots of suggestions, none of them seem to work with ES 2.0 anymore (including adding the _parent field using filter/mutate/add_field etc.).
Is there any hope for this parameter to be available anytime soon?