Let's break this down:
'stmt=SELECT TextSize from main LIMIT 10' fails
This fails because CloudSolrStream does not currently support aliases. I
believe this is fixed in 6.4
'stmt=SELECT avg(TextSize) from UNCLASS' fails
This surprises me. I read through the StatsStream and don't see any reason
wh
Just some data points.
main is an alias for the collection UNCLASS.
'stmt=SELECT TextSize from main LIMIT 10' fails
'stmt=SELECT TextSize from UNCLASS LIMIT 10' succeeds
'stmt=SELECT avg(TextSize) from UNCLASS' fails
'stmt=SELECT avg(TextSize) from main' succeeds
'stmt=SELECT like_count, Document
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
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 wrote:
> Aggregated selects only work with lower-case collection names (and no
> dashes). (Bug in StatsStream I think)
>
> I assume 'SOLR-
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 wrote:
> Is there a longer er
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 UNCLA
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","EO
