Jdbc river nested json object - split on delimeters!


(Eric Sims) #1

so, i've got a table structure in sql for my 'movies' db that has some of
the columns with comma-delimited data.

for example:

sql server table pseudo-structure: [column : row data]
movieid: 1, actors: 'Mel Gibson, Danny Glover', genre: 'action', etc.

simplified json mapping:
{
"movies": {
"_id" : {
"path" : "movieid"
},
"properties": {
"movieid": {"type": "string"},
"actors": {
"properties": {
"name": {"type": "string"},
}
},
"genre": {"type": "string"},
}
}
}

my question is, how would i split those actors into separate arrays of
actors in the json object using jdbc-rivers?

i could write a .net program that generates a bulk file for api (or use a
.net client for elasticsearch that does the puts), but i want to do it
using rivers so that the table can be monitored for changes.

please help.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/d7ea2be3-c4a3-42fa-aafb-b02ea3468a95%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #2