No, an ID has to be a string --
Itamar Syn-Hershko http://code972.com | @synhershko <https://twitter.com/synhershko> Freelance Developer & Consultant Author of RavenDB in Action <http://manning.com/synhershko/> On Thu, Jan 15, 2015 at 12:12 PM, Jason Zhang <moc...@gmail.com> 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 <moc...@gmail.com> wrote: >> >>> What I'm confused is the 'sorted' results are still partly unordered. >>> >>> Also, if I query: >>> >>> { "range": { >>> "_id": { >>> "gt": "10000", >>> "lt": "19999"}}} >>> >>> 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 <moc...@gmail.com> 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 >>>>> <https://groups.google.com/d/msgid/elasticsearch/4ea45f18-847a-4b58-b78e-ddcd9ee1e9f9%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> 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 >>> <https://groups.google.com/d/msgid/elasticsearch/b7f625dd-8afd-4603-afc8-1fd6d5b601d1%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> 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 > <https://groups.google.com/d/msgid/elasticsearch/2475cb1a-5631-4b06-8507-28c4d81f9d4d%40googlegroups.com?utm_medium=email&utm_source=footer> > . > 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.