Re: [EXTERNAL] Re: JSON Facet with local parameter

. : Date: Mon, 13 Jul 2020 04:03:50 + : From: Mohamed Sirajudeen Mayitti Ahamed Pillai : : Reply-To: solr-user@lucene.apache.org : To: "solr-user@lucene.apache.org" : Subject: JSON Facet with local parameter : : Is it possible to refer loca

Re: JSON Facet with local parameter

g below error, : : "error": {"metadata": ["error-class","org.apache.solr.common.SolrException","root-error-class","org.apache.solr.common.SolrException"],"msg": "Can't parse value $arrivalRange for field: pdp_activation_date_dt","code": 400} : : : How to instruct Solr JSON Facet to reference another parameter that is added to the search request ? : : : : : -Hoss http://www.lucidworks.com/

JSON Facet with local parameter

uot;error-class","org.apache.solr.common.SolrException","root-error-class","org.apache.solr.common.SolrException"],"msg": "Can't parse value $arrivalRange for field: pdp_activation_date_dt","code": 400} How to instruct Solr JSON Facet to reference another parameter that is added to the search request ?

RE: Possible performance bug - JSON facet - numBuckets:true

6:22Z", "count":603}, { "val":"2019-01-08T01:08:58Z", "count":484}, . . . . "val":"2019-01-26T06:30:33Z", "count":3}]}}} There is 2660 buckets (which is the result of my fix) w

Re: Possible performance bug - JSON facet - numBuckets:true

Hello, Artur. Thanks for your interest. Perhaps, we can amend doc mentioning this effect. In long term it can be optimized by adding a proper condition. Both patches are welcome. On Wed, Feb 12, 2020 at 10:48 PM Rudenko, Artur wrote: > Hello everyone, > I'm am currently investigating a

RE: Possible performance bug - JSON facet - numBuckets:true

Guys? Artur Rudenko -Original Message- From: Rudenko, Artur Sent: Saturday, February 15, 2020 12:50 PM To: solr-user@lucene.apache.org Subject: RE: Possible performance bug - JSON facet - numBuckets:true Promoting my question Thanks, Artur Rudenko From: Rudenko, Artur Sent

facet.threads on JSON Facet

Hi, All Is facet.threads available on JSON Facet? If it's available on JSONFacet, how do I specify on request parameters? I'm using facet.threads on JSON Facet like below. I can't confirm any performance difference before-and-after specifying facet.threads=-1 localhost:8983/solr/collection1

RE: Possible performance bug - JSON facet - numBuckets:true

Promoting my question Thanks, Artur Rudenko From: Rudenko, Artur Sent: Wednesday, February 12, 2020 9:48 PM To: solr-user@lucene.apache.org Subject: Possible performance bug - JSON facet - numBuckets:true Hello everyone, I'm am currently investigating a performance issue in our environment

Possible performance bug - JSON facet - numBuckets:true

Hello everyone, I'm am currently investigating a performance issue in our environment and it looks like we found a performance bug. Our environment: 20M large PARENT documents and 800M nested small CHILD documents. The system inserts about 400K PARENT documents and 16M CHILD documents per day.

Re: JSON Facet doesn't allow date range facets

gt;> > >>> On 12/12/2019 11:40, Joel Bernstein wrote: > >>>> There is a field type in the schema called pdate: > >>>> > >>>> > >>>> > >>>> This should work for you. > >>>> > >>>>

Re: JSON Facet doesn't allow date range facets

: This should work for you. The timeseries Streaming Expression uses the JSON facet API for range faceting and works really well. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Dec 12, 2019 at 6:28 AM Mel Mason wrote: Hi, I'm trying to have a range facet on a field of type

Re: JSON Facet doesn't allow date range facets

that as far as I know. >> >> On 12/12/2019 11:40, Joel Bernstein wrote: >> > There is a field type in the schema called pdate: >> > >> > >> > >> > This should work for you. >> > >> > The timeseries Streaming Expression use

Re: JSON Facet doesn't allow date range facets

-05-01 TO 2019-06-02]. > DatePointFields can't represent that as far as I know. > > On 12/12/2019 11:40, Joel Bernstein wrote: > > There is a field type in the schema called pdate: > > > > > > > > This should work for you. > > > > The timeseries

Re: JSON Facet doesn't allow date range facets

the JSON facet API for range faceting and works really well. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Dec 12, 2019 at 6:28 AM Mel Mason wrote: Hi, I'm trying to have a range facet on a field of type solr.DateRangeField. As far as I can tell, this isn't possible with JSONFacet

Re: JSON Facet doesn't allow date range facets

There is a field type in the schema called pdate: This should work for you. The timeseries Streaming Expression uses the JSON facet API for range faceting and works really well. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Dec 12, 2019 at 6:28 AM Mel Mason wrote: > Hi, >

Re: JSON Facet doesn't allow date range facets

Currently, it is not supported yet. Related JIRA - https://issues.apache.org/jira/browse/SOLR-10567 Regards, Munendra S N On Thu, Dec 12, 2019 at 4:58 PM Mel Mason wrote: > Hi, > > I'm trying to have a range facet on a field of type solr.DateRangeField. > As far as I can tell, this isn't

JSON Facet doesn't allow date range facets

Hi, I'm trying to have a range facet on a field of type solr.DateRangeField. As far as I can tell, this isn't possible with JSONFacet, only with the old facet system - a quick google turns up several other people with the same problem. When using JSONFacet I get problems with this line of

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi Jason, Yes. I am using the latest Solr 8.1.1. The query which I'm using is the JSON Facet query which I faced the error initially. Regards, Edwin On Tue, 4 Jun 2019 at 20:15, Jason Gerlowski wrote: > Hi Edwin, > > Thanks for the additional datapoint. It seemed to work for m

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi Edwin, Thanks for the additional datapoint. It seemed to work for me, but we don't really understand the problem yet, so maybe it's not a solid work around like I'd hoped. I'm curious to hear whether it works for Colvin. To double check though: forwardCredentials is only supported in Solr >

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi Jason, Thanks for your reply. I have tried to add the "forwardCredentials": true in the security.json, but I still get the same error. Regards, Edwin On Mon, 3 Jun 2019 at 22:19, Colvin Cowie wrote: > Hi, thanks I'll give that a go when I get a chance. > > I was trying to reply to an

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi, thanks I'll give that a go when I get a chance. I was trying to reply to an older thread ( http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201904.mbox/%3CCAF2DzVXeVZqnixnkbzw0La1ui5N5-RG9PwfMBHG9vmkfBSMzJA%40mail.gmail.com%3E), which I don't have in my mailbox, so obviously didn't

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi Colvin, We're still taking a look at fixing the bug, but as a workaround in the meantime, you can look into adding a "forwardCredentials":true property under the "authentication" section of security.json. That seems to fix the issue in my reproduction at least. e.g. { "authentication":

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

One last note: as far as I can tell, nothing about this issue is specific to JSON Faceting or the JSON request API. It can be triggered just as easily with "/select?q=*:*". The bug created for this is: SOLR-13510 On Mon, Jun 3, 2019 at 9:17 AM Jason Gerlowski wrote: > > I'm also able to

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

I'm also able to reproduce this bug on master. A few more notes about the bad behavior: - the behavior occurs regardless of the specific permissions configured in security.json. (i.e. whether the top permission is "all", or "security-edit", or there are no permissions at all.) - I tried looking

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Hello. I encountered this issue too and wrote this up before I found this thread, but I thought I might as well post it still, if it helps... Currently I'm trying to move our product on to Solr 8.1.1. We are currently using 6.6.6, so things have definitely moved on. We use the BasicAuthPlugin +

JSON Facet Count All Information

in a multivalued field beside running a json facet on that? Kind Regards, Furkan KAMACI

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

>>>> the three collections, and we do not face this issue in the earlier >>> version >>>> of Solr. >>>> >>>> Appreciate if anyone can advice on this weird scenario? >>>> >>>> Thank you. >>>> >>&g

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

hen we put only one or >> two of >> > the three collections, and we do not face this issue in the earlier >> version >> > of Solr. >> > >> > Appreciate if anyone can advice on this weird scenario? >> > >> > Thank you. >> > >> &g

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

ror when we put only one or two > of > > the three collections, and we do not face this issue in the earlier > version > > of Solr. > > > > Appreciate if anyone can advice on this weird scenario? > > > > Thank you. > > > > Regards, > > Edwi

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

Apr 2019 at 15:20, Zheng Lin Edwin Yeo > wrote: > >> Hi, >> >> >> I am using the below JSON Facet to retrieve the count of all the different >> collections in one query. >> >> >> https://localhost:8983/solr/collection1/select?q=test

Re: Intermittent error 401 with JSON Facet query to retrieve count all collections

this issue in the earlier version of Solr. Appreciate if anyone can advice on this weird scenario? Thank you. Regards, Edwin On Wed, 24 Apr 2019 at 15:20, Zheng Lin Edwin Yeo wrote: > Hi, > > > I am using the below JSON Facet to retrieve the count of all the different > collectio

JSON facet API - can't reference 'val' field

Hi, Is there any way to reference the 'val' value of a bucket in the JSON facet API? I have a set of records that all have collection tags. I want to facet on those collections and sort them by a function that uses the number of search documents in that collection and the total number

Intermittent error 401 with JSON Facet query to retrieve count all collections

Hi, I am using the below JSON Facet to retrieve the count of all the different collections in one query. https://localhost:8983/solr/collection1/select?q=testing=https://localhost:8983/solr/collection1,https://localhost:8983/solr/collection2,https://localhost:8983/solr/collection3,https

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

>> Anyway, that's easy for you to test though. Try a few "/select?q=*:*" >>> queries and see whether they also exhibits this behavior. One other >>> question: does the behavior persist after restarting your Solr nodes? >>> >>> Good luck, >>> >&

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

Apr 17, 2019 at 4:05 AM Zheng Lin Edwin Yeo >> wrote: >> > >> > Hi, >> > >> > For your info, I have enabled basic authentication and SSL in all the 3 >> > versions, and I'm not sure if the issue is more on the authentication >> side >> &g

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

r Solr nodes? > > Good luck, > > Jason > > On Wed, Apr 17, 2019 at 4:05 AM Zheng Lin Edwin Yeo > wrote: > > > > Hi, > > > > For your info, I have enabled basic authentication and SSL in all the 3 > > versions, and I'm not sure if the issue is more on

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

; >> Hi Edwin, > >> > >> To clarify what you're running into: > >> > >> - on 7.6, this query works all the time > >> - on 7.7 this query works all the time > >> - on 8.0, this query works the first time you run it, but subsequent > >>

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

Hi, For your info, I have enabled basic authentication and SSL in all the 3 versions, and I'm not sure if the issue is more on the authentication side instead of the JSON Facet query? Regards, Edwin On Wed, 17 Apr 2019 at 06:54, Zheng Lin Edwin Yeo wrote: > Hi Jason, > > Yes, that i

Re: JSON Facet query to retrieve count all collections in Solr 8.0.0

security.json. Best, Jason On Mon, Apr 15, 2019 at 10:40 PM Zheng Lin Edwin Yeo wrote: > > Hi, > > I am using the below JSON Facet to retrieve the count of all the different > collections in one query. > > https://localhost:8983/solr/collection1/select?q=testing=https:

JSON Facet query to retrieve count all collections in Solr 8.0.0

Hi, I am using the below JSON Facet to retrieve the count of all the different collections in one query. https://localhost:8983/solr/collection1/select?q=testing=https://localhost:8983/solr/collection1,https://localhost:8983/solr/collection2,https://localhost:8983/solr/collection3,https

Using solrconfig for json facet sorting

Hi, Is it possible to configure sorting on json.facet in solrconfig.xml just like for traditional facets? Thanks, Soham -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Solr JSON Facet

So I'm really liking the json facets in terms of performance and features but I have the following questions: - Can we use solr 7.6's facet.matches? - Is there a way to only return the matched values in the facet? (we are having problems with multivalued fields) - Do we have any way to filter the

Limit facet terms based on a substring using the JSON facet API

Hi In the old Solr facet API there are the facet.contains and facet.conains.ignoreCase parameters to limit the facet values to those terms containing the specified substring. Is there an equivalent option in the JSON facet API? Or is there a way to obtain the same behavior with the JSON API? I

Re: Parameter Dereferencing with function queries in solr json facet

Thanks Mikhail -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Parameter Dereferencing with function queries in solr json facet

One can not apply range query syntax over function. {!frange} query parser can handle that. On Sat, Dec 8, 2018 at 2:45 PM Venu wrote: > I am using solr6.6. I am trying to use parameter Dereferencing for json > facets. > > There can be multiple prices for all the documents(assume sp, price1, >

Parameter Dereferencing with function queries in solr json facet

I am using solr6.6. I am trying to use parameter Dereferencing for json facets. There can be multiple prices for all the documents(assume sp, price1, price2, price3, price4 are the prices for all the documents). Based on the query, I have to fetch the minimum value among the combination of those

Re: Median in Solr json facet api

Thanks Toke and Joel. On Wed, 14 Nov 2018 at 19:47, Joel Bernstein wrote: > The JSON facet API uses the t-digest approach to estimate the percentiles. > > You can also use Solr Math Expressions to take a random sample from a field > and estimate the median from the sample. Here is t

Re: Median in Solr json facet api

The JSON facet API uses the t-digest approach to estimate the percentiles. You can also use Solr Math Expressions to take a random sample from a field and estimate the median from the sample. Here is the Streaming Expression: let(a=random(collection1, q="*:*", fl="filesize_

Re: Median in Solr json facet api

On Wed, 2018-11-14 at 17:53 +0530, Anil wrote: > I don;t see median aggregation in JSON facet api documentation. It's the 50 percentile: https://lucene.apache.org/solr/guide/7_5/json-facet-api.html#metrics-example - Toke Eskildsen, Royal Danish Library

Median in Solr json facet api

HI, Good Morning. I don;t see median aggregation in JSON facet api documentation. Could you please point me to the documentation to create custom json facet apis ? Thanks. Regards, Anil

Re: Solr Json Facet

Only for the records, I will describe here what I did to solve this problem. This is specific for those who are using python/requests and Solr json facet api. I would like to ask another question regarding json facet. > > With GET method, i was used to use many fq on the same query, ea

Re: Solr Json Facet

. The code is not that clean and I am rewriting, so I >> don't know exactly what was wrong, but something malformed. >> >> I would like to ask another question regarding json facet. >> >> With GET method, i was used to use many fq on the same query, each one with >>

Re: Solr Json Facet

unsubscribe On Tue, May 8, 2018 at 9:19 PM, Kojo <rbsnk...@gmail.com> wrote: > Everything working now. The code is not that clean and I am rewriting, so I > don't know exactly what was wrong, but something malformed. > > I would like to ask another question regarding json f

Re: Solr Json Facet

Everything working now. The code is not that clean and I am rewriting, so I don't know exactly what was wrong, but something malformed. I would like to ask another question regarding json facet. With GET method, i was used to use many fq on the same query, each one with it's own tag

Re: Solr Json Facet

Looks like some sort of proxy server inbetween the python client and solr server. I would still check first if the output from the python client is correctly escaped/encoded HTTP. One easy way is to use netcat to pretend to be a server: $ nc -l 8983 And then send point the python client at that

Re: Solr Json Facet

Thank you all. I tried escaping but still not working Yonik, I am using Python Requests. It works if my fq is a single word, even if I use double quotes on this single word without escaping. This is the HTTP response: response.content '\n\n400 Bad Request\n\nBad Request\nYour browser sent a

Re: Solr Json Facet

On Tue, May 8, 2018 at 1:36 PM, Kojo wrote: > If I tag the fq query and I query for a simple word it works fine too. But > if query a multi word with space in the middle it breaks: Most likely the full query is not getting to Solr because of an HTTP protocol error (i.e. the

Re: Solr Json Facet

On 5/8/2018 11:36 AM, Kojo wrote: > If I tag the fq query and I query for a simple word it works fine too. But > if query a multi word with space in the middle it breaks: > > {'q':'*:*', 'fl': '*', > 'fq':'{!tag=city_colaboration_tag}city_colaboration:"College > Station"', 'json.facet':

Re: Solr Json Facet

Single backslash escaping works for me. On Tue, May 8, 2018 at 8:36 PM, Kojo wrote: > Hello, > recently I have changed the way I get facet data from Solr. I was using GET > method on request but due to the limit of the query I changed to POST > method. > > Bellow is a sample

Solr Json Facet

Hello, recently I have changed the way I get facet data from Solr. I was using GET method on request but due to the limit of the query I changed to POST method. Bellow is a sample of the data I send to Solr, in order to get facets. But there is something here that I don´t understand. If I do not

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Hi Yonik, Good to hear you were able to reproduce it. Looking forward for the fix. Will use the version of Solr that works in the meantime. -Antelmo On Thu, Feb 22, 2018 at 5:10 PM, Yonik Seeley wrote: > I've reproduced the issue and opened >

Re: Issue Using JSON Facet API Buckets in Solr 6.6

I've reproduced the issue and opened https://issues.apache.org/jira/browse/SOLR-12020 -Yonik On Thu, Feb 22, 2018 at 11:03 AM, Yonik Seeley wrote: > Thanks Antelmo, I'm trying to reproduce this now. > -Yonik > > > On Mon, Feb 19, 2018 at 10:13 AM, Antelmo Aguilar

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Thanks Antelmo, I'm trying to reproduce this now. -Yonik On Mon, Feb 19, 2018 at 10:13 AM, Antelmo Aguilar wrote: > Hi all, > > I was wondering if the information I sent is sufficient to look into the > issue. Let me know if you need anything else from me please. > > Thanks, >

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Hi all, I was wondering if the information I sent is sufficient to look into the issue. Let me know if you need anything else from me please. Thanks, Antelmo On Thu, Feb 15, 2018 at 1:56 PM, Antelmo Aguilar wrote: > Hi, > > Here are two pastebins. The first is the full

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Hi, Here are two pastebins. The first is the full complete response with the search parameters used. The second is the stack trace from the logs: https://pastebin.com/rsHvKK63 https://pastebin.com/8amxacAj I am not using any custom code or plugins with the Solr instance. Please let me know

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Could you provide the full stack trace containing "Invalid Date String" and the full request that causes it? Are you using any custom code/plugins in Solr? -Yonik On Mon, Feb 12, 2018 at 4:55 PM, Antelmo Aguilar wrote: > Hi, > > I was using the following part of a query to get

Re: Issue Using JSON Facet API Buckets in Solr 6.6

Hello, I just wanted to follow up on this issue I am having in case it got lost. I have been trying to figure this out and so far the only solution I can find is using the older version. If you need more details from me, please let me know. I would really appreciate any help. Best, Antelmo On

Issue Using JSON Facet API Buckets in Solr 6.6

Hi, I was using the following part of a query to get facet buckets so that I can use the information in the buckets for some post-processing: "json":

Re: Json Facet Query Stripping Field Name with Hyphen

Hi Erick/Yonik, Thank you guys. I am going to rename the fields. On Thu, Jan 4, 2018 at 10:04 PM, Yonik Seeley <ysee...@gmail.com> wrote: > The JSON Facet API uses the function query parser for something like > sum(week_-91) so you'll probably have problems with any function

Re: Json Facet Query Stripping Field Name with Hyphen

The JSON Facet API uses the function query parser for something like sum(week_-91) so you'll probably have problems with any function that uses these fields as well. As Erick says, you're better off renaming the fields. There is a workaround for wonky field names via the "field" fun

Re: Json Facet Query Stripping Field Name with Hyphen

ed SOLR-11819 for one place I see in the ref guide where a hyphen is used, if you see any others please add the location to the JIRA (SOLR-11819). Best, Erick On Thu, Jan 4, 2018 at 7:02 AM, RAUNAK AGRAWAL <agrawal.rau...@gmail.com> wrote: > Hi Guys, > > I am facing issue where I

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 qu

JSON facet not working with dates

vationStart.TimeOP":{     "counts":[   "3000-01-01T00:00:00Z",258,   "3000-01-01T00:15:00Z",261,   "3000-01-01T00:30:00Z",258,   "3000-01-01T00:45:00Z",254,   ... My date fields are of type solr.DateRa

Solr 6.6 - JSON Facet API - Unexpected counts returned for child focused facets

Suppose I have a set of documents that look likes this: [ { "id": "1", "post_time": "2017-10-24T13:00:00Z", "category": "information technology", "url": "https://www.mywebsite.com;, "blog_post": "solr", "is_root_document": true,

Solr json facet API contains option

Hi, I don't seem to find a 'contains' (with or without ignorecase) in the available descriptions of the JSON facet API. Is that because there is none? Or is it just not adequately described. For example in the official ref guide for 6.6 or 7.0 there is no mention of this feature

Re: JSON facet SUM precision and accuracy is incorrect

to make the tools even more reliable given the great stride of new features available in 7.0. Looking forward. Many thanks. Dr. Patrick -- View this message in context: http://lucene.472066.n3.nabble.com/JSON-facet-SUM-precision-and-accuracy-is-incorrect-tp4349571p4351902.html Sent from

Re: JSON facet SUM precision and accuracy is incorrect

king type information > (this problem will occur anywhere function queries are used and is not > unique to JSON Facet). > Function queries were originally only used in lucene scoring (which > only uses float). > The inner sum(amount1_d,amount2_d) uses SumFloatFunction, hence the >

Re: JSON facet SUM precision and accuracy is incorrect

This is due to function queries currently lacking type information (this problem will occur anywhere function queries are used and is not unique to JSON Facet). Function queries were originally only used in lucene scoring (which only uses float). The inner sum(amount1_d,amount2_d) uses

JSON facet SUM precision and accuracy is incorrect

Appreciate if anyone can help raise an issue for the JSON facet sum error my staff Edwin raised earlier but have not gotten any response from the Solr community and developers. Our production operation is urgently needing this accuracy to proceed as it impacts audit issues. Best regards

Re: Sum of double fields in JSON Facet

//twitter.com/lucidworks > LinkedIn: https://www.linkedin.com/in/sarkaramrit2 > > On Tue, Jul 25, 2017 at 6:27 PM, Zheng Lin Edwin Yeo <edwinye...@gmail.com > > > wrote: > > > This is the way which I put my JSON facet. > > > > totalAmount:"sum(sum(amount1_d,amou

Re: Sum of double fields in JSON Facet

www.lucidworks.com Twitter http://twitter.com/lucidworks LinkedIn: https://www.linkedin.com/in/sarkaramrit2 On Tue, Jul 25, 2017 at 6:27 PM, Zheng Lin Edwin Yeo <edwinye...@gmail.com> wrote: > This is the way which I put my JSON facet. > > totalAmount:"sum(sum(amount1_d,amount

Re: Json facet sort by subfacet

Not that i am aware of to sort by numBuckets but how much difference it make if you sort by count. For e.g. below result is sorted by inner count and numBuckets in this example has same order. curl http://localhost:8983/solr/techproducts/query -d 'q=*:*=0& json.facet={

Json facet sort by subfacet

Hi, According to http://yonik.com/solr-facet-functions/, we can sort on "any facet function that appears in each bucket": $ curl http://localhost:8983/solr/query -d 'q=*:*& json.facet={ categories:{ type : terms, field : cat, sort : "x desc", // can also use sort:{x:desc}

Re: Sum of double fields in JSON Facet

This is the way which I put my JSON facet. totalAmount:"sum(sum(amount1_d,amount2_d))" amount1_d: 69446961.2 amount2_d: 0 Result I get: 69446959.27 Regards, Edwin On 25 July 2017 at 20:44, Zheng Lin Edwin Yeo <edwinye...@gmail.com> wrote: > Hi, > > I'm trying

Sum of double fields in JSON Facet

Hi, I'm trying to do a sum of two double fields in JSON Facet. One of the field has a value of 69446961.2, while the other is 0. However, when I get the result, I'm getting a value of 69446959.27. This is 1.93 lesser than the original value. What could be the reason? I'm using Solr 6.5.1

How difficult is adding a new aggregate function to Json Facet?

Hey, it has been awhile since I'm using Solr, but I have never see the code. Now I'm in the need to add some capability to Solr. What I need to add is another aggregate function to Json Facet API, for example "sum(field1)-sum(field2)". How hard do you think it would be? Also, it woul

Re: Is JSON facet output removing characters like \t from output

t;buckets":[{ >> >> "val":"A\t\t\t", >> >> "count":2}, >> >> { >> >> "val":"L\t\t\t", >> >> "count":1}, >> >> { >> >>

Re: Is JSON facet output removing characters like \t from output

unt":2}, > > { > > "val":"L\t\t\t", > > "count":1}, > > { > > "val":"P\t\t\t", > > "count":1}, > > { > > "val&qu

Re: Is JSON facet output removing characters like \t from output

"count":2}, { "val":"L\t\t\t", "count":1}, { "val":"P\t\t\t", "count":1}, { "val":"Z\t\t\t", "coun

Is JSON facet output removing characters like \t from output

Hi, Would like to check, does JSON facet output remove characters like \t from its output? Currently, we found that if the result is not in the last result set, the characters like \t will be removed from the output. However, if it is the last result set, the \t will not be removed

Re: Include JSON facet inside Solr Streaming

..@gmail.com> > wrote: > > > Is it possible to do a Join (Eg: hashJoin, innerJoin) on the facet stream > > expression? > > > > Regards, > > Edwin > > > > On 1 July 2017 at 03:30, Susheel Kumar <susheel2...@gmail.com> wrote: > > > > > I

Re: Include JSON facet inside Solr Streaming

; Edwin > > On 1 July 2017 at 03:30, Susheel Kumar <susheel2...@gmail.com> wrote: > > > I doubt it can work. Why not utilise facet stream expression which use > > JSON facet under the cover. > > > > On Thu, Jun 29, 2017 at 9:44 PM, Zheng Lin Edwi

Re: Include JSON facet inside Solr Streaming

Is it possible to do a Join (Eg: hashJoin, innerJoin) on the facet stream expression? Regards, Edwin On 1 July 2017 at 03:30, Susheel Kumar <susheel2...@gmail.com> wrote: > I doubt it can work. Why not utilise facet stream expression which use > JSON facet under the cover. > &

Re: Include JSON facet inside Solr Streaming

I doubt it can work. Why not utilise facet stream expression which use JSON facet under the cover. On Thu, Jun 29, 2017 at 9:44 PM, Zheng Lin Edwin Yeo <edwinye...@gmail.com> wrote: > Hi, > > Is it currently possible to include JSON facet inside Solr Streaming? >

Include JSON facet inside Solr Streaming

Hi, Is it currently possible to include JSON facet inside Solr Streaming? I am trying out with the following query, which combines JSON facet together with the hashJoin from Streaming, but we get the error saying that is not a proper expression clause. If it is possible, what should

JSON facet API: exclusive lower bound, inclusive upper bound

The docs for the JSON facet API tell us that the default ranges are inclusive of the lower bounds and exclusive of the upper bounds. �I'd like to do the opposite (exclusive lower, inclusive upper), but I can't figure out how to combine the 'include' parameters to make it work. � �

Re: Function queries with Json facet

Also change manufacturedate_dt to dob field and price to grade... On Mon, Jun 5, 2017 at 10:33 AM, Susheel Kumar wrote: > You are looking for something like below. Please adjust the start and > end. You can also give a fixed date instead of NOW etc.. > > curl

Re: Function queries with Json facet

You are looking for something like below. Please adjust the start and end. You can also give a fixed date instead of NOW etc.. curl http://localhost:8983/solr/techproducts/query -d 'q=*:*& json.facet={ byyeaar:{ type:range, field:"manufacturedate_dt", start : NOW-15YEAR/YEAR,

Function queries with Json facet

Hi,I have a date field date_of_birth and have double field grade. I can easily get the sum of grades per date_of_birth value using:{date_of_birth:{          type:terms,        field:"date_of_birth", facet: {   "metric":"sum(grade)" }  }} But what if I want to group only part of the

Re: java.lang.NullPointerException in json facet hll function

Hi, Any updates on this issue? I am using Solr 6.3 and I have hit this same bug... Thanks -- View this message in context: http://lucene.472066.n3.nabble.com/java-lang-NullPointerException-in-json-facet-hll-function-tp4265378p4337877.html Sent from the Solr - User mailing list archive

  1   2   3   >