Re: Storing 2 dimension array in Solr

2013-10-12 Thread David Philip
Hi Jack, for the point: "each element of the array as a solr document, with a group field and a disease field" Did you mean it this way: "group1_grp": G1 "disease1_d": 2, "disease2_d": 3, "group1_grp": G2 "disease1_d": 2, "disease2_d": 3, "disease3_d": 1, "disease4_d": 1, similar to

Re: SolrCore 'collection1' is not available due to init failure

2013-10-12 Thread Jim_Armstrong
Liu Bo, Changing the permissions fixed the problem. Thank you for helping me. Best regards, Jim -- View this message in context: http://lucene.472066.n3.nabble.com/SolrCore-collection1-is-not-available-due-to-init-failure-tp4094869p4095195.html Sent from the Solr - User mailing list archive

Re: Storing 2 dimension array in Solr

2013-10-12 Thread Jack Krupansky
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, you query for the group field having the desired group. If possible, index the array as being sparse -

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: SolrCloud on SSL

2013-10-12 Thread Shawn Heisey
On 10/11/2013 9:38 AM, Christopher Gross wrote: > On Fri, Oct 11, 2013 at 11:08 AM, Shawn Heisey wrote: > >> On 10/11/2013 8:17 AM, Christopher Gross wrote: >>> Is there a spot in a Solr configuration that I can set this up to use >> HTTPS? >> >> From what I can tell, not yet. >> >> https://

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: Profiling Solr Lucene for query

2013-10-12 Thread Manuel Le Normand
Would adding a dummy shard instead of a dummy collection would resolve the situation? - e.g. editing clusterstate.json from a zookeeper client and adding a shard with a 0-range so no docs are routed to this core. This core would be on a separate server and act as the collection gateway.

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

Re: Replace NULL with 0 while Indexing

2013-10-12 Thread Karol Sikora
Or you can use custom update preprocessor. W dniu 11.10.2013 23:02, keshari.prerna pisze: Hello, One of my indexing field have NULL values and i want it to be replaces with 0 while indexing itself. So that when i search after indexing it gives me 0 instead of NULL. This is my data-config.xml

Re: Replace NULL with 0 while Indexing

2013-10-12 Thread Arcadius Ahouansou
What about using COALESCE in SQL? like: select COALESCE(duration, 0) as duration from mytable On 11 October 2013 22:02, keshari.prerna wrote: > Hello, > > One of my indexing field have NULL values and i want it to be replaces with > 0 while indexing itself. So that when i search after indexin

Re: Solr's Filtering approaches

2013-10-12 Thread Roman Chyla
David, We have a similar query in astrophysics, an user can select an area of the skymany stars out there I am long overdue in creating a Jira issue, but here you have another efficient mechanism for searching large number of ids https://github.com/romanchyla/montysolr/blob/master/contrib