Giovanni, Much Thanks for the reply. We are having seperate set of tables for each task. So we are going to provide different search based on the task. The tables of one task are unrelated to tables of another task.
_____ From: Giovanni De Stefano [mailto:giovanni.destef...@gmail.com] Sent: Thursday, March 26, 2009 5:51 PM To: solr-user@lucene.apache.org; cra...@ceiindia.com Subject: Re: indexing mutiple table Hello, that might be a solution although it is a maintenance nightmare... Are all those tables completely unrelated? Meaning does each table produce a totally different document? Either or when you perform a search you must return a common document (unless your client is able to distinguish between different documents and create an ad hoc result). Perhaps you should wait for an answer by one of those who really know about this stuff...I am pretty new to Solr. Cheers, Giovanni On 3/26/09, Radha C. <cra...@ceiindia.com> wrote: Thanks for your reply. If I want to search the my data spread over many tables say more than 50 tables, then I have to setup that many cores ? _____ From: Giovanni De Stefano [mailto:giovanni.destef...@gmail.com] Sent: Thursday, March 26, 2009 5:04 PM To: solr-user@lucene.apache.org; cra...@ceiindia.com Subject: Re: indexing mutiple table Hello, I believe you should use 2 different indexes, 2 different cores and write a custom request handler or any other client that forwards the query to the cores and merge the results. Cheers, Giovanni On 3/26/09, Radha C. <cra...@ceiindia.com> wrote: Hi, I am trying to index different tables with different primary keys and different fields. Table A - primary field is a_id Table B - primary fiedls is b_id How to specify two different primary keys for two different tables in schema.xml? Is it possible to create a data-config with different root entities/documents and index/search everything? Thanks in advance.
