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 why an uppercase collection should fail. Under the covers the StatsStream simply uses the CloudSolrClient to make the call. I'll need to investigate this further. 'stmt=SELECT like_count, DocumentId from main where like_count>0' fails Again the issue with CloudSolrStream not supporting aliases. Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Nov 29, 2016 at 11:48 AM, Joe Obernberger < joseph.obernber...@gmail.com> wrote: > 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, DocumentId from UNCLASS where like_count>0' > succeeds > 'stmt=SELECT like_count, DocumentId from main where like_count>0' fails > > Hope that helps. > > > -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 >>>>> >>>>> >>>>> >
