Great! Feel free to continue posting questions like this to the list as the come up for streaming and SQL.
Also branch_6x now has improved error handling for streaming & SQL. These changes will be in Solr 6.1. In Solr 6.0 the root cause to certain errors was not being propagated all the way back to the client. In branch_6x this is fixed. You can still see the root cause in the logs in both Solr 6.0 and 6.1. Joel Bernstein http://joelsolr.blogspot.com/ On Mon, May 2, 2016 at 9:05 AM, Chaushu, Shani <shani.chau...@intel.com> wrote: > 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. >
