Re: Dealing with null values in streaming rollup

gt; -- > Jan Høydahl, search solution architect > Cominvent AS - www.cominvent.com > > > 18. okt. 2018 kl. 05:35 skrev RAUNAK AGRAWAL : > > > > Hi, > > > > I am trying to use streaming rollup expression to aggregate the sales > > values over week. H

Dealing with null values in streaming rollup

Hi, I am trying to use streaming rollup expression to aggregate the sales values over week. Here is the query: curl http://localhost:8983/solr/metrics_data/stream -d 'expr=rollup( search(metrics_data, q=id:123, fl="week_no,sales,qty", qt="/export", sort="week_no desc"), over="week", sum(s

Re: Streaming rollUp vs Streaming facet

being returned in the same query. > 2) Rollups following any kind of relational algebra. For example a rollup > on top of a hashJoin. > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Tue, Oct 16, 2018 at 8:54 AM RAUNAK AGRAWAL > wrote: > > &g

Streaming rollUp vs Streaming facet

Hi Guys, I am trying to do an aggregation (sum) using streaming API. I have around 10 billion documents in my collection and every document has around 10 docValues. So streaming facet is taking close to 6 secs to respond with aggregation on 10 fields while streaming rollup is returning the respon

Re: Solr Streaming Queries Performance Issues [v7.2.1]

stein > http://joelsolr.blogspot.com/ > > > On Fri, Sep 28, 2018 at 2:52 PM RAUNAK AGRAWAL > wrote: > > > Thanks a lot Toki. I will get back to you soon regarding patch update > after > > having discussion with the team. > > > > Thanks & Regards > &g

Re: Solr Streaming Queries Performance Issues [v7.2.1]

Thanks a lot Toki. I will get back to you soon regarding patch update after having discussion with the team. Thanks & Regards On Fri, Sep 28, 2018 at 11:30 AM Toke Eskildsen wrote: > RAUNAK AGRAWAL wrote: > > > curl http://localhost:8983/solr/collection_name/stream -d

Re: Solr Streaming Queries Performance Issues [v7.2.1]

/lucidworks.com/2017/10/13/segment-merging-deleted-documents-optimize-may-bad/ > > and for 7.5+ > https://lucidworks.com/2018/06/20/solr-and-optimizing-your-index-take-ii/ > > Best, > Erick > On Fri, Sep 28, 2018 at 10:09 AM RAUNAK AGRAWAL > wrote: > > > > Hey

Re: Solr Streaming Queries Performance Issues [v7.2.1]

t be used, as it comes with other issues? Thanks On Fri, Sep 28, 2018 at 7:40 AM Toke Eskildsen wrote: > On Thu, 2018-09-27 at 15:52 -0700, RAUNAK AGRAWAL wrote: > > But for last few days, we are observing now that streaming facet > > response is slower that json facets. Also we have

Solr Streaming Queries Performance Issues [v7.2.1]

Hi Guys, Just to give you context, we were using JSON Facets for doing analytical queries in solr but they were slower. Hence we migrated our application to use solr streaming facet queries. But for last few days, we are observing now that streaming facet response is slower that json facets. Also

Unable to make IN queries on a particular field in solr

Hi, I am facing an issue where I have a collection named employee collection. Suppose I was to search employee by its id, so my query is *id:(1 2 3*) and it is working fine in solr. Now let say I want to search by their name. So my query is name:(Alice Bob). Now the problem is when I am querying

Re: How to escape OR or any other keyword in solr

Are you using a stop word file? That might be why you're getting 0 results > searching for "OR". > > Cheers, > Peter. > > -Original Message- > From: RAUNAK AGRAWAL [mailto:agrawal.rau...@gmail.com] > Sent: 27 March 2018 07:45 > To: solr-user@lucene.ap

How to escape OR or any other keyword in solr

I have to search for state "OR" [short form for Oregon]. When I am making query state:OR, I am getting SolrException since it is recognising it as keyword. Now I tried with quotes ("") or //OR as well and when doing so..Solr doesn't give exception but it also doesn't return any matching document.

Re: Json Facet Query Stripping Field Name with Hyphen

as well. > As Erick says, you're better off renaming the fields. There is a > workaround for wonky field names via the "field" function: > sum(field(week_-91)) > > -Yonik > > > On Thu, Jan 4, 2018 at 10:02 AM, RAUNAK AGRAWAL > wrote: > > Hi Guys,

Json Facet Query Stripping Field Name with Hyphen

Hi Guys, I am facing issue where I am trying to follow the JSON facet API. I have data in my collection and field names are like "week_0", "week_-1" which means current week and previous week respectively. When I am querying for week_0 summation using the following query I am able to get the resu

Re: SolrJ with Async Http Client

use case is, but generally speaking, >> asynchronous requests can be achieved by using threads/executors/futures >> (java) or ajax (javascript). The link seems to be a scala project, I'm >> sure >> scala has analogous facilities. >> >> On Tue, Jan 2, 2018 at 1

SolrJ with Async Http Client

Hi Guys, I am trying to write fully async service where solr calls are also async. Just wondering did anyone tried calling solr in non-blocking mode or is there is a way to do it? I have come across one such project but wondering is there anything provided by solrj

Re: Solr Aggregation queries are way slower than Elastic Search

Thanks Yonik and Joel. I will try with JSON Facet API and update the results here. On Tue, Dec 12, 2017 at 10:56 PM, Yonik Seeley wrote: > On Tue, Dec 12, 2017 at 9:17 AM, RAUNAK AGRAWAL > wrote: > > Hi Yonik, > > > > So if the query is fine then I guess even using

Re: Solr Aggregation queries are way slower than Elastic Search

sk for any number of stats for a given facet (even the root > facet bucket w/o faceting on any fields): > > cutl 'http://localhost:8983/solr/collection1.query?q=variable1: > 290&rows=0&json.facet={ > s1:"sum(metric_1)", > s2:"sum(metric_2)", >

Re: Solr Aggregation queries are way slower than Elastic Search

7; stats.field='{!sum=true }metric_81' stats.field='{!sum=true }metric_82' stats.field='{!sum=true }metric_83' stats.field='{!sum=true }metric_84' stats.field='{!sum=true }metric_85' stats.field='{!sum=true }metric_86' stats.field='{!su

Re: Solr Aggregation queries are way slower than Elastic Search

t to pull this from the logs). > > -Yonik > > > On Mon, Dec 11, 2017 at 7:32 PM, RAUNAK AGRAWAL > wrote: > > Hi, > > > > We have a use case where there are 4-5 dimensions and around 3500 metrics > > in a single document. We have indexed only 2 dimens

Solr Aggregation queries are way slower than Elastic Search

Hi, We have a use case where there are 4-5 dimensions and around 3500 metrics in a single document. We have indexed only 2 dimensions and made all the metrics as doc_values so that we can run the aggregation queries. We have 6 million such documents and we are using solr cloud(6.6) on a 6 node cl