Hi,
  Thank you very much for your reply.
Let me clearly explain my requirement.

Its a kind of job site.

I have 2 tables that need to be added in solr.

1)  employee ( id, name, skills, location, .....)
2) job_postings ( id, name, job title, description, salary, date_posted,
....)


Here, there are 2 different kind of searches in my application.

1) employee search by employer
2) job postings search by employee

New row can be added at any time. Also the existing row can be altered at
any time. For example, employee mobile number can be changed at any time
and the solr data has to be updated.

Here there are 2 different searches. So i need to maintain two different
kind of indexes in solr.

The java example says, to add a document, below is the sample code. My
doubt is, how can i add two different kind of search data here.
Should i create a 2 different core for this 2 different searches?

 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();

Thanks,
Baskar.S


On Sun, Sep 15, 2013 at 9:14 AM, Walter Underwood <wun...@wunderwood.org>wrote:

> 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
> >>>
>
>
>
>
>
>

Reply via email to