Re: Search and Entity structure

2012-10-27 Thread v vijith
Indeed , this worked . The fix that was required was related to the how the document is represented. It depends on the unique key. For the same unique key, it will always update the existing document. So to avoid it, I used the oracle sequence to identify the record, it can be oracle row number or

Re: Search and Entity structure

2012-10-27 Thread v vijith
Hi, If I write a query like this, is there a way I can achive the results that I need select * from employee a left outer join qualification b on a.empid = b.empid; This will return 5 records, 1 per employee qualification. Can this be indexed as is? 1, John, MBA, A 1, John, Lead, B 2, George, M

Re: Search and Entity structure

2012-10-26 Thread Gora Mohanty
On 27 October 2012 01:20, v vijith wrote: [...] > The dataconfig file is > > > > > [...] The SELECT in the nested entity "qualification" should fetch all qualifications for the given employee. How to do that is database dependent, e.g., one would use something

Re: Search and Entity structure

2012-10-26 Thread Gora Mohanty
On 27 October 2012 07:55, Lance Norskog wrote: > 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 yo

Re: Search and Entity structure

2012-10-26 Thread Lance Norskog
, but it is a permanent feature. Lance - Original Message - | From: "v vijith" | 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 | | | | | |

Re: Search and Entity structure

2012-10-26 Thread v vijith
The schema content that I have put in is EMPID The dataconfig file is With this as well, when I try, I get the entity as below - 3Viktor 2 George C 4 PM 1John B2LEAD The issue is that, employee George has 2 qualifications but is not s

Re: Search and Entity structure

2012-10-26 Thread Gora Mohanty
On 25 October 2012 23:48, v vijith 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 R

Re: Search and Entity structure

2012-10-26 Thread v vijith
re X is QualificationID and Y is grade value. If > you have ID for Grade value too then use it in Y instead of actual Grade > value. > So in solr when searching for MBA with A Grad you can query "q=grade:1.A" . > This should give you the result. > > > > > &g

Re: Search and Entity structure

2012-10-26 Thread adityab
p://lucene.472066.n3.nabble.com/Search-and-Entity-structure-tp4015890p4015996.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Search and Entity structure

2012-10-25 Thread v vijith
Hi, 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 tab

Search and Entity structure

2012-10-25 Thread v vijith
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. A