Re: Performance improvements

2015-08-24 Thread naga sharathrayapati
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

Performance improvements

2015-08-24 Thread naga sharathrayapati
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?

json facet

2015-08-19 Thread naga sharathrayapati
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

Cache

2015-08-18 Thread naga sharathrayapati
Is it possible to clear the cache through query? I need this for performance valuation.

Re: joins

2015-08-16 Thread naga sharathrayapati
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? &

Re: joins

2015-08-16 Thread naga sharathrayapati
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

Re: Indexed & stored

2015-08-13 Thread naga sharathrayapati
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

Re: Indexed & stored

2015-08-13 Thread naga sharathrayapati
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

Re: docValues

2015-08-07 Thread naga sharathrayapati
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

docValues

2015-08-07 Thread naga sharathrayapati
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?

Re: Avoid re indexing

2015-08-01 Thread naga sharathrayapati
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

Avoid re indexing

2015-08-01 Thread naga sharathrayapati
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

Re: Sum Aggregate Query for a particular field

2015-07-27 Thread naga sharathrayapati
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

Re: serious JSON Facet bug

2015-07-25 Thread naga sharathrayapati
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 string/text fields w

Delete Documents

2015-07-17 Thread naga sharathrayapati
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