You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Ewald Moitzi <ew...@student.tugraz.at> on 2017/02/01 10:39:21 UTC
1:n relation and function queries
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
Re: 1:n relation and function queries
Posted by Mikhail Khludnev <mk...@apache.org>.
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.moitzi@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.moitzi@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
Re: 1:n relation and function queries
Posted by Ewald Moitzi <ew...@student.tugraz.at>.
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.moitzi@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
>>
>>
>
>
Re: 1:n relation and function queries
Posted by Mikhail Khludnev <mk...@apache.org>.
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.moitzi@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