subject:"How can I sort results by

Re: How can I sort results by _id?

2015-01-15 Thread Itamar Syn-Hershko

No, an ID has to be a string

--

Itamar Syn-Hershko
http://code972.com | @synhershko 
Freelance Developer & Consultant
Author of RavenDB in Action 

On Thu, Jan 15, 2015 at 12:12 PM, Jason Zhang  wrote:

> Can I specify its type as integer in _mapping? Because the _id I use is
> rewritten.
>
> On Thursday, January 15, 2015 at 6:07:22 PM UTC+8, Adrien Grand wrote:
>>
>> This is because the _id is a string field, so comparison is based on the
>> lexicographical order, not numeric.
>>
>> On Thu, Jan 15, 2015 at 11:04 AM, Jason Zhang  wrote:
>>
>>> What I'm confused is the 'sorted' results are still partly unordered.
>>>
>>> Also, if I query:
>>>
>>> {  "range": {
>>> "_id": {
>>>   "gt": "1",
>>>   "lt": "1"}}}
>>>
>>> the results contain "_id": 199989.
>>>
>>> On Thursday, January 15, 2015 at 5:48:48 PM UTC+8, Adrien Grand wrote:

 Making it index:not_analyzed should work, what is the issue with the
 results?

 Note that loading the _id in fielddata is typically very costly since
 the _id field is typically unique per document.

 On Thu, Jan 15, 2015 at 10:35 AM, Jason Zhang  wrote:

> I use a query dsl like:
>
> {
>   "filter": {
> "exists": { "field": "info" }
>   },
>   "sort": { "_id": "desc" }
> }
>
> And the "_id" here is an integer like '123'.
>
> But the result is like:
>
> {
>   "took": 50,
>   ...
>   "hits": {
> ...
> "hits": [
>   {
> ...
> "sort": [ null ]
>   }]
>   }
> }
>
> Also, I've tried to add "_id": { "index": "not_analyzerd" } in the
> _mapping.
> This time the "sort" section returns values. But I find the results
> are still partly unordered.
>
> Can I sort results by _id? How?
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google
> Groups "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to elasticsearc...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%40goo
> glegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



 --
 Adrien Grand

>>>  --
>>> You received this message because you are subscribed to the Google
>>> Groups "elasticsearch" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to elasticsearc...@googlegroups.com.
>>> To view this discussion on the web visit https://groups.google.com/d/
>>> msgid/elasticsearch/b7f625dd-8afd-4603-afc8-1fd6d5b601d1%
>>> 40googlegroups.com
>>> 
>>> .
>>>
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Adrien Grand
>>
>  --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to elasticsearch+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/2475cb1a-5631-4b06-8507-28c4d81f9d4d%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZvWQtGKE6JDd6%3D%2BXRJENrAyLPkTE3%2BBRpFsEJ%2BS09bTpg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I sort results by _id?

2015-01-15 Thread Jason Zhang

Can I specify its type as integer in _mapping? Because the _id I use is 
rewritten.

On Thursday, January 15, 2015 at 6:07:22 PM UTC+8, Adrien Grand wrote:
>
> This is because the _id is a string field, so comparison is based on the 
> lexicographical order, not numeric.
>
> On Thu, Jan 15, 2015 at 11:04 AM, Jason Zhang  > wrote:
>
>> What I'm confused is the 'sorted' results are still partly unordered.
>>
>> Also, if I query:
>>
>> {  "range": {
>> "_id": {
>>   "gt": "1",
>>   "lt": "1"}}}
>>
>> the results contain "_id": 199989.
>>
>> On Thursday, January 15, 2015 at 5:48:48 PM UTC+8, Adrien Grand wrote:
>>>
>>> Making it index:not_analyzed should work, what is the issue with the 
>>> results?
>>>
>>> Note that loading the _id in fielddata is typically very costly since 
>>> the _id field is typically unique per document.
>>>
>>> On Thu, Jan 15, 2015 at 10:35 AM, Jason Zhang  wrote:
>>>
 I use a query dsl like:

 {
   "filter": {
 "exists": { "field": "info" }
   },
   "sort": { "_id": "desc" }
 }

 And the "_id" here is an integer like '123'.

 But the result is like:

 { 
   "took": 50,
   ...
   "hits": {
 ...
 "hits": [
   {
 ...
 "sort": [ null ]
   }]
   }
 }

 Also, I've tried to add "_id": { "index": "not_analyzerd" } in the 
 _mapping.
 This time the "sort" section returns values. But I find the results are 
 still partly unordered.

 Can I sort results by _id? How?

 Thank you.

 -- 
 You received this message because you are subscribed to the Google 
 Groups "elasticsearch" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to elasticsearc...@googlegroups.com.
 To view this discussion on the web visit https://groups.google.com/d/
 msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%
 40googlegroups.com 
 
 .
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>>
>>> -- 
>>> Adrien Grand
>>>  
>>  -- 
>> You received this message because you are subscribed to the Google Groups 
>> "elasticsearch" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to elasticsearc...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/elasticsearch/b7f625dd-8afd-4603-afc8-1fd6d5b601d1%40googlegroups.com
>>  
>> 
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Adrien Grand
>  

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/2475cb1a-5631-4b06-8507-28c4d81f9d4d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I sort results by _id?

2015-01-15 Thread Adrien Grand

This is because the _id is a string field, so comparison is based on the
lexicographical order, not numeric.

On Thu, Jan 15, 2015 at 11:04 AM, Jason Zhang  wrote:

> What I'm confused is the 'sorted' results are still partly unordered.
>
> Also, if I query:
>
> {  "range": {
> "_id": {
>   "gt": "1",
>   "lt": "1"}}}
>
> the results contain "_id": 199989.
>
> On Thursday, January 15, 2015 at 5:48:48 PM UTC+8, Adrien Grand wrote:
>>
>> Making it index:not_analyzed should work, what is the issue with the
>> results?
>>
>> Note that loading the _id in fielddata is typically very costly since the
>> _id field is typically unique per document.
>>
>> On Thu, Jan 15, 2015 at 10:35 AM, Jason Zhang  wrote:
>>
>>> I use a query dsl like:
>>>
>>> {
>>>   "filter": {
>>> "exists": { "field": "info" }
>>>   },
>>>   "sort": { "_id": "desc" }
>>> }
>>>
>>> And the "_id" here is an integer like '123'.
>>>
>>> But the result is like:
>>>
>>> {
>>>   "took": 50,
>>>   ...
>>>   "hits": {
>>> ...
>>> "hits": [
>>>   {
>>> ...
>>> "sort": [ null ]
>>>   }]
>>>   }
>>> }
>>>
>>> Also, I've tried to add "_id": { "index": "not_analyzerd" } in the
>>> _mapping.
>>> This time the "sort" section returns values. But I find the results are
>>> still partly unordered.
>>>
>>> Can I sort results by _id? How?
>>>
>>> Thank you.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "elasticsearch" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to elasticsearc...@googlegroups.com.
>>> To view this discussion on the web visit https://groups.google.com/d/
>>> msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%
>>> 40googlegroups.com
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Adrien Grand
>>
>  --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to elasticsearch+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/b7f625dd-8afd-4603-afc8-1fd6d5b601d1%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Adrien Grand

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j6x_GN9HuZzYtgB_T69hu0y_QVUCzqxxOKciEvKubgkUw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I sort results by _id?

2015-01-15 Thread Jason Zhang

What I'm confused is the 'sorted' results are still partly unordered.

Also, if I query:

{  "range": {
"_id": {
  "gt": "1",
  "lt": "1"}}}

the results contain "_id": 199989.

On Thursday, January 15, 2015 at 5:48:48 PM UTC+8, Adrien Grand wrote:
>
> Making it index:not_analyzed should work, what is the issue with the 
> results?
>
> Note that loading the _id in fielddata is typically very costly since the 
> _id field is typically unique per document.
>
> On Thu, Jan 15, 2015 at 10:35 AM, Jason Zhang  > wrote:
>
>> I use a query dsl like:
>>
>> {
>>   "filter": {
>> "exists": { "field": "info" }
>>   },
>>   "sort": { "_id": "desc" }
>> }
>>
>> And the "_id" here is an integer like '123'.
>>
>> But the result is like:
>>
>> { 
>>   "took": 50,
>>   ...
>>   "hits": {
>> ...
>> "hits": [
>>   {
>> ...
>> "sort": [ null ]
>>   }]
>>   }
>> }
>>
>> Also, I've tried to add "_id": { "index": "not_analyzerd" } in the 
>> _mapping.
>> This time the "sort" section returns values. But I find the results are 
>> still partly unordered.
>>
>> Can I sort results by _id? How?
>>
>> Thank you.
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "elasticsearch" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to elasticsearc...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%40googlegroups.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Adrien Grand
>  

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/b7f625dd-8afd-4603-afc8-1fd6d5b601d1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I sort results by _id?

2015-01-15 Thread Adrien Grand

Making it index:not_analyzed should work, what is the issue with the
results?

Note that loading the _id in fielddata is typically very costly since the
_id field is typically unique per document.

On Thu, Jan 15, 2015 at 10:35 AM, Jason Zhang  wrote:

> I use a query dsl like:
>
> {
>   "filter": {
> "exists": { "field": "info" }
>   },
>   "sort": { "_id": "desc" }
> }
>
> And the "_id" here is an integer like '123'.
>
> But the result is like:
>
> {
>   "took": 50,
>   ...
>   "hits": {
> ...
> "hits": [
>   {
> ...
> "sort": [ null ]
>   }]
>   }
> }
>
> Also, I've tried to add "_id": { "index": "not_analyzerd" } in the
> _mapping.
> This time the "sort" section returns values. But I find the results are
> still partly unordered.
>
> Can I sort results by _id? How?
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to elasticsearch+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Adrien Grand

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7uK%2BJY_2-C3LHGTc7YYRFVv2z_-o%3DuWbDhE2SQOJYFZA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

How can I sort results by _id?

2015-01-15 Thread Jason Zhang

I use a query dsl like:

{
  "filter": {
"exists": { "field": "info" }
  },
  "sort": { "_id": "desc" }
}

And the "_id" here is an integer like '123'.

But the result is like:

{ 
  "took": 50,
  ...
  "hits": {
...
"hits": [
  {
...
"sort": [ null ]
  }]
  }
}

Also, I've tried to add "_id": { "index": "not_analyzerd" } in the _mapping.
This time the "sort" section returns values. But I find the results are 
still partly unordered.

Can I sort results by _id? How?

Thank you.

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I sort results by _id?

Re: How can I sort results by _id?

Re: How can I sort results by _id?

Re: How can I sort results by _id?

Re: How can I sort results by _id?

How can I sort results by _id?

6 matches

Site Navigation

Mail list logo

Footer information