solr _route_ key now working

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

solr _route_ key now working

Jay Potharaju-2
Hi,
My document id has a format of a:b!c, when I query _route_="a:b!" it does
not return any values. Any suggestions?

Thanks
Jay Potharaju
Reply | Threaded
Open this post in threaded view
|

Re: solr _route_ key now working

Zheng Lin Edwin Yeo
Hi,

The character ":" is a special character, so it requires escaping during
the search.
You can try to search with query _route_="a\:b!".

Regards,
Edwin

On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <[hidden email]> wrote:

> Hi,
> My document id has a format of a:b!c, when I query _route_="a:b!" it does
> not return any values. Any suggestions?
>
> Thanks
> Jay Potharaju
>
Reply | Threaded
Open this post in threaded view
|

Re: solr _route_ key now working

Jay Potharaju-2
That did not work 😕. Any other suggestions
My id is 123:456!678
Tried running query as _route_=“123\:456!” But didn’t give expected results
Thanks
Jay

> On Mar 24, 2019, at 8:30 PM, Zheng Lin Edwin Yeo <[hidden email]> wrote:
>
> Hi,
>
> The character ":" is a special character, so it requires escaping during
> the search.
> You can try to search with query _route_="a\:b!".
>
> Regards,
> Edwin
>
>> On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <[hidden email]> wrote:
>>
>> Hi,
>> My document id has a format of a:b!c, when I query _route_="a:b!" it does
>> not return any values. Any suggestions?
>>
>> Thanks
>> Jay Potharaju
>>
Reply | Threaded
Open this post in threaded view
|

Re: solr _route_ key now working

Zheng Lin Edwin Yeo
Hi,

Sorry, didn't see that you have an exclamation mark in your query as well.
You will need to escape the exclamation mark as well.
So you can try it with the query _route_=“123\:456\!”

You can refer to the message in the link on which special characters
requires escaping.
https://stackoverflow.com/questions/21914956/which-special-characters-need-escaping-in-a-solr-query

By the way, which Solr version are you using?

Regards,
Edwin

On Tue, 26 Mar 2019 at 01:12, Jay Potharaju <[hidden email]> wrote:

> That did not work 😕. Any other suggestions
> My id is 123:456!678
> Tried running query as _route_=“123\:456!” But didn’t give expected
> results
> Thanks
> Jay
>
> > On Mar 24, 2019, at 8:30 PM, Zheng Lin Edwin Yeo <[hidden email]>
> wrote:
> >
> > Hi,
> >
> > The character ":" is a special character, so it requires escaping during
> > the search.
> > You can try to search with query _route_="a\:b!".
> >
> > Regards,
> > Edwin
> >
> >> On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <[hidden email]>
> wrote:
> >>
> >> Hi,
> >> My document id has a format of a:b!c, when I query _route_="a:b!" it
> does
> >> not return any values. Any suggestions?
> >>
> >> Thanks
> >> Jay Potharaju
> >>
>
Reply | Threaded
Open this post in threaded view
|

Re: Re: solr _route_ key now working

Branham, Jeremy (Experis)
Jay –
I’m not familiar with the document ID format you mention [having a “:” in the prefix], but it looks similar to the composite ID routing I’m using.
Document Id format: “a/1!id”

Then I can use a _route_ value of “a/1!” when querying.

Example Doc IDs:
a/1!768456
a/1!563575
b/1!456234
b/1!245698

The document ID prefix “x/1!” tells Solr to spread the documents over ½ of the available shards. When querying with the same value for _route_ it will retrieve documents only from those shards.
 
Jeremy Branham
[hidden email]

On 3/25/19, 9:13 PM, "Zheng Lin Edwin Yeo" <[hidden email]> wrote:

    Hi,
   
    Sorry, didn't see that you have an exclamation mark in your query as well.
    You will need to escape the exclamation mark as well.
    So you can try it with the query _route_=“123\:456\!”
   
    You can refer to the message in the link on which special characters
    requires escaping.
    https://urldefense.proofpoint.com/v2/url?u=https-3A__stackoverflow.com_questions_21914956_which-2Dspecial-2Dcharacters-2Dneed-2Descaping-2Din-2Da-2Dsolr-2Dquery&d=DwIFaQ&c=gtIjdLs6LnStUpy9cTOW9w&r=0SwsmPELGv6GC1_5JSQ9T7ZPMLljrIkbF_2jBCrKXI0&m=81cWucTr4zf8Cn2FliZ2fYFfqIb_g605mWVAxLxuQCc&s=30JCckpa6ctmrBupqeGhxJ7pPIcicy7VcIoeTEw_vpQ&e=
   
    By the way, which Solr version are you using?
   
    Regards,
    Edwin
   
    On Tue, 26 Mar 2019 at 01:12, Jay Potharaju <[hidden email]> wrote:
   
    > That did not work 😕. Any other suggestions
    > My id is 123:456!678
    > Tried running query as _route_=“123\:456!” But didn’t give expected
    > results
    > Thanks
    > Jay
    >
    > > On Mar 24, 2019, at 8:30 PM, Zheng Lin Edwin Yeo <[hidden email]>
    > wrote:
    > >
    > > Hi,
    > >
    > > The character ":" is a special character, so it requires escaping during
    > > the search.
    > > You can try to search with query _route_="a\:b!".
    > >
    > > Regards,
    > > Edwin
    > >
    > >> On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <[hidden email]>
    > wrote:
    > >>
    > >> Hi,
    > >> My document id has a format of a:b!c, when I query _route_="a:b!" it
    > does
    > >> not return any values. Any suggestions?
    > >>
    > >> Thanks
    > >> Jay Potharaju
    > >>
    >
   

Reply | Threaded
Open this post in threaded view
|

Re: Re: solr _route_ key now working

Jay Potharaju-2
Edwin, I tried escaping the special characters but it does not seems to
work. I am using 7.7
Thanks Jeremy for the example.
id:123:456!789
I do see that the data for the same key is co-located in the same shard by
running. I can see that all the data is co-located in the same shard when
querying the shard.
fq=fieldB:456&shards=shard1.

Any suggestions why that would not be working when using _route_ to query
the documents.

Thanks
Jay Potharaju



On Tue, Mar 26, 2019 at 5:58 AM Branham, Jeremy (Experis) <
[hidden email]> wrote:

> Jay –
> I’m not familiar with the document ID format you mention [having a “:” in
> the prefix], but it looks similar to the composite ID routing I’m using.
> Document Id format: “a/1!id”
>
> Then I can use a _route_ value of “a/1!” when querying.
>
> Example Doc IDs:
> a/1!768456
> a/1!563575
> b/1!456234
> b/1!245698
>
> The document ID prefix “x/1!” tells Solr to spread the documents over ½ of
> the available shards. When querying with the same value for _route_ it will
> retrieve documents only from those shards.
>
> Jeremy Branham
> [hidden email]
>
> On 3/25/19, 9:13 PM, "Zheng Lin Edwin Yeo" <[hidden email]> wrote:
>
>     Hi,
>
>     Sorry, didn't see that you have an exclamation mark in your query as
> well.
>     You will need to escape the exclamation mark as well.
>     So you can try it with the query _route_=“123\:456\!”
>
>     You can refer to the message in the link on which special characters
>     requires escaping.
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__stackoverflow.com_questions_21914956_which-2Dspecial-2Dcharacters-2Dneed-2Descaping-2Din-2Da-2Dsolr-2Dquery&d=DwIFaQ&c=gtIjdLs6LnStUpy9cTOW9w&r=0SwsmPELGv6GC1_5JSQ9T7ZPMLljrIkbF_2jBCrKXI0&m=81cWucTr4zf8Cn2FliZ2fYFfqIb_g605mWVAxLxuQCc&s=30JCckpa6ctmrBupqeGhxJ7pPIcicy7VcIoeTEw_vpQ&e=
>
>     By the way, which Solr version are you using?
>
>     Regards,
>     Edwin
>
>     On Tue, 26 Mar 2019 at 01:12, Jay Potharaju <[hidden email]>
> wrote:
>
>     > That did not work 😕. Any other suggestions
>     > My id is 123:456!678
>     > Tried running query as _route_=“123\:456!” But didn’t give expected
>     > results
>     > Thanks
>     > Jay
>     >
>     > > On Mar 24, 2019, at 8:30 PM, Zheng Lin Edwin Yeo <
> [hidden email]>
>     > wrote:
>     > >
>     > > Hi,
>     > >
>     > > The character ":" is a special character, so it requires escaping
> during
>     > > the search.
>     > > You can try to search with query _route_="a\:b!".
>     > >
>     > > Regards,
>     > > Edwin
>     > >
>     > >> On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <
> [hidden email]>
>     > wrote:
>     > >>
>     > >> Hi,
>     > >> My document id has a format of a:b!c, when I query _route_="a:b!"
> it
>     > does
>     > >> not return any values. Any suggestions?
>     > >>
>     > >> Thanks
>     > >> Jay Potharaju
>     > >>
>     >
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Re: solr _route_ key now working

Jay Potharaju-2
I was reading the debug info incorrectly it is working as expected
...thanks for the help.
Thanks
Jay Potharaju



On Tue, Mar 26, 2019 at 10:58 PM Jay Potharaju <[hidden email]>
wrote:

> Edwin, I tried escaping the special characters but it does not seems to
> work. I am using 7.7
> Thanks Jeremy for the example.
> id:123:456!789
> I do see that the data for the same key is co-located in the same shard by
> running. I can see that all the data is co-located in the same shard when
> querying the shard.
> fq=fieldB:456&shards=shard1.
>
> Any suggestions why that would not be working when using _route_ to query
> the documents.
>
> Thanks
> Jay Potharaju
>
>
>
> On Tue, Mar 26, 2019 at 5:58 AM Branham, Jeremy (Experis) <
> [hidden email]> wrote:
>
>> Jay –
>> I’m not familiar with the document ID format you mention [having a “:” in
>> the prefix], but it looks similar to the composite ID routing I’m using.
>> Document Id format: “a/1!id”
>>
>> Then I can use a _route_ value of “a/1!” when querying.
>>
>> Example Doc IDs:
>> a/1!768456
>> a/1!563575
>> b/1!456234
>> b/1!245698
>>
>> The document ID prefix “x/1!” tells Solr to spread the documents over ½
>> of the available shards. When querying with the same value for _route_ it
>> will retrieve documents only from those shards.
>>
>> Jeremy Branham
>> [hidden email]
>>
>> On 3/25/19, 9:13 PM, "Zheng Lin Edwin Yeo" <[hidden email]> wrote:
>>
>>     Hi,
>>
>>     Sorry, didn't see that you have an exclamation mark in your query as
>> well.
>>     You will need to escape the exclamation mark as well.
>>     So you can try it with the query _route_=“123\:456\!”
>>
>>     You can refer to the message in the link on which special characters
>>     requires escaping.
>>
>> https://urldefense.proofpoint.com/v2/url?u=https-3A__stackoverflow.com_questions_21914956_which-2Dspecial-2Dcharacters-2Dneed-2Descaping-2Din-2Da-2Dsolr-2Dquery&d=DwIFaQ&c=gtIjdLs6LnStUpy9cTOW9w&r=0SwsmPELGv6GC1_5JSQ9T7ZPMLljrIkbF_2jBCrKXI0&m=81cWucTr4zf8Cn2FliZ2fYFfqIb_g605mWVAxLxuQCc&s=30JCckpa6ctmrBupqeGhxJ7pPIcicy7VcIoeTEw_vpQ&e=
>>
>>     By the way, which Solr version are you using?
>>
>>     Regards,
>>     Edwin
>>
>>     On Tue, 26 Mar 2019 at 01:12, Jay Potharaju <[hidden email]>
>> wrote:
>>
>>     > That did not work 😕. Any other suggestions
>>     > My id is 123:456!678
>>     > Tried running query as _route_=“123\:456!” But didn’t give expected
>>     > results
>>     > Thanks
>>     > Jay
>>     >
>>     > > On Mar 24, 2019, at 8:30 PM, Zheng Lin Edwin Yeo <
>> [hidden email]>
>>     > wrote:
>>     > >
>>     > > Hi,
>>     > >
>>     > > The character ":" is a special character, so it requires escaping
>> during
>>     > > the search.
>>     > > You can try to search with query _route_="a\:b!".
>>     > >
>>     > > Regards,
>>     > > Edwin
>>     > >
>>     > >> On Mon, 25 Mar 2019 at 07:59, Jay Potharaju <
>> [hidden email]>
>>     > wrote:
>>     > >>
>>     > >> Hi,
>>     > >> My document id has a format of a:b!c, when I query
>> _route_="a:b!" it
>>     > does
>>     > >> not return any values. Any suggestions?
>>     > >>
>>     > >> Thanks
>>     > >> Jay Potharaju
>>     > >>
>>     >
>>
>>
>>