A side point: in fact, the connection between MBA and grade is not lost. The
values in a multi-valued field are stored in order. You can have separate
multi-valued fields with matching entries, and the values will be fetched in
order and you can match them by counting. This is not database-ish, but it is a
permanent feature.
Lance
----- Original Message -----
| From: "v vijith" <vvij...@gmail.com>
| To: solr-user@lucene.apache.org
| Sent: Friday, October 26, 2012 12:50:29 PM
| Subject: Re: Search and Entity structure
|
| The schema content that I have put in is
|
| <field name="EMPID" type="integer" indexed="true" stored="true"
| required="true" multiValued="false" />
| <field name="empname" type="string" indexed="true" stored="true"
| />
| <field name="gradeid" type="integer" indexed="true"
| stored="true"/>
| <field name="gradename" type="string" indexed="true"
| stored="true"/>
| <field name="grade" type="string" indexed="true" stored="true"/>
| <uniqueKey>EMPID</uniqueKey>
|
| The dataconfig file is
| <document>
| <entity name="employee" query="select * from employee">
| <entity name="qualification" query="select * from
| qualification where empid='${employee.EMPID}'"/>
| </entity>
| </document>
|
| With this as well, when I try, I get the entity as below -
| <result name="response" numFound="3" start="0">
| <doc>
| <int name="EMPID">3</int><str name="empname">Viktor</str></doc>
| <doc><int name="EMPID">2</int>
| <str name="empname">George</str>
| <str name="grade">C</str>
| <int name="gradeid">4</int>
| <str name="gradename">PM</str></doc>
| <doc><int name="EMPID">1</int><str name="empname">John</str>
| <str name="grade">B</str><int name="gradeid">2</int><str
| name="gradename">LEAD</str>
| </doc>
|
| The issue is that, employee George has 2 qualifications but is not
| shown in the result. This is due to unique id I believe. Can you
| provide some help?
|
|
|
| On Fri, Oct 26, 2012 at 8:46 PM, Gora Mohanty <g...@mimirtech.com>
| wrote:
| > On 25 October 2012 23:48, v vijith <vvij...@gmail.com> wrote:
| >> Dear All,
| >>
| >> Apologize for lengthy email ....
| >>
| >> SOLR Version: 4
| >>
| >> Im a newbie to SOLR and have gone through tutorial but could not
| >> get a
| >> solution. The below requirement doesnt seem to be impossible but I
| >> think Im missing the obvious.
| >>
| >> In my RDBMS, there is a Qualification table and an Employee table.
| >> An
| >> employee can have many qualifications. The qualification can have
| >> following attributes - GradeName and Grade. The search using sql
| >> query
| >> to achieve my requirement is as below
| >>
| >> select * from qualification a, employee b where a.empid= b.empid
| >> and
| >> a.gradename='MBA' and b.grade='A';
| >>
| >> This will return me the employee along with the dept who has the
| >> grade
| >> as MBA and has grade of A.
| >>
| >> Employee: 2 records
| >> -------------------------
| >> Empid: 1
| >> Name: John
| >> Location: California
| >>
| >> Qualifications:
| >> Gradeid: 1
| >> Empid: 1
| >> Name: MBA
| >> Grade: B
| >>
| >> Gradeid: 2
| >> Empid: 1
| >> Name: LEAD
| >> Grade: A
| >> --------------------
| >>
| >> Empid: 2
| >> Name: George
| >> Location: Nevada
| >>
| >> Qualifications:
| >> Gradeid: 3
| >> Empid: 2
| >> Name: MBA
| >> Grade: A
| >>
| >> Gradeid: 4
| >> Empid: 2
| >> Name: Graduate
| >> Grade: C
| >
| > Stop thinking of Solr in terms of RDBMS. Instead, flatten out your
| > data. Thus, in your example, you could have a schema with the
| > following fields:
| > doc_id name location qualification grade
| > doc_id is a unique identifier for Solr. If you want to retain Empid
| > and Gradeid you could also add these.
| >
| > and the following entries
| > 1 John California MBA B
| > 2 John California Lead A
| > 3 George Nevada MBA A
| > 4 George Nevada Graduate C
| >
| > Searching for qualification:MBA and grade:A will then give you only
| > record 3.
| >
| > Regards,
| > Gora
|
