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