on) from tableName where solr_query='{"q":"(appName:\"
test\")"}'
Can you help on this.
On Mon, Jan 28, 2019 at 5:55 PM Scott Stults <
sstu...@opensourceconnections.com> wrote:
> Yes. Have a look at the Facet API:
> https://lucene.apache.org/solr
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
Pls send me .
Thanks ,
Naga
> On Nov 1, 2017, at 4:46 PM, Kojo wrote:
>
> I would like to try that!
>
>
> Em 1 de nov de 2017 18:04, "Will Hayes" escreveu:
>
> There is a community edition of App Studio for Solr and Elasticsearch being
> released by L
cet:{sum:"sum(amount)"},field:city,mincount:1}}},field:name,mincount:1}}},start:'NOW-2YEARS/DAY',field:date,gap:'%2B1DAYS'}}}
On Mon, Aug 24, 2015 at 6:50 PM, Yonik Seeley wrote:
> On Mon, Aug 24, 2015 at 6:33 PM, naga sharathrayapati
> wrote:
> > In order t
In order to improve the query time of nested faceting query (json facet
api), have used 'docValues' in the schema,optimized index and increased
cache sizes(no evictions)
I still cannot be bring the query time to less than 1 sec.
is there anything that i can do that can improve the performance?
is it possible to specify facet.method with json nested faceting query?
would like to see if there would be a performance improvement using methods
Is it possible to clear the cache through query?
I need this for performance valuation.
lexible if you can de-normlize your
> data
> rather than try to make Solr work like an RDBMS. Of course it goes against
> the training of all DB Admins, but it's often the best option.
>
> So have you explored denormalizing and do you know it's not a viable
> option?
&
Is there any chance of this feature(merge the results to create a composite
document) coming out in the next release 5.3 ?
On Sun, Aug 16, 2015 at 2:08 PM, Upayavira wrote:
> You can do what are called "pseudo joins", which are eqivalent to a
> nested query in SQL. You get back data from one cor
Do we need to specify stored='true' even when we specify docValues='true'
in the schema
is docValues not the alternate of stored?
On Thu, Aug 13, 2015 at 2:48 PM, Shawn Heisey wrote:
> On 8/13/2015 9:07 AM, Erick Erickson wrote:
> > No. But how do they default to "true"? In the fieldType? Which
what if i do something like this in the schema
will the filed name be stored? or not stored? as i have not specified in
the schema as stored='true'/'false'.
On Thu, Aug 13, 2015 at 10:07 AM, Erick Erickson
wrote:
> No. But how do they default to "true"? In the fieldType? Which will be
> poten
JVM-Memory has gone up from 3% to 17.1%
On Fri, Aug 7, 2015 at 12:10 PM, Shawn Heisey wrote:
> On 8/7/2015 10:25 AM, naga sharathrayapati wrote:
> > i have added docValues="true" to my existing schema and I have seen
> > exponential increase in the size of the index.
&g
i have added docValues="true" to my existing schema and I have seen
exponential increase in the size of the index.
The reason in going with docValues is to improve the faceting query time.
schema:
Is this ok? am i doing anything wrong in the schema?
indexing the whole data (worth hours) and we have gone with
good number of shards but there is a rapid increase of size in data over
the past few days, do you think is it worth logging a ticket?
On Sat, Aug 1, 2015 at 5:04 PM, Upayavira wrote:
>
>
> On Sat, Aug 1, 2015, at 10:30
I have an exception with one of the document after indexing 6 mil documents
out of 10 mil, is there any way i can avoid re indexing the 6 mil
documents?
I also see that there are few documents that are deleted (based on the
count) while indexing, is there a way to identify what are those documents
try these
total sum of individual items:
/select?q=*:*&wt=json&indent=true&rows=0&json.facet={itemprice:{terms:{facet:{sum:"sum(price)"},field:item,limit:100,mincount:1}}}
sum of all the items:
/select?q=*:*&wt=json&indent=true&rows=0&json.facet={sum:"sum(price)"}
On Mon, Jul 27, 2015 at 6:12
Yonik,
Did you see this issue with 5.2 as well or only 5.1?
Thanks,
Naga
On Fri, Jul 24, 2015 at 9:15 PM, Yonik Seeley wrote:
> On Fri, Jul 24, 2015 at 8:03 PM, Nagasharath
> wrote:
> > Is there a jira logged for this issue?
>
> * SOLR-7781: JSON Facet API: Terms facet on
Hey,
I understand that "DocExpirationUpdateProcessorFactory" in the config.xml
can be specified to delete documents based on the expiration.
I would like to understand whether there is a chance of these deleted
documents getting re-indexed?
Solr 5.2
Thanks
… Any idea, anyone?
Thanks
Naga
Finally got a handle on this by looking into the New Admin UI -
http://localhost:8983/solr/#/~cloud
Thanks
Naga
On 5/15/12 12:53 PM, "Naga Vijayapuram" wrote:
>Alright; thanks. Tried with "-OPTIONS=jsp" and am still seeing this on
>console Š
>
>2012-05-
ion1/admin/zookeeper.jsp (or its
equivalent in 4.0) after going through
http://wiki.apache.org/solr/SolrCloud
May I know the right zookeeper url in 4.0 please?
Thanks
Naga
On 5/15/12 10:56 AM, "Ryan McKinley" wrote:
>In 4.0, solr no longer uses JSP, so it is not enabled in the exa
Hello,
How do I enable JSP support in Solr 4.0 ?
Thanks
Naga
nformation.
regards,
Naga Ranjan
-Original Message-
From: RamaKrishna Atmakur [mailto:ramkrishn...@hotmail.com]
Sent: Thursday, May 13, 2010 5:57 AM
To: solr-user@lucene.apache.org
Subject: Strange behavior for certain words
Hi,
We are trying to use SOLR for searching our catalog
You may create a new field by copying the fields title, category and tag to the
new field, like the following:
and search against the new field. You may go for newField of type "textgen".
Give it a try,
Naga
From: MitchK [mitc...@we
I've tried and it is working fine. But, still would like to know
whether I can specify two fields against fmap.content.
regards,
Naga
-Original Message-
From: Naga Darbha [mailto:ndar...@opentext.com]
Sent: Tuesday, May 04, 2010 12:20 PM
To: solr-user@lucene.apache.org
Su
ds against fmap.content?
regards,
Naga
for
"friend dear" I should not get any records.
Please help.
regards,
Naga
populating the
clubbed_string with the values of field_A and field_B.
Do I need to populate clubbed_string by explicitly copying field_A and field_B
directly to it?
Please help.
regards,
Naga
I tried "-" even, but it works only with standard queries, but not "dismax".
regards,
Naga
-Original Message-
From: Koji Sekiguchi [mailto:k...@r.email.ne.jp]
Sent: Thursday, April 29, 2010 9:46 AM
To: solr-user@lucene.apache.org
Subject: Re: NOT keyword - does
th dismax query type?
regards,
Naga
Hi,
I think copyField copies the un-processed content (that will be processed by
source field) onto the target field and processes it based on target field's
type. It is *copied first*.
regards,
Naga
-Original Message-
From: Jan Simon Winkelmann [mailto:winkelm...@newsfacto
Thanks Ahmet, I used that approach and it is working well.
-Original Message-
From: Ahmet Arslan [mailto:iori...@yahoo.com]
Sent: Wednesday, April 21, 2010 2:36 PM
To: solr-user@lucene.apache.org
Subject: Re: sorting on text field fails
> I have a field configured as text type (default t
ible to sort on tokenized fields
How can I sort on a tokenized field?
regards,
Naga
Yes, both have same filters, so we can avoid specifying analyzer type.
- Naga
-Original Message-
From: MitchK [mailto:mitc...@web.de]
Sent: Monday, April 19, 2010 9:44 PM
To: solr-user@lucene.apache.org
Subject: Re: Stemming - disable at query time - reg.
Additionally to Alejandro&#
" it is not giving me any results, whereas when I search for
"work" it is giving me two results.
What should I be doing to get the query results for "working".
regards,
Naga
-Original Message-
From: Naga Darbha [mailto:ndar...@opentext.com]
Sent: Monday, April 19, 20
Thank you Mitch! I will try that.
regards,
Naga
-Original Message-
From: MitchK [mailto:mitc...@web.de]
Sent: Monday, April 19, 2010 2:35 PM
To: solr-user@lucene.apache.org
Subject: Re: Stemming - disable at query time - reg.
Naga,
1) Yes, it is possible
emText"
is not configured with the PorterFilterFactory.
regards,
Naga
hi all,
I am disparately in need some webpages that uses solr at backend and
display the results..
Plz can u send some PHP codes tht resembles like Google that uses Solr.
Im new to solr.
I m in need of some basic help regarding solr?
1)In which format the posted data will store in SOLR?
how the data are stored in solr?
2) what is the concept of replication in SOLR?
3) suppose in my schema.xml i had the format like ,, and
i had posted nearly 50 documents.
Now iu need to post
39 matches
Mail list logo
