Re: best way to model 1-N

2009-10-31 Thread Avlesh Singh
> > what am I missing? > Change your to The "splitBy" directive is understood by this transformer and in your case the attribute was simply ignored. Don't forget to re-index once you have changed. Cheers Avlesh On Fri, Oct 30, 2009 at 9:33 PM, Joel Nylund wrote: > Thanks Chantal, I will keep

Re: best way to model 1-N

2009-10-30 Thread Joel Nylund
Im using apache-solr-1.3.0 I got it to work using javascript function instead. thanks Joel On Oct 30, 2009, at 12:44 PM, Chantal Ackermann wrote: This looks all right to me, but I might be missing something. Which version/build of SOLR are you using? Chantal Joel Nylund schrieb: Thanks Cha

Re: best way to model 1-N

2009-10-30 Thread Chantal Ackermann
This looks all right to me, but I might be missing something. Which version/build of SOLR are you using? Chantal Joel Nylund schrieb: Thanks Chantal, I will keep that in mind for tuning, for sql I figured way to combine them into one row using concat, but I still seem to be having an issue sp

Re: best way to model 1-N

2009-10-30 Thread Joel Nylund
Thanks Chantal, I will keep that in mind for tuning, for sql I figured way to combine them into one row using concat, but I still seem to be having an issue splitting them: Db now returns as one column categoryType: TOPIC,LANGUAGE but my solr result, if you note the item in categoryType al

Re: best way to model 1-N

2009-10-30 Thread Chantal Ackermann
That depends a bit on your database, but it is tricky and might not be performant. If you are more of a Java developer, you might prefer retrieving mutliple rows per SOLR document from your dataSource (join on your category and main table), and aggregate them in your custom EntityProcessor. I

Re: best way to model 1-N

2009-10-30 Thread Joel Nylund
thanks, but im confused how I can aggregate across rows, I dont know of any easy way to get my db to return one row for all the categories (given the hint from your other email), I have split the category query into a separate entity, but its returning multiple rows, how do I combine multip

Re: best way to model 1-N

2009-10-29 Thread Avlesh Singh
> > In the database this is modeled a a 1-N where category table has the > mapping of feed to category > I need to be able to query , give me all the feeds in any given category. > How can I best model this in solr? > Seems like multiValued field might help, but how would I populate it, and > would

best way to model 1-N

2009-10-29 Thread Joel Nylund
Hi, I have one index so far which contains feeds. I have been able to de- normalize several tables and map this data onto the feed entity. There is one tricky problem that I need help on. Feeds have 1 - many categories. So Lets say we have Category1, Category2 and Category3 Feed 1 - is in