Re: how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
or single quote, only escape ! or escape all { and !, nothing will make it work. -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum-of-an-int-field-tp4238464p4238478.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: how to efficiently get sum of an int field

2015-11-05 Thread Alexandre Rafalovitch
/solr/413-2=true={!sum=true}myfieldname' > http://localhost:8080/solr/413-1/select/? | xmllint --format - > > double quote or single quote, only escape ! or escape all { and !, nothing > will make it work. > > > > -- > View this message in context: > http://lucene.

how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
/mean etc are the ones that caused the time. Is there a simple way I can just get the sum without other things, and run it on a faster and less stressed to the solr server manner? Thanks Renee -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum

Re: how to efficiently get sum of an int field

2015-11-05 Thread Yonik Seeley
max/mean etc are the ones that caused the time. > > Is there a simple way I can just get the sum without other things, and run > it on a faster and less stressed to the solr server manner? > > Thanks > Renee > > > > -- > View this message in context: > http://lucene.472

Re: how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
I did try single quote with backslash of the bang. also tried disable history chars... did not work for me. unfortunately, we are using solr 3.5, probably does not support json format? -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum-of-an-int

Re: how to efficiently get sum of an int field

2015-11-05 Thread Chris Hostetter
: =true=my_field_name=0 ... : I noticed the 'stats' give out more information than I needed (just sum), I : suspect the min/max/mean etc are the ones that caused the time. : : Is there a simple way I can just get the sum without other things, and run : it on a faster and less stressed to

Re: how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
memory overhead, is that implemented so ? anyways I was only trying to avoid running these stats on thousands customers that kills our solr servers. thanks Renee -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum-of-an-int-field-tp4238464p4238520.html

Re: how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
now I think with solr 3.5 (that we are using), !sum=true (overwrite default ) probably is not supported yet :-( thanks Renee -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum-of-an-int-field-tp4238464p4238519.html Sent from the Solr - User mailing

Re: how to efficiently get sum of an int field

2015-11-05 Thread Yonik Seeley
On Thu, Nov 5, 2015 at 4:55 PM, Renee Sun wrote: > Also Yonik, out of curiosity... when I run stats on a large msg set (such as > 200 million msgs), it tends to use a lot of memory, this should be expected > correct? With the stats component, yeah. > if I were able to use

Re: how to efficiently get sum of an int field

2015-11-05 Thread Renee Sun
thanks Yonik... I bet with solr 3.5 we do not have jason facet api support yet ... -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-efficiently-get-sum-of-an-int-field-tp4238464p4238522.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: how to efficiently get sum of an int field

2015-11-05 Thread Chris Hostetter
: On Thu, Nov 5, 2015 at 4:55 PM, Renee Sun wrote: : > Also Yonik, out of curiosity... when I run stats on a large msg set (such as : > 200 million msgs), it tends to use a lot of memory, this should be expected : > correct? : : With the stats component, yeah. the amount