You could probably create a type field in the index to indicate the
task type. And then use the task type plus the primary key from the
db to create the Id within the index. Would save you alot of on
maintenance, and has a bunch benefits.
-John
On Mar 26, 2009, at 8:23 AM, "Radha C." <cra...@ceiindia.com> wrote:
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.
