Re: how to efficiently get sum of an int field

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

: 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 of RAM needed by the st

Re: how to efficiently get sum of an int field

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 !sum=true to only get s

Re: how to efficiently get sum of an int field

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? if I were able to use !sum=true to only get sum, a clever algorithm should be able to tell if sum is only requited, it will avoid memory

Re: how to efficiently get sum of an int field

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 l

Re: how to efficiently get sum of an int field

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-f

Re: how to efficiently get sum of an int field

You can also try the new JSON Facet API if you are on a recent version of Solr. json.facet={x:"sum(myfield)"} http://yonik.com/solr-facet-functions/ -Yonik On Thu, Nov 5, 2015 at 1:14 PM, Renee Sun wrote: > Hi - > I have been using stats to get the sum of a field data (int) like: > > &stats=t

Re: how to efficiently get sum of an int field

Ah, Unix. Isn't it wonderful (it is, but): http://unix.stackexchange.com/questions/3051/how-to-echo-a-bang Try single quotes and backslash before the bang. Or disable history characters. Regards, Alex. Solr Analyzers, Tokenizers, Filters, URPs and even a newsletter: http://www.solr-st

Re: how to efficiently get sum of an int field

thanks! but it is silly that I can seem to escape the {!sum=true} properly to make it work in my curl :-( time curl -d 'q=*:*&rows=0&shards=solrhostname:8080/solr/413-1,anothersolrhost:8080/solr/413-2&stats=true&stats.field={!sum=true}myfieldname' http://localhost:8080/solr/413-1/select/? | xmll

Re: how to efficiently get sum of an int field

: &stats=true&stats.field=my_field_name&rows=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 faste