Why you can't get score from child level and combining it on a parent level?
On Wed, Feb 1, 2017 at 5:33 PM, Ewald Moitzi <ewald.moi...@student.tugraz.at
> wrote:
> Hello Mikhail,
>
> I was using the functions as fl and sort parameters, and this
> gives no result.
>
> When sorting by score, as you did in your blog, I get the values
> from the child documents. (I missed the score=max parameter)
>
> However, i need to combine values from the parent and child, like
> this: {!func}sum(price_i, field_from_parent).
>
> At this point I get a SyntaxError like this:
> "org.apache.solr.search.SyntaxError: Expected ')' at position 32 in
> 'sum(shipping_cost_f,startup_cost'"
>
> But the ')' is there: sum(shipping_cost_f,startup_cost)
>
> Do I have the syntax wrong? Or is this function not allowed in this
> context?
>
> Thanks,
> Ewald
>
>
>
> On 2017-02-01 12:59, Mikhail Khludnev wrote:
> > Ewald,
> >
> > Functional queries combines well with block join as well as query time
> > join, here are examples for latter one
> > http://blog-archive.griddynamics.com/2015/08/
> scoring-join-party-in-solr-53.html
> > It must be the same for block join.
> > What doesn't work exactly?
> >
> > On Wed, Feb 1, 2017 at 1:39 PM, Ewald Moitzi <
> ewald.moi...@student.tugraz.at
> >> wrote:
> >
> >> Hello,
> >>
> >> I am unsure if solr is the right solution for a problem
> >> that we have, of if it is better to stick with a relational
> >> database (and if it should be done in solr how to implement it).
> >> The explanation is a bit lengthy, but please
> >> bear with me.
> >>
> >> The problem:
> >> Sort results of a vendor search for a product according to price
> >> including delivery costs.
> >>
> >> The data:
> >> The store itself is a marketplace, and each product can be
> >> supplied by different vendors. The vendors can define delivery
> >> costs for different price ranges.
> >> E.g:
> >>
> >> _price from_| price to_| delivery cost |
> >> | 0 | 49 | 10 |
> >> vendor --| 50 | 99 | 5 |
> >> | 100 | max | 0 |
> >>
> >> So, for product with a price of 55, I want the result to be 60.
> >>
> >> Additional requirements:
> >> - The product price is also calculated, based on properties
> >> of the vendor.
> >> - There is also a pickup option, and there should be no
> >> duplicate results.
> >> - Different shipping costs for different countries.
> >>
> >> Progress so far:
> >> My idea is to store each range as a subdocument for a vendor, but
> >> I don't know how to construct a query for that. So far I have
> >> managed to implement a simpler version that gives the right result for
> >> each country using dynamic fields, but this uses only a free delivery
> >> above x approach and that is not what we want.
> >>
> >> I have looked into the Block Join Query parser, but as far as I can
> >> tell this does not allow to construct a function query with inputs
> >> from parent and child documents.
> >>
> >> Why solr:
> >> - sort and limit result according to geolocation.
> >> - we will deploy solr anyhow in this project, for a classic
> >> full text search.
> >>
> >> As said above, I'm not really sure if this is a good application
> >> for solr, but the geolocation features are quite handy. And the
> >> query is not really fast in a relational db either.
> >>
> >> Any input is greatly appreciated.
> >>
> >> Regards,
> >> Ewald
> >>
> >>
> >
> >
>
--
Sincerely yours
Mikhail Khludnev
