Can you clarify what you mean by "added to the same index and to the same document"? Maybe you can give an example of what you want to achieve.
Jörg On Wed, Apr 9, 2014 at 1:46 AM, Srinivasan Ramaswamy <[email protected]>wrote: > 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<https://groups.google.com/d/msgid/elasticsearch/4ec15a84-2a90-4d3d-8914-d7267d642e84%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAKdsXoGMOkfZ6rSEk%3D2FphPa8FNDcgBZRtrwjipTSgs1ZAy3EA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
