Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <CAE4tqLNLDOesj8eMv_1FhAZ60FjZbdfetj0V52jDu0t-d+2B4A@mail.gmail.com>
References: <CAP1TARGXzYA6+TSijhODbo3d5+Af_5zYVf18K4iA_E_NZexnuA@mail.gmail.com>
 <CAE4tqLMUSLagniFrxn4atCuyDhuqArdOFrEx3wO48e1aDsjp3g@mail.gmail.com> <CAE4tqLNLDOesj8eMv_1FhAZ60FjZbdfetj0V52jDu0t-d+2B4A@mail.gmail.com>
From: Joel Bernstein <joelsolr@gmail.com>
Date: Sat, 1 Oct 2016 18:26:35 -0400
Message-ID: <CAE4tqLNQ2Jp8vYeao-PvowSajtfm1Gn2Za_nwxS7YiDwwx9rOQ@mail.gmail.com>
Subject: Re: How to use StreamingApi MultiFieldComparator?
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a114fa59c2dd1fe053dd534bb
archived-at: Sat, 01 Oct 2016 22:26:49 -0000

--001a114fa59c2dd1fe053dd534bb
Content-Type: text/plain; charset=UTF-8

Also you'll probably need to specify the /export handler in the search
expressions, so you get the entire result set.

qt="/export"

Joel Bernstein
http://joelsolr.blogspot.com/

On Sat, Oct 1, 2016 at 6:08 PM, Joel Bernstein <joelsolr@gmail.com> wrote:

> Ok, I took a closer look at the expression. I believe this is not
> supported:
>
> sale_price_d!=c_sale_price_d
>
> Possibly the complement expression might accomplish what you're trying to
> do.
>
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Sat, Oct 1, 2016 at 5:59 PM, Joel Bernstein <joelsolr@gmail.com> wrote:
>
>> Hi can you attach the stack traces in the logs? I'd like to see where
>> this exception coming, this appears to be a bug.
>>
>> I'll also need to dig into your expression and see if there is an issue
>> with the syntax.
>>
>> Joel Bernstein
>> http://joelsolr.blogspot.com/
>>
>> On Sat, Oct 1, 2016 at 2:29 PM, Markko Legonkov <maxlego@gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> What i would like to achieve is that i want to filter out all products
>>> which have different prices on two given dates.
>>> Here is a sample expression
>>>
>>> leftOuterJoin(
>>>   search(
>>>     products,
>>>     q="*:*",
>>>     fq="product_id_i:1 AND product_name_s:test",
>>>     fl="id, product_id_i, product_name_s,sale_price_d",
>>>     sort="product_id_i asc"
>>>   ),
>>>   select(
>>>     search(
>>>       products,
>>>       q="product_id_i:1 AND product_name_s:Test",
>>>       fl="id, product_id_i, product_name_s,sale_price_d",
>>>       sort="product_id_i asc"
>>>     ),
>>>     id as c_id,
>>>     product_id_i as c_product_id_i,
>>>     product_name_s as c_product_name_s,
>>>     sale_price_d as c_sale_price_d
>>>   ),
>>>   on="product_id_i=c_product_id_i, sale_price_d!=c_sale_price_d"
>>> )
>>>
>>> I am using solr 6.2.0
>>> And the result i get from solr is:
>>> {
>>>   "result-set": {
>>>     "docs": [
>>>       {
>>>         "EXCEPTION": "org.apache.solr.client.solrj.
>>> io.comp.FieldComparator
>>> cannot be cast to
>>> org.apache.solr.client.solrj.io.comp.MultipleFieldComparator",
>>>         "EOF": true
>>>       }
>>>     ]
>>>   }
>>> }
>>>
>>> Do i have to configure something in solr that it knows it has to use
>>> MultipleFieldComparator?
>>>
>>> Regards
>>> Max
>>>
>>
>>
>

--001a114fa59c2dd1fe053dd534bb--