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 jotpe <jo...@posteo.de> on 2017/05/11 10:36:39 UTC
Subquery substitution for pt
Dear list,
i work a lot with subqueries. And its Wirkung fine for me.
Now I ran into the problem, that the qt parameter for the geodist() function rejects to use the document field coordinate as inputvalue for my subquery.
I want somethong linke this
fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist() asc&n.sfield=coordinate
Is this possible without a second query?
Best regards.
Re: Subquery substitution for pt
Posted by Mikhail Khludnev <mk...@apache.org>.
Not at all. I don't know whether it works or doesn't. There is no
a testcase proving it. It might be that there is a trick to make it work.
On Thu, May 11, 2017 at 8:01 PM, jotpe <jo...@posteo.de> wrote:
> Thank you. Okay, so you think, this should work, too.
>
> Best regards Johannes
>
> Am 11. Mai 2017 17:14:45 MESZ schrieb Mikhail Khludnev <mk...@apache.org>:
> >Can't say anything. Just raised
> >https://issues.apache.org/jira/browse/SOLR-10673.
> >
> >On Thu, May 11, 2017 at 4:13 PM, jotpe <jo...@posteo.de> wrote:
> >
> >> A InvalidShapeException is thrown: Point must be in 'lat, lon' or 'x
> >y'
> >> format
> >>
> >> I can see in the after this error, that in /select is an
> >> &row.coordinate=50.9,6.9 in the params{} section.
> >>
> >> But the parameter qt stays empty. ...&pt=&q=*:*
> >>
> >> Am 11. Mai 2017 14:42:41 MESZ schrieb Mikhail Khludnev
> ><mk...@apache.org>:
> >> >What does appear in logs? It should log subquery request param right
> >> >after
> >> >an exception (if there is an exception).
> >> >
> >> >On Thu, May 11, 2017 at 1:36 PM, jotpe <jo...@posteo.de> wrote:
> >> >
> >> >> Dear list,
> >> >>
> >> >> i work a lot with subqueries. And its Wirkung fine for me.
> >> >> Now I ran into the problem, that the qt parameter for the
> >geodist()
> >> >> function rejects to use the document field coordinate as
> >inputvalue
> >> >for my
> >> >> subquery.
> >> >>
> >> >> I want somethong linke this
> >> >>
> >> >> fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist()
> >> >> asc&n.sfield=coordinate
> >> >>
> >> >> Is this possible without a second query?
> >> >> Best regards.
> >> >>
> >> >>
> >> >
> >> >
> >> >--
> >> >Sincerely yours
> >> >Mikhail Khludnev
> >>
> >
> >
> >
> >--
> >Sincerely yours
> >Mikhail Khludnev
>
--
Sincerely yours
Mikhail Khludnev
Re: Subquery substitution for pt
Posted by jotpe <jo...@posteo.de>.
Thank you. Okay, so you think, this should work, too.
Best regards Johannes
Am 11. Mai 2017 17:14:45 MESZ schrieb Mikhail Khludnev <mk...@apache.org>:
>Can't say anything. Just raised
>https://issues.apache.org/jira/browse/SOLR-10673.
>
>On Thu, May 11, 2017 at 4:13 PM, jotpe <jo...@posteo.de> wrote:
>
>> A InvalidShapeException is thrown: Point must be in 'lat, lon' or 'x
>y'
>> format
>>
>> I can see in the after this error, that in /select is an
>> &row.coordinate=50.9,6.9 in the params{} section.
>>
>> But the parameter qt stays empty. ...&pt=&q=*:*
>>
>> Am 11. Mai 2017 14:42:41 MESZ schrieb Mikhail Khludnev
><mk...@apache.org>:
>> >What does appear in logs? It should log subquery request param right
>> >after
>> >an exception (if there is an exception).
>> >
>> >On Thu, May 11, 2017 at 1:36 PM, jotpe <jo...@posteo.de> wrote:
>> >
>> >> Dear list,
>> >>
>> >> i work a lot with subqueries. And its Wirkung fine for me.
>> >> Now I ran into the problem, that the qt parameter for the
>geodist()
>> >> function rejects to use the document field coordinate as
>inputvalue
>> >for my
>> >> subquery.
>> >>
>> >> I want somethong linke this
>> >>
>> >> fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist()
>> >> asc&n.sfield=coordinate
>> >>
>> >> Is this possible without a second query?
>> >> Best regards.
>> >>
>> >>
>> >
>> >
>> >--
>> >Sincerely yours
>> >Mikhail Khludnev
>>
>
>
>
>--
>Sincerely yours
>Mikhail Khludnev
Re: Subquery substitution for pt
Posted by Mikhail Khludnev <mk...@apache.org>.
Can't say anything. Just raised
https://issues.apache.org/jira/browse/SOLR-10673.
On Thu, May 11, 2017 at 4:13 PM, jotpe <jo...@posteo.de> wrote:
> A InvalidShapeException is thrown: Point must be in 'lat, lon' or 'x y'
> format
>
> I can see in the after this error, that in /select is an
> &row.coordinate=50.9,6.9 in the params{} section.
>
> But the parameter qt stays empty. ...&pt=&q=*:*
>
> Am 11. Mai 2017 14:42:41 MESZ schrieb Mikhail Khludnev <mk...@apache.org>:
> >What does appear in logs? It should log subquery request param right
> >after
> >an exception (if there is an exception).
> >
> >On Thu, May 11, 2017 at 1:36 PM, jotpe <jo...@posteo.de> wrote:
> >
> >> Dear list,
> >>
> >> i work a lot with subqueries. And its Wirkung fine for me.
> >> Now I ran into the problem, that the qt parameter for the geodist()
> >> function rejects to use the document field coordinate as inputvalue
> >for my
> >> subquery.
> >>
> >> I want somethong linke this
> >>
> >> fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist()
> >> asc&n.sfield=coordinate
> >>
> >> Is this possible without a second query?
> >> Best regards.
> >>
> >>
> >
> >
> >--
> >Sincerely yours
> >Mikhail Khludnev
>
--
Sincerely yours
Mikhail Khludnev
Re: Subquery substitution for pt
Posted by jotpe <jo...@posteo.de>.
A InvalidShapeException is thrown: Point must be in 'lat, lon' or 'x y' format
I can see in the after this error, that in /select is an &row.coordinate=50.9,6.9 in the params{} section.
But the parameter qt stays empty. ...&pt=&q=*:*
Am 11. Mai 2017 14:42:41 MESZ schrieb Mikhail Khludnev <mk...@apache.org>:
>What does appear in logs? It should log subquery request param right
>after
>an exception (if there is an exception).
>
>On Thu, May 11, 2017 at 1:36 PM, jotpe <jo...@posteo.de> wrote:
>
>> Dear list,
>>
>> i work a lot with subqueries. And its Wirkung fine for me.
>> Now I ran into the problem, that the qt parameter for the geodist()
>> function rejects to use the document field coordinate as inputvalue
>for my
>> subquery.
>>
>> I want somethong linke this
>>
>> fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist()
>> asc&n.sfield=coordinate
>>
>> Is this possible without a second query?
>> Best regards.
>>
>>
>
>
>--
>Sincerely yours
>Mikhail Khludnev
Re: Subquery substitution for pt
Posted by Mikhail Khludnev <mk...@apache.org>.
What does appear in logs? It should log subquery request param right after
an exception (if there is an exception).
On Thu, May 11, 2017 at 1:36 PM, jotpe <jo...@posteo.de> wrote:
> Dear list,
>
> i work a lot with subqueries. And its Wirkung fine for me.
> Now I ran into the problem, that the qt parameter for the geodist()
> function rejects to use the document field coordinate as inputvalue for my
> subquery.
>
> I want somethong linke this
>
> fl=n:[subquery],name&n.pt=${row.coordinate}&n.sort=geodist()
> asc&n.sfield=coordinate
>
> Is this possible without a second query?
> Best regards.
>
>
--
Sincerely yours
Mikhail Khludnev