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
Thanks for the response. This workaround would be difficult to implement. Also Im finding it very difficult to understand that SOLR doesnt provide this feature for searching. On Fri, Oct 26, 2012 at 9:42 AM, adityab wrote: > Hi Vijith, > > See if this solution solves your problem. There might b

Re: Search and Entity structure

2012-10-26 Thread adityab
Hi Vijith, See if this solution solves your problem. There might be other ways this is the one i have on top of my mind at this hour. You might be having and ID for each qualification. then have the relation using dotted notation. 1 = MBA, 2 = LEAD etc. 1.A 2.B the format is like X.Y wh

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