Hey,
Thanks for the reply. I had gone through the link but unable to understand
how can i use facets in the following query
Select duration from tableName where solr_query='{"q":"(appName:\"test\")"}'
I want the query something like
Select SUM(duration) from tableName where solr_query='{"q":"(a
Yes. Have a look at the Facet API:
https://lucene.apache.org/solr/guide/7_5/json-facet-api.html
On Mon, Jan 28, 2019 at 6:07 AM naga pradeep dhulipalla <
naga.prade...@gmail.com> wrote:
> Hi Team,
>
>
>
> Can we use SUM aggregate function in our SOLR queries. If not is there an
> alternative to
Hi Team,
Can we use SUM aggregate function in our SOLR queries. If not is there an
alternative to achieve this.
My sample query looks like this as mentioned below.
Select duration from tableName where solr_query='{"q":"(appName:\"test\")"}'
I need the aggregate SUM value of duration colum
Hi,
Regarding the Solr JSON Facet Aggregate Functions, is it possible to round
off a value to a specific decimal place?
Currently, the values are like those below, which has more than 10 decimal
place.
"facets":{
"count":32,
"categories":{
"
olumns
..
countValue is always returning zero.
Can anyone help me in this regard.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Aggregate-functions-i
> -Original Message-
> From: Esteban Donato [mailto:esteban.don...@gmail.com]
> Sent: Monday, September 26, 2011 2:08 PM
> To: solr-user@lucene.apache.org
> Subject: aggregate functions in Solr?
>
> Hello guys,
>
> I need to implement a functionality which
Hello guys,
I need to implement a functionality which requires something similar
to aggregate functions in SQL. My Solr schema looks like this:
-doc_id: integer
-date: date
-value1: integer
-value2: integer
Basically the index contains some numerical values (value1, value2,
etc) per doc
It's actually an analyzed String. I figured that out after the first test
run.
On Thu, Aug 18, 2011 at 9:00 AM, Erick Erickson wrote:
> Side comment: Is your content field really a "string" value in your
> schema.xml? that's an un-analyzed type and unless you're
> always searching for *exactly*
Side comment: Is your content field really a "string" value in your
schema.xml? that's an un-analyzed type and unless you're
always searching for *exactly* the full contents of the field,
you'll have problems
Best
Erick
On Wed, Aug 17, 2011 at 2:20 PM, Daniel Skiles
wrote:
> I've recently st
17, 2011 2:15 PM
To: solr-user@lucene.apache.org
Subject: Re: Return records based on aggregate functions?
For response option 1, would I add the group.main=true and
group.format=simple parameters to the SolrQuery object?
On Wed, Aug 17, 2011 at 3:09 PM, Dyer, James wrote:
> For the request end
e-
> From: Daniel Skiles [mailto:daniel.ski...@docfinity.com]
> Sent: Wednesday, August 17, 2011 1:32 PM
> To: solr-user@lucene.apache.org
> Subject: Re: Return records based on aggregate functions?
>
> Woah. That looks like exactly what I need. Thanks you very much. Is
[mailto:daniel.ski...@docfinity.com]
Sent: Wednesday, August 17, 2011 1:32 PM
To: solr-user@lucene.apache.org
Subject: Re: Return records based on aggregate functions?
Woah. That looks like exactly what I need. Thanks you very much. Is there
any documentation for how to do that using the SolrJ API
Skiles [mailto:daniel.ski...@docfinity.com]
> Sent: Wednesday, August 17, 2011 1:20 PM
> To: solr-user@lucene.apache.org
> Subject: Return records based on aggregate functions?
>
> I've recently started using Solr and I'm stumped by a problem I'm currently
> encoun
-Original Message-
From: Daniel Skiles [mailto:daniel.ski...@docfinity.com]
Sent: Wednesday, August 17, 2011 1:20 PM
To: solr-user@lucene.apache.org
Subject: Return records based on aggregate functions?
I've recently started using Solr and I'm stumped by a problem I'm curr
I've recently started using Solr and I'm stumped by a problem I'm currently
encountering. Given that I can't really find anything close to what I'm
trying to do on Google or the mailing lists, I figured I'd ask if anyone
here had suggestions on how to do it.
I currently have a schema that looks m
Hi.
We would like to be able to create trend graphs which have date in the
X-axle and sum(pagerank) on the Y-Axle. We have the field pageRank stored as
an external field (since it is updated all the time).
I have started to build a SearchComponent which will be named something like
FacetFunctionC
Man I friend made me realize that facets will do the exact thing I want!
Example:
GET "
http://192.168.10.12:8110/solr/feedItem/select/?indent=true&q=title:test*&rows=0&facet=true&facet.date=publishDate&facet.date.start=NOW/DAY-30DAYS&facet.date.end=NOW/DAY%2B1DAY&facet.date.gap=%2B1DAY
"
you can try using the field collapse patch (currently in JIRA). You'll
probably need to manually extract the patch code and apply it yourself
as its latest update only applies to an earlier version of solr (1.3-dev).
http://issues.apache.org/jira/browse/SOLR-236
Cheers,
Uri
Marcus Herou wrote
Hi.
Anyone have an idea of how I would create a query which finds the data
backing a trend graph where date is X and num(docs) is on Y axis ?
This is quite a common use case in "buzz" analysis and currently I'm doing a
stupid query which iterates over the date range and queries lucene for every
d
19 matches
Mail list logo
