Re: Storing 2 dimension array in Solr

2013-10-14 Thread David Philip
owerful tool, but only if used in moderation. "Millions" would not be > moderation. > > -- Jack Krupansky > > -Original Message- From: Lee Carroll > Sent: Sunday, October 13, 2013 8:35 AM > > To: solr-user@lucene.apache.org > Subject: Re: Storing 2 dimen

Re: Storing 2 dimension array in Solr

2013-10-13 Thread Jack Krupansky
used in moderation. "Millions" would not be moderation. -- Jack Krupansky -Original Message- From: Lee Carroll Sent: Sunday, October 13, 2013 8:35 AM To: solr-user@lucene.apache.org Subject: Re: Storing 2 dimension array in Solr I think he means a doc for each element. so

Re: Storing 2 dimension array in Solr

2013-10-13 Thread Lee Carroll
2013 at 9:00 AM, Jack Krupansky > >wrote: > > > > > You may be better off indexing each element of the array as a solr > > > document, with a group field and a disease field. Then you can easily > and > > > efficiently add new diseases. Then to query a row

Re: Storing 2 dimension array in Solr

2013-10-13 Thread Erick Erickson
ed group. > > > > If possible, index the array as being sparse - no document for a disease > > if it is not present for that group. > > > > -- Jack Krupansky > > > > -Original Message- From: David Philip > > Sent: Saturday, October 12, 2013 9:56

Re: Storing 2 dimension array in Solr

2013-10-12 Thread David Philip
e - no document for a disease > if it is not present for that group. > > -- Jack Krupansky > > -Original Message----- From: David Philip > Sent: Saturday, October 12, 2013 9:56 PM > To: solr-user@lucene.apache.org > Subject: Re: Storing 2 dimension array in Solr > >

Re: Storing 2 dimension array in Solr

2013-10-12 Thread Jack Krupansky
- no document for a disease if it is not present for that group. -- Jack Krupansky -Original Message- From: David Philip Sent: Saturday, October 12, 2013 9:56 PM To: solr-user@lucene.apache.org Subject: Re: Storing 2 dimension array in Solr Hi Erick, Yes it is. But the columns here

Re: Storing 2 dimension array in Solr

2013-10-12 Thread David Philip
Hi Erick, Yes it is. But the columns here are dynamically and very frequently added.They can increase upto 1 million right now. So, 1 document with 1 million dynamic fields, is it fine? Or any other approach? While searching through web, I found that docValues are column oriented. http://searchhub

Re: Storing 2 dimension array in Solr

2013-10-12 Thread Erick Erickson
Isn't this just indexing each row as a separate document with a suitable ID "groupN" in your example? On Sat, Oct 12, 2013 at 2:43 PM, David Philip wrote: > Hi Erick, > >We have set of groups as represented below. New columns (diseases as in > below matrix) keep coming and we need to add the

Re: Storing 2 dimension array in Solr

2013-10-12 Thread David Philip
Hi Erick, We have set of groups as represented below. New columns (diseases as in below matrix) keep coming and we need to add them as new column. To that column, we have values such as 1 or 2 or 3 or 4 (exist, slight, na, notfound) for respective groups. While querying we need to get the ent

Re: Storing 2 dimension array in Solr

2013-10-12 Thread Erick Erickson
David: This feels like it may be an XY problem. _Why_ do you want to store a 2-dimensional array and what do you want to do with it? Maybe there are better approaches. Best Erick On Sat, Oct 12, 2013 at 2:07 AM, David Philip wrote: > Hi, > > I have a 2 dimension array and want it to be persi

Storing 2 dimension array in Solr

2013-10-11 Thread David Philip
Hi, I have a 2 dimension array and want it to be persisted in solr. How can I do that? Sample case: disease1disease2 disease3 group1exist slight not found groups2 slightnot foundexist group2slight exist exist-1 not found - 2