lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markko Legonkov <maxl...@gmail.com>
Subject Re: How to use StreamingApi MultiFieldComparator?
Date Mon, 03 Oct 2016 08:37:43 GMT
Thanks for quick response

Here is what i tried

complement(
search(
products,
qt="/export",
q="*:*",
fq="product_id_i:15940162",
fl="id, product_id_i, product_name_s,sale_price_d",
sort="product_id_i asc"
),
select(
search(
products,
qt="/export",
q="*:*",
fq="product_id_i:15940162",
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"
)

but still
{
  "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
      }
    ]
  }
}

On Sun, Oct 2, 2016 at 1:26 AM, Joel Bernstein <joelsolr@gmail.com> wrote:

> 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