Created an alias called 'main' and now it works:
curl --data-urlencode 'stmt=SELECT avg(TextSize) from main'
http://cordelia:9100/solr/UNCLASS/sql?aggregationMode=map_reduce
{"result-set":{"docs":[
{"avg(TextSize)":6024.222616504568},
{"EOF":true,"RESPONSE_TIME":1391}]}}
Thank you Damian and Joel!
-Joe
On 11/29/2016 9:11 AM, Joel Bernstein wrote:
I'll take a look at the StatsStream and see what the issue is.
Joel Bernstein
http://joelsolr.blogspot.com/
On Mon, Nov 28, 2016 at 8:32 PM, Damien Kamerman <dami...@gmail.com> wrote:
Aggregated selects only work with lower-case collection names (and no
dashes). (Bug in StatsStream I think)
I assume 'SOLR-9077 Streaming expressions should support collection alias'
which is fixed in 6.4 is a work around.
On 29 November 2016 at 08:29, Kevin Risden <compuwizard...@gmail.com>
wrote:
Is there a longer error/stack trace in your Solr server logs? I wonder if
the real error is being masked.
Kevin Risden
On Mon, Nov 28, 2016 at 3:24 PM, Joe Obernberger <
joseph.obernber...@gmail.com> wrote:
I'm running this query:
curl --data-urlencode 'stmt=SELECT avg(TextSize) from UNCLASS'
http://cordelia:9100/solr/UNCLASS/sql?aggregationMode=map_reduce
The error that I get back is:
{"result-set":{"docs":[
{"EXCEPTION":"org.apache.solr.common.SolrException: Collection not
found:
unclass","EOF":true,"RESPONSE_TIME":2}]}}
TextSize is defined as:
<field name="TextSize" type="tlongs" docValues="true"
multiValued="false"
indexed="true" stored="true"/>
This query works fine:
curl --data-urlencode 'stmt=SELECT TextSize from UNCLASS'
http://cordelia:9100/solr/UNCLASS/sql?aggregationMode=map_reduce
Any idea what I'm doing wrong?
Thank you!
-Joe
