Date Range query in Solr

Hi all, what will be the syntex of this sql query SELECT * FROM table WHERE date <= CURRENT_DATE in solr format ? Thanks in advance. Regards: Bhawani Sharma -- View this message in context: http://www.nabble.com/Date-Range-query-in-Solr-tp21214216p21214216.html Sent from the Solr - User mai

Re: Delta DataImport is not picking the modified value in DB

Thanks Shalin and Noble for all the help. I looked into the source code of 1.3 for the Null Pointer that I was getting. And indeed, there was a problem. In release 1.3, SqlEntityProcessor doesnt handle 'deltaImportQuery' for delta imports. But this problem is fixed in the nightly build. So now

Re: Date Range query in Solr

There is no table in Solr -- all fields are in the same schema. For the date you can try using the following as the 'q' parameter: date:[* TO NOW] On Tue, Dec 30, 2008 at 1:43 PM, Bhawani Sharma wrote: > > Hi all, > what will be the syntex of this sql query > SELECT * FROM table WHERE date <= CU

Re: Delta DataImport is not picking the modified value in DB

On Tue, Dec 30, 2008 at 3:33 PM, Manupriya wrote: > > Thanks Shalin and Noble for all the help. > > I looked into the source code of 1.3 for the Null Pointer that I was > getting. And indeed, there was a problem. In release 1.3, > SqlEntityProcessor > doesnt handle 'deltaImportQuery' for delta imp

Re: Delta DataImport is not picking the modified value in DB

You do not have to take up complete trunk. Solr can continue to be 1.3 and DIH can be a nightly . DIH is shipped as a separate jar in the same .war file This can minimize your risks On Tue, Dec 30, 2008 at 4:54 PM, Shalin Shekhar Mangar wrote: > On Tue, Dec 30, 2008 at 3:33 PM, Manupriya wrote

Re: High response times after snapshot install

Hello Otis, Thank you for the reply. But, if the high response time is caused by IO and CPU usage... it shouldn't come back to regular response time after a while? Also, we're not seeing that much CPU usage. What if some requests got stuck, and the old searchers are not being destroyed?

synonyms.txt file updated frequently

Hello guys, As the title suggests I must update my synonyms.txt file frequently. What is the best approach? Should I send a commit after the file is updated? Does Solr need to be restarted after the file changes? -- Alexander Ramos Jardim

Re: synonyms.txt file updated frequently

You need to reload the core (if you're using SolrCore). If you're not using SolrCore then I'm afraid you'll have to bring down them up the web-app. ~ David On 12/30/08 8:12 AM, "Alexander Ramos Jardim" wrote: Hello guys, As the title suggests I must update my synonyms.txt file frequently.

Re: synonyms.txt file updated frequently

I'd probably write a new TokenFilter that was aware of the reload policy (in a generic way) such that I didn't have to go through a whole core reload every time. Are you just using them during query time or also during indexing? -Grant On Dec 30, 2008, at 8:12 AM, Alexander Ramos Jardim w

Re: synonyms.txt file updated frequently

Hey Grant, Thanks for the info! 2008/12/30 Grant Ingersoll > I'd probably write a new TokenFilter that was aware of the reload policy > (in a generic way) such that I didn't have to go through a whole core reload > every time. Are you just using them during query time or also during > indexing

Re: Local Solr - Error creating document with DIH

Thanks, That worked perfectly. Noble Paul നോബിള്‍ नोब्ळ् wrote: > > apparently the local solr expects everything as string. I guess we > must raise an issue with them. > meanwhile you can convert those double fields to String using > TemplateTransformer > > > > > > > On Tue, Dec 30, 200

Re: Understanding Filters

Jim - I'm interested in doing something similar and was wondering if you ever got a response. I've looked at the solr source code and have some ideas about where to apply additional filtering but they're not that elegant. >From what I can see, if you add an additional search component after the

Re: High response times after snapshot install

Hi Victor, The IO and CPU usage should go down with time, unless you are reopening your searcher too frequently and your server is always busy doing what I described in the previous email. You should provide us with relevant info/numbers from your Solr admin stats page, output of top, vmstat,

Re: synonyms.txt file updated frequently

On Dec 30, 2008, at 11:05 AM, Alexander Ramos Jardim wrote: Hey Grant, Thanks for the info! 2008/12/30 Grant Ingersoll I'd probably write a new TokenFilter that was aware of the reload policy (in a generic way) such that I didn't have to go through a whole core reload every time. Are

Re: synonyms.txt file updated frequently

Grant, the Solr wiki recommends doing expansion at index time and gives reasons: http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters#head-2c461ac74b4ddd82e453dc68fcfc92da77358d46 Query-time doesn't work for multi-word expansion. For everyone's convenience, I'll quote the remainder of the

Associating scores with fields?

Hi, I'd like to get scores for all fields within my returned docs. My current solution is to parse the debug information but because I often have multiple fields with the same name this doesn't always work too well. Is there a way to get something to the effect of: Thanks, Mike -- View this

RE: http internal error if i enable debugQuery=on

you mean query term? if so i do have ?q=xyz etc... if not what is that parameter you are talking about?i will send to only one mailing list here on.thanks,vinay> Date: Mon, 29 Dec 2008 18:38:33 -0800> From: otis_gospodne...@yahoo.com> Subject: Re: http internal error if i enable debugQuery=on>

Re: http internal error if i enable debugQuery=on

Vinay, You may want to check your email setting - your emails are very hard to read because of the wrapping text. "q" is the parameter I was talking about. I can't tell from your emails what you might be doing wrong or where the bug might be. Otis -- Sematext -- http://sematext.com/ -- Lucene

Re: Associating scores with fields?

Mike, There is nothing that exposes per-field scores in Solr and not even in Lucene, but if you want per-field scores I'd recommend looking at Lucene Scorer & friends first. See also http://lucene.apache.org/java/2_4_0/scoring.html Otis -- Sematext -- http://sematext.com/ -- Lucene - Solr - Nu

Problem with query response writer when upgrading from Solr1.2 to solr1.3

Hi, I just upgraded my system from Solr 1.2 to Solr 1.3. I am using the same plugin for the queryResponseWriter that I used in Solr1.2. Problem here is that when I am using *wt* parameter as the plugin name with full package then I don't get the response which I used to get in 1.2 and when I don

Re: Problem with query response writer when upgrading from Solr1.2 to solr1.3

The wt parameter accepts the 'name' you gave in solrconfig while specifying your custom response writer. I don't think there has been any change in handling of wt which would result in the behavior you are seeing. Are there any exceptions in the Solr log? Is the jar with the custom response writer