I am using elasticsearch to index documents. I have a few tables in one
database (dbA) and few other tables in another database (dbB). I have a
join query that joins all the relevant tables in dbA
curl -XPUT 'localhost:9200/_river/riverA/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:sqlserver://dbServer:1433;DatabaseName=dbA",
"index":"idx",
"type":"typA",
"user" : "username",
"password" : "mypasswd",
"sql" : "SELECT t1.key as _id, t1.val, t2.val from table1 t1 INNER
JOIN table2 t2 on t1.key=t2.key"
}
}'
curl -XPUT 'localhost:9200/_river/riverB/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:sqlserver://dbServer:1433;DatabaseName=dbB",
"index":"idx",
"type":"typB",
"user" : "username",
"password" : "mypasswd",
"sql" : "SELECT t3.key as _id, t3.val, t4.val from table3 t3 INNER
JOIN table4 t4 on t3.key=t4.key"
}
}'
If I create two different rivers and write to the same index the index
content is rewritten with the 2nd river query. Can i have two different
queries the output of which is added to the same index and to the same
document ?
Thanks
Srini
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/4ec15a84-2a90-4d3d-8914-d7267d642e84%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
