Range query on a substring.

2013-07-16 Thread Marcin Rzewucki
Hi, I have a problem (wonder if it is possible to solve it at all) with the following query. There are documents with a field which contains a text and a number in brackets, eg. myfield: this is a text (number) There might be some other documents with the same text but different number in

Re: Range query on a substring.

2013-07-16 Thread Oleg Burlaca
IMHO the number(s) should be extracted and stored in separate columns in SOLR at indexing time. -- Oleg On Tue, Jul 16, 2013 at 10:12 AM, Marcin Rzewucki mrzewu...@gmail.comwrote: Hi, I have a problem (wonder if it is possible to solve it at all) with the following query. There are

Re: Range query on a substring.

2013-07-16 Thread Marcin Rzewucki
Hi Oleg, It's a multivalued field and it won't be easier to query when I split this field into text and numbers. I may get wrong results. Regards. On 16 July 2013 09:35, Oleg Burlaca oburl...@gmail.com wrote: IMHO the number(s) should be extracted and stored in separate columns in SOLR at

Re: Range query on a substring.

2013-07-16 Thread Oleg Burlaca
Ah, you mean something like this: record: Id=10, text = this is a text N1 (X), another text N2 (Y), text N3 (Z) Id=11, text = this is a text N1 (W), another text N2 (Q), third text (M) and you need to search for: text N1 and X B ? How big is the core? the first thing that comes to my mind,

Re: Range query on a substring.

2013-07-16 Thread Marcin Rzewucki
By multivalued I meant an array of values. For example: arr name=myfield strtext1 (X)/str strtext2 (Y)/str /arr I'd like to avoid spliting it as you propose. I have 2.3mn collection with pretty large records (few hundreds fields and more per record). Duplicating them would impact performance.

Re: Range query on a substring.

2013-07-16 Thread Jack Krupansky
as a range query on a substring in Solr or Lucene. -- Jack Krupansky -Original Message- From: Marcin Rzewucki Sent: Tuesday, July 16, 2013 5:13 AM To: solr-user@lucene.apache.org Subject: Re: Range query on a substring. By multivalued I meant an array of values. For example: arr name

Re: Range query on a substring.

2013-07-16 Thread Roman Chyla
Well, I think this is slightly too categorical - a range query on a substring can be thought of as a simple range query. So, for example the following query: lucene 1* becomes behind the scenes: lucene (10|11|12|13|14|1abcd) the issue there is that it is a string range, but it is a range query

Re: Range query on a substring.

2013-07-16 Thread Marcin Rzewucki
to spend some time on ANTLR and the new way of parsing you mentioned. I will let you know if it was useful for me. Thanks. Kind regards. On 16 July 2013 20:07, Roman Chyla roman.ch...@gmail.com wrote: Well, I think this is slightly too categorical - a range query on a substring can be thought

Re: Range query on a substring.

2013-07-16 Thread Roman Chyla
if it was useful for me. Thanks. Kind regards. On 16 July 2013 20:07, Roman Chyla roman.ch...@gmail.com wrote: Well, I think this is slightly too categorical - a range query on a substring can be thought of as a simple range query. So, for example the following query: lucene 1

Re: Range query on a substring.

2013-07-16 Thread Ahmet Arslan
: Re: Range query on a substring. Hi guys, First of all, thanks for your response. Jack: Data structure was created some time ago and this is a new requirement in my project. I'm trying to find a solution. I wouldn't like to split multivalued field into N similar records varying

Re: Range query on a substring.

2013-07-16 Thread Jack Krupansky
, 2013 6:33 PM To: solr-user@lucene.apache.org Subject: Re: Range query on a substring. Hi Macrin, May be you can use https://issues.apache.org/jira/browse/SOLR-1604 . ComplexPhraseQueryParser supports ranges inside phrases. From: Marcin Rzewucki mrzewu