Solr does not have tables, and you can't add an index. Solr's data model is flat, like a single table with lots of columns. Think about creating a view where each row has all the information for one search result. It includes everything that is searched (indexed=true in the schema) and returned (stored=true in the schema).
wunder On Sep 14, 2013, at 7:32 PM, Amit Jha wrote: > Question is not clear to me. Please be more elaborative in your query. Why > do u want to store index to DB tables? > > Rgds > AJ > > On 15-Sep-2013, at 7:20, Baskar Sikkayan <baskar....@gmail.com> wrote: > >> How to add index to 3 diff tables from java ... >> >> >> On Sun, Sep 15, 2013 at 6:49 AM, Amit Jha <shanuu....@gmail.com> wrote: >> >>> Add a field called "source" in schema.xml and value would be your table >>> names. >>> >>> >>> >>> Rgds >>> AJ >>> >>> On 15-Sep-2013, at 5:38, Baskar Sikkayan <baskar....@gmail.com> wrote: >>> >>>> Hi, >>>> I am new to Solr and trying to use Solr java client instead of using the >>>> Data handler. >>>> Is there any configuration i need to do for this? >>>> >>>> I got the following sample code. >>>> >>>> SolrInputDocument doc = new SolrInputDocument(); >>>> >>>> doc.addField("cat", "book"); >>>> doc.addField("id", "book-" + i); >>>> doc.addField("name", "The Legend of the Hobbit part " + i); >>>> server.add(doc); >>>> server.commit(); // periodically flush >>>> >>>> I am confused here. I am going to index 3 different tables for 3 >>> different >>>> kind of searches. Here i dont have any option to differentiate 3 kind of >>>> indexes. >>>> Am i missing anything here. Could anyone please shed some light here? >>>> >>>> Thanks, >>>> Baskar.S >>>