# Search using a large value of "long" **URL:** \ **Category:** Elasticsearch\ **Created:** [February 13, 2014, 8:05am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774 "2014-02-13T08:05:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Arinto\_Murdopo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arinto_murdopo/32/1779_2.png) [@Arinto\_Murdopo](https://discuss.elastic.co/u/Arinto_Murdopo)\ **Post date:** [February 13, 2014, 8:05am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/1 "2014-02-13T08:05:12Z")
Hi there, Suppose I have this document: { "user": { "uid": 67483951, }, "did": 433036615015882750 } "uid" and "did" have type of "long" in the mapping. Its document id is unknown and I would like to fetch the document using "did" value via search API. Therefore, I issue this curl command: curl -XGET "[http://eshost:9200/my\_index/my\_type/\_search?q=did:433036615015882750](http://eshost:9200/my_index/my_type/_search?q=did:433036615015882750)" Unfortunately, the above curl command is unable to fetch my document. Here is the result from the curl command: { "took": 46, "timed\_out": false, "\_shards": { "total": 20, "successful": 20, "failed": 0 }, "hits": { "total": 0, "max\_score": null, "hits": [] } } However, when I use the "uid" to search, I'm able to fetch the document. Here's the curl command for search using "uid" curl -XGET "[http://eshost:9200/my\_index/my\_type/\_search?q=user.uid:67483951](http://eshost:9200/my_index/my_type/_search?q=user.uid:67483951)" I tried above with using Java API (using prepareSearch method of transport client, with term query), but the results are the same i.e. I can fetch using "uid" but I can't fetch using "did". So, the question is how to search using large value of "long" as shown in this case? -- 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Arinto\_Murdopo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arinto_murdopo/32/1779_2.png) [@Arinto\_Murdopo](https://discuss.elastic.co/u/Arinto_Murdopo)\ **Post date:** [February 13, 2014, 8:06am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/2 "2014-02-13T08:06:10Z")
Oh, I forgot to mention. I'm using Elasticsearch 0.90.9 On Thursday, February 13, 2014 4:05:12 PM UTC+8, Arinto Murdopo wrote: > Hi there, > > Suppose I have this document: > { > "user": { > "uid": 67483951, > }, > "did": 433036615015882750 > } > > "uid" and "did" have type of "long" in the mapping. > Its document id is unknown and I would like to fetch the document using > "did" value via search API. > Therefore, I issue this curl command: > > curl -XGET " > [http://eshost:9200/my\_index/my\_type/\_search?q=did:433036615015882750](http://eshost:9200/my_index/my_type/_search?q=did:433036615015882750)" > > Unfortunately, the above curl command is unable to fetch my document. Here > is the result from the curl command: > { > "took": 46, > "timed\_out": false, > "\_shards": { > "total": 20, > "successful": 20, > "failed": 0 > }, > "hits": { > "total": 0, > "max\_score": null, > "hits": > } > } > > However, when I use the "uid" to search, I'm able to fetch the document. > Here's the curl command for search using "uid" > > curl -XGET " > [http://eshost:9200/my\_index/my\_type/\_search?q=user.uid:67483951](http://eshost:9200/my_index/my_type/_search?q=user.uid:67483951)" > > I tried above with using Java API (using prepareSearch method of transport > client, with term query), but the results are the same i.e. I can fetch > using "uid" but I can't fetch using "did". So, the question is how to > search using large value of "long" as shown in this case? -- 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/824a0a51-339f-4061-a0df-16add6e43554%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/824a0a51-339f-4061-a0df-16add6e43554%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Binh\_Ly](https://avatars.discourse-cdn.com/v4/letter/b/ce7236/32.png) [@Binh\_Ly](https://discuss.elastic.co/u/Binh_Ly)\ **Post date:** [February 13, 2014, 1:00pm UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/3 "2014-02-13T13:00:24Z")
I didn't try on 0.90.9, but I just tried on 1.0 and this query works fine and returns the document correctly: [http://localhost:9200/foo/doc/\_search?q=foo:433036615015882750](http://localhost:9200/foo/doc/_search?q=foo:433036615015882750) -- 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/f4da5f6a-681f-4e69-97e6-ffbc7fc4d5ee%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f4da5f6a-681f-4e69-97e6-ffbc7fc4d5ee%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\ **Post date:** [February 13, 2014, 11:23pm UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/4 "2014-02-13T23:23:27Z")
Can you check that this field is actually mapped as a long (as opposed to an integer or double) using the get field mapping API? > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. Since 433036615015882750 requires 59 bits to be stored, it can actually only be stored as a long (64 bits). Neither an integer (32 bits) nor a double (52 bits) would be able to store it and it would prevent you from searching this document. On Thu, Feb 13, 2014 at 9:05 AM, Arinto Murdopo [arinto@gmail.com](mailto:arinto@gmail.com) wrote: > Hi there, > > Suppose I have this document: > { > "user": { > "uid": 67483951, > }, > "did": 433036615015882750 > } > > "uid" and "did" have type of "long" in the mapping. > Its document id is unknown and I would like to fetch the document using > "did" value via search API. > Therefore, I issue this curl command: > > curl -XGET " > [http://eshost:9200/my\_index/my\_type/\_search?q=did:433036615015882750](http://eshost:9200/my_index/my_type/_search?q=did:433036615015882750)" > > Unfortunately, the above curl command is unable to fetch my document. Here > is the result from the curl command: > { > "took": 46, > "timed\_out": false, > "\_shards": { > "total": 20, > "successful": 20, > "failed": 0 > }, > "hits": { > "total": 0, > "max\_score": null, > "hits": > } > } > > However, when I use the "uid" to search, I'm able to fetch the document. > Here's the curl command for search using "uid" > > curl -XGET " > [http://eshost:9200/my\_index/my\_type/\_search?q=user.uid:67483951](http://eshost:9200/my_index/my_type/_search?q=user.uid:67483951)" > > I tried above with using Java API (using prepareSearch method of transport > client, with term query), but the results are the same i.e. I can fetch > using "uid" but I can't fetch using "did". So, the question is how to > search using large value of "long" as shown in this case? > > -- > 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com) > . > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j4BGQXoT\_ZpkZszbvjy\_TrfY8CnF0s7ZTxO\_-o0A95MVQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j4BGQXoT_ZpkZszbvjy_TrfY8CnF0s7ZTxO_-o0A95MVQ%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Arinto\_Murdopo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arinto_murdopo/32/1779_2.png) [@Arinto\_Murdopo](https://discuss.elastic.co/u/Arinto_Murdopo)\ **Post date:** [February 14, 2014, 3:16am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/5 "2014-02-14T03:16:53Z")
Thanks for the prompt reply. For the mapping, it's a "long". Here are the output { "my\_index": { "my\_type": { "id": { "full\_name": "id", "mapping": { "id": { "type": "long" } } } } } } After I do further investigation, it seems that the error is caused by Sense Chrome plugin[https://chrome.google.com/webstore/detail/sense/doinijnbnggojdlcjifpdckfokbbfpbo](https://chrome.google.com/webstore/detail/sense/doinijnbnggojdlcjifpdckfokbbfpbo)that I use. So, what I did now is I index a document that has an id field equals to "427478922591096833". When we use obtain this document, the Sense will show the id equals to "427478922591096800". But, I managed to get the correct result when using curl. So yesterday problem is because I used the id (which is the invalid id, i.e. 427478922591096800) returned by Sense to perform the search and the search return nothing. When I use the search using the correct id from curl, I managed to get the document. If you're interested, you can take a look at the Sense screenshot which highlight the problem in my note: > **[ElasticSearch very-long-id Google Groups](https://www.evernote.com/shard/s115/client/snv?isnewsnv=true¬eGuid=a82222fb-952a-4fc0-a81c-2d88c1e2bdb1¬eKey=bd80a433dfdf0ccb51dd8d35cd827838&sn=https%3A%2F%2Fwww.evernote.com%2Fshard%2Fs115%2Fsh%2Fa82222fb-952a-4fc0-a81c-2d88c1e2bdb1%2Fbd80a433dfdf0ccb51dd8d35cd827838&title=ElasticSearch%2Bvery-long-id%2BGoogle%2BGroups)** > > Refer to screenshot below, I index-ed document with an "id" value equals to 427478922591096999. Then, I'm able to retrieve the document using search API and "id" field equals to 427478922591096999. Ho... Best regards, Arinto On Friday, February 14, 2014 7:23:27 AM UTC+8, Adrien Grand wrote: > Can you check that this field is actually mapped as a long (as opposed to > an integer or double) using the get field mapping API? > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/indices-get-field-mapping.html) > > Since 433036615015882750 requires 59 bits to be stored, it can actually > only be stored as a long (64 bits). Neither an integer (32 bits) nor a > double (52 bits) would be able to store it and it would prevent you from > searching this document. > > On Thu, Feb 13, 2014 at 9:05 AM, Arinto Murdopo \<[ari...@gmail.com](mailto:ari...@gmail.com)\ > > > wrote: > > > Hi there, > > > > Suppose I have this document: > > { > > "user": { > > "uid": 67483951, > > }, > > "did": 433036615015882750 > > } > > > > "uid" and "did" have type of "long" in the mapping. > > Its document id is unknown and I would like to fetch the document using > > "did" value via search API. > > Therefore, I issue this curl command: > > > > curl -XGET " > > [http://eshost:9200/my\_index/my\_type/\_search?q=did:433036615015882750](http://eshost:9200/my_index/my_type/_search?q=did:433036615015882750)" > > > > Unfortunately, the above curl command is unable to fetch my document. > > Here is the result from the curl command: > > { > > "took": 46, > > "timed\_out": false, > > "\_shards": { > > "total": 20, > > "successful": 20, > > "failed": 0 > > }, > > "hits": { > > "total": 0, > > "max\_score": null, > > "hits": > > } > > } > > > > However, when I use the "uid" to search, I'm able to fetch the document. > > Here's the curl command for search using "uid" > > > > curl -XGET " > > [http://eshost:9200/my\_index/my\_type/\_search?q=user.uid:67483951](http://eshost:9200/my_index/my_type/_search?q=user.uid:67483951)" > > > > I tried above with using Java API (using prepareSearch method of > > transport client, with term query), but the results are the same i.e. I can > > fetch using "uid" but I can't fetch using "did". So, the question is how to > > search using large value of "long" as shown in this case? > > > > -- > > 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](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca%40googlegroups.com) > > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/acb0e42a-e967-401e-9644-398e88e37317%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/acb0e42a-e967-401e-9644-398e88e37317%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\ **Post date:** [February 14, 2014, 9:04am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/6 "2014-02-14T09:04:25Z")
Oh, I think I understand what the issue is: in javascript there are no integer types so all numbers are actually floating-point numbers. 433036615015882750 got replaced by 427478922591096800 because it requires 59 bits to be stored while doubles store the value on 52 bits (and the sign on one bit and the exponent on 9 bits) so the low-order bits got lost. I think this is a limitation when using Javascript as a client in general, not only in Sense. On Fri, Feb 14, 2014 at 4:16 AM, Arinto Murdopo [arinto@gmail.com](mailto:arinto@gmail.com) wrote: > Thanks for the prompt reply. > > For the mapping, it's a "long". Here are the output > { > "my\_index": { > "my\_type": { > "id": { > "full\_name": "id", > "mapping": { > "id": { > "type": "long" > } > } > } > } > } > } > > After I do further investigation, it seems that the error is caused by Sense > Chrome plugin[https://chrome.google.com/webstore/detail/sense/doinijnbnggojdlcjifpdckfokbbfpbo](https://chrome.google.com/webstore/detail/sense/doinijnbnggojdlcjifpdckfokbbfpbo)that I use. So, what I did now is I index a document that has an id field > equals to "427478922591096833". When we use obtain this document, the Sense > will show the id equals to "427478922591096800". But, I managed to get the > correct result when using curl. > > So yesterday problem is because I used the id (which is the invalid id, > i.e. 427478922591096800) returned by Sense to perform the search and the > search return nothing. When I use the search using the correct id from > curl, I managed to get the document. > > If you're interested, you can take a look at the Sense screenshot which > highlight the problem in my note: > [ElasticSearch very-long-id Google Groups](https://www.evernote.com/shard/s115/sh/a82222fb-952a-4fc0-a81c-2d88c1e2bdb1/bd80a433dfdf0ccb51dd8d35cd827838) > > Best regards, > > Arinto > > On Friday, February 14, 2014 7:23:27 AM UTC+8, Adrien Grand wrote: > > > Can you check that this field is actually mapped as a long (as opposed to > > an integer or double) using the get field mapping API? > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/) > > reference/current/indices-get-field-mapping.html > > > > Since 433036615015882750 requires 59 bits to be stored, it can actually > > only be stored as a long (64 bits). Neither an integer (32 bits) nor a > > double (52 bits) would be able to store it and it would prevent you from > > searching this document. > > > > On Thu, Feb 13, 2014 at 9:05 AM, Arinto Murdopo [ari...@gmail.com](mailto:ari...@gmail.com) wrote: > > > > > Hi there, > > > > > > Suppose I have this document: > > > { > > > "user": { > > > "uid": 67483951, > > > }, > > > "did": 433036615015882750 > > > } > > > > > > "uid" and "did" have type of "long" in the mapping. > > > Its document id is unknown and I would like to fetch the document using > > > "did" value via search API. > > > Therefore, I issue this curl command: > > > > > > curl -XGET "[http://eshost:9200/my\_index/my\_type/\_search?q=did:](http://eshost:9200/my_index/my_type/_search?q=did:) > > > 433036615015882750" > > > > > > Unfortunately, the above curl command is unable to fetch my document. > > > Here is the result from the curl command: > > > { > > > "took": 46, > > > "timed\_out": false, > > > "\_shards": { > > > "total": 20, > > > "successful": 20, > > > "failed": 0 > > > }, > > > "hits": { > > > "total": 0, > > > "max\_score": null, > > > "hits": > > > } > > > } > > > > > > However, when I use the "uid" to search, I'm able to fetch the > > > document. Here's the curl command for search using "uid" > > > > > > curl -XGET "[http://eshost:9200/my\_index/my\_type/\_search?q=user.uid:](http://eshost:9200/my_index/my_type/_search?q=user.uid:) > > > 67483951" > > > > > > I tried above with using Java API (using prepareSearch method of > > > transport client, with term query), but the results are the same i.e. I can > > > fetch using "uid" but I can't fetch using "did". So, the question is how to > > > search using large value of "long" as shown in this case? > > > > > > -- > > > 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](mailto:elasticsearc...@googlegroups.com). > > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > msgid/elasticsearch/9bc36672-cdcb-4edf-ae04-9bfaa49e7cca% > > > [40googlegroups.com](http://40googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/acb0e42a-e967-401e-9644-398e88e37317%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/acb0e42a-e967-401e-9644-398e88e37317%40googlegroups.com) > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7pbkiddy94Dz4MnpDGOzoPEfpHDia8yRO%3Dvbh%3DBOos1Q%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7pbkiddy94Dz4MnpDGOzoPEfpHDia8yRO%3Dvbh%3DBOos1Q%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:50am UTC](https://discuss.elastic.co/t/search-using-a-large-value-of-long/15774/7 "2017-07-06T01:50:15Z")