Yeah ( The best solution for me here would be loading the data in 3 steps:
1) SELECT id as _id, * FROM movies 2) SELECT mp.movie_id as _id, p.name FROM persons p JOIN movies_persons mp ON mp.person_id = p.id 3) SELECT mt.movie_id as _id, t.value FROM tags t JOIN movies_tags mt ON mt.tag_id = t.id but with updating/merging instead of rewriting. It could be achieved using unique "_id" key. Isn't that possible with ES? I think it would be an interesting option for the next versions of the plugin. -- View this message in context: http://elasticsearch-users.115913.n3.nabble.com/MySQL-JDBC-river-indexing-large-arrays-tp4069168p4069184.html Sent from the ElasticSearch Users mailing list archive at Nabble.com. -- 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 elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1421414457784-4069184.post%40n3.nabble.com. For more options, visit https://groups.google.com/d/optout.