It worked!
thanks
-----Original Message-----
From: Joel Bernstein [mailto:joels...@gmail.com]
Sent: Monday, May 02, 2016 14:39
To: solr-user@lucene.apache.org
Subject: Re: solr sql & streaming
Try putting quotes around the fl parameter.
search(collections_test,
q="*:*",
fl="id,name,inStock",
sort="id asc")
Joel Bernstein
http://joelsolr.blogspot.com/
On Mon, May 2, 2016 at 2:09 AM, Chaushu, Shani <shani.chau...@intel.com>
wrote:
> U tried 2 examples:
>
> curl -id 'expr=search(collections_test, q="*:*",fl=id,name,inStock,
> sort="id asc")' http://localhost:8983/solr/collections_test/stream
>
> curl http://localhost:8983/solr/collections_test/stream -d
> 'expr=reduce(search(collections_test, q="*:*",fl=id,name,inStock,
> sort="id
> asc") , by="id",group(sord="id asc",n="2"))'
>
> -----Original Message-----
> From: Joel Bernstein [mailto:joels...@gmail.com]
> Sent: Monday, May 02, 2016 05:28
> To: solr-user@lucene.apache.org
> Subject: Re: solr sql & streaming
>
> It appears that you are not formatting the streaming expression properly.
> Can you post your entire http request?
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Sun, May 1, 2016 at 2:01 PM, Chaushu, Shani
> <shani.chau...@intel.com>
> wrote:
>
> > Yes I'm running in solr cloud mode.
> > I managed to make the query work with sql queries, but when I'm
> > trying to run it with stream request, I get an error When I try to
> > run
> > expr=search:
> >
> > "Unable to construct instance of
> > org.apache.solr.client.solrj.io.stream.CloudSolrStream
> >
> > When I try to run expr=reduce:
> > org.apache.solr.client.solrj.io.stream.ReducerStream
> >
> >
> > Any thoughts?
> >
> >
> > -----Original Message-----
> > From: Emir Arnautovic [mailto:emir.arnauto...@sematext.com]
> > Sent: Thursday, April 28, 2016 15:32
> > To: solr-user@lucene.apache.org
> > Subject: Re: solr sql & streaming
> >
> > Hi Shani,
> > Are you running in SolrCloud mode? Here is blog post you can follow:
> > https://sematext.com/blog/2016/04/18/solr-6-solrcloud-sql-support/
> >
> > Thanks,
> > Emir
> >
> > --
> > Monitoring * Alerting * Anomaly Detection * Centralized Log
> > Management Solr & Elasticsearch Support * http://sematext.com/
> >
> >
> >
> > On 28.04.2016 13:45, Chaushu, Shani wrote:
> > > Hi,
> > > I installed solr 6 and try to run /sql and /stream request follow
> > > to
> > this wiki
> > https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interf
> > ac
> > e
> > > I saw in changes list that it doesn't need request handler
> > configuration, but when I try to acces I get the following message:
> > > <html>
> > > <head>
> > > <meta http-equiv="Content-Type"
> > > content="text/html;charset=utf-8"/>
> > > <title>Error 404 Not Found</title> </head> <body><h2>HTTP ERROR
> > > 404</h2> <p>Problem accessing /solr/collection_test/sql. Reason:
> > > <pre> Not Found</pre></p>
> > > </body>
> > > </html>
> > >
> > > My request was
> > >
> > > curl --data-urlencode 'stmt=SELECT author, count(*) FROM
> > > collection_test
> > GROUP BY author ORDER BY count(*) desc'
> > http://localhost:8983/solr/collection_test/sql?aggregationMode=facet
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------------------------------------
> > > --
> > > -
> > > Intel Electronics Ltd.
> > >
> > > This e-mail and any attachments may contain confidential material
> > > for the sole use of the intended recipient(s). Any review or
> > > distribution by others is strictly prohibited. If you are not the
> > > intended recipient, please contact the sender and delete all copies.
> > >
> > --------------------------------------------------------------------
> > -
> > Intel Electronics Ltd.
> >
> > This e-mail and any attachments may contain confidential material
> > for the sole use of the intended recipient(s). Any review or
> > distribution by others is strictly prohibited. If you are not the
> > intended recipient, please contact the sender and delete all copies.
> >
> >
> ---------------------------------------------------------------------
> Intel Electronics Ltd.
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>
---------------------------------------------------------------------
Intel Electronics Ltd.
This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient(s). Any review or distribution
by others is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies.
