By multivalued I meant an array of values. For example: <arr name="myfield"> <str>text1 (X)</str> <str>text2 (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. Regards. On 16 July 2013 10:26, Oleg Burlaca <oburl...@gmail.com> wrote: > 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, again, at > indexing level, > split the text into pieces and index it in solr like this: > > record_id | text | value > 10 | text N1 | X > 10 | text N2 | Y > 10 | text N3 | Z > > does it help? > > > > On Tue, Jul 16, 2013 at 10:51 AM, Marcin Rzewucki <mrzewu...@gmail.com > >wrote: > > > 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 indexing time. > > > > > > -- > > > Oleg > > > > > > > > > On Tue, Jul 16, 2013 at 10:12 AM, Marcin Rzewucki <mrzewu...@gmail.com > > > >wrote: > > > > > > > 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 brackets. > > > > I'd like to find documents with the given text say "this is a text" > and > > > > "number" between A and B. Is it possible in Solr ? Any ideas ? > > > > > > > > Kind regards. > > > > > > > > > >
