Constructing List of Objects about elasticsearch-jdbc

[jprante]

List of objects are handled in the next release, a new column type with appended "[]" will allow JSON arrays. A pull request is already committed. Example: "name[]" -> "John, Paul,George, Ringo"

[kusum007]

Thanks for the response. I have customized the plugin for my purpose. I found this plugin to be very useful. Great job indeed. Thanks

[puug]

Looks like you now support core type mappings with the comma separated values, but what about arrays of object types? ie

lists" : [
{
"name" : "prog_list",
"description" : "programming list"
},
{
"name" : "cool_list",
"description" : "cool stuff list"
}
]

Doesn't look like it's overly simple to achieve, you would have to support something like
"lists._id", "lists.name", "lists.description", and pivot on the "lists._id" field.

[jprante]

Yes, such arrays of objects are not easy to interpret. That is beyond the river implementation I think.

There is a _source pseudo-column where you can put JSON into, the river parses it, and ES will take care of it, for example, it can put it into documents with multivalue fields.