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 <joels...@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 <maxl...@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 >> > >