Sure. I am trying to index a bunch of products (unique product) and each product can have multiple tags (product sold my a merchant). I am planning to add tags a nested document in the index. The product and tags information are stored in productdb database. And there are search_tags (in the sense of keywords) associated with every product (merchants can tag the products with keywords) which is stored in a different database called tagdb.
each document in the index is going to look like product_id, product_title, product_desc, tags: [(tag_id1, tag_name, tag_desc, tag_price, tag_seller), (tag_id_n, tag_name_n, tag_desc, tag_price, tag_seller),.. ], search_tags There are few more fields which i have omitted here for the sake of clarity and simplicity. Those fields will come from other tables in the database as a result of joins in the sql statement. productdb: product, tag, few other related tables tagdb: search_tags, few other related tables Please let me know if I can clarify further. Thanks Srini On Wed, Apr 9, 2014 at 8:14 AM, [email protected] <[email protected] > wrote: > 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 a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/lCM5buPAQAc/unsubscribe. > To unsubscribe from this group and all its topics, 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<https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGMOkfZ6rSEk%3D2FphPa8FNDcgBZRtrwjipTSgs1ZAy3EA%40mail.gmail.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/CAL1MvVzgaJPkRfMf%2BXCEYGuv%3DGP_4%3DpX4c3hi8CNpjvRDSYxpA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
