lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Bernstein <joels...@gmail.com>
Subject Re: How to use StreamingApi MultiFieldComparator?
Date Sat, 01 Oct 2016 22:26:35 GMT
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
>>>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message