# Elasticsearch float and double values

**URL:** <https://discuss.elastic.co/t/elasticsearch-float-and-double-values/19969>\
**Category:** Elasticsearch\
**Created:** [September 25, 2014, 5:08pm UTC](https://discuss.elastic.co/t/elasticsearch-float-and-double-values/19969 "2014-09-25T17:08:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Misha\_Skubenych](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@Misha\_Skubenych](https://discuss.elastic.co/u/Misha_Skubenych)\
**Post date:** [September 25, 2014, 5:08pm UTC](https://discuss.elastic.co/t/elasticsearch-float-and-double-values/19969/1 "2014-09-25T17:08:56Z")

</div>

Hello

I have a data like this

| Doctors\_Name | Patient\_Age | Patients\_Sex | Dose | Patient\_Is\_Alive |
| Wilson | 65 | Female | 40.5 | TRUE |
| Jamison | 23 | Male | 60.7 | TRUE |
| Thompson | 62 | Male | 60.7 | TRUE |
| Paulson | 19 | Female | 400 | TRUE |
| Daniels | 27 | Female | 60.6 | FALSE |
| Allison | 84 | Male | 40 | FALSE |
| Wilkes | 46 | Male | 60 | TRUE |
| Hamilton | 86 | Male | 40 | FALSE |
| Allison | 27 | Female | 40 | TRUE |
| Wilson | 66 | Female | 60 | FALSE |
| Hamilton | 85 | Male | 40 | TRUE |
| Daniels | 74 | Male | 60 | FALSE |
| Thompson | 78 | Female | 40 | TRUE |
| Hamilton | 24 | Male | 60 | FALSE |
| Hamilton | 62 | Male | 60 | TRUE |
| Wilson | 59 | Female | 40 | FALSE |
| Wilkes | 39 | Male | 60 | TRUE |
| Thompson | 41 | Male | 40 | TRUE |
| Daniels | 64 | Female | 60 | TRUE |
| Hamilton | 58 | Male | 40 | TRUE |
| Hamilton | 58 | Male | 40 | TRUE |

And i need to get all unique values for dose(Float).

{:query=\>{:match\_all=\>{}}, :facets=\>{"dose"=\>{:terms=\>{:size=\>50000, :order=\>nil, :field=\>"dose"}}}}

it returns:

"terms"=\>[  
{"term"=\>40.0, "count"=\>8},  
{"term"=\>60.0, "count"=\>6},  
{"term"=\>60.70000076293945, "count"=\>2},  
{"term"=\>40.012123107910156, "count"=\>2},  
{"term"=\>400.0, "count"=\>1},  
{"term"=\>60.599998474121094, "count"=\>1},  
{"term"=\>40.5, "count"=\>1}  
]

Why this happens ? Is there a way in elasticsearch to display original values ?

* * *

I also try to use script:

{:query=\>{:match\_all=\>{}}, :facets=\>{"dose"=\>{:terms=\>{:size=\>50000, :order=\>nil, :script=\>"\_source.dose"}}}}

It works fine:

"terms"=\>[  
{"term"=\>"40.0", "count"=\>8},  
{"term"=\>"60.0", "count"=\>6},  
{"term"=\>"60.7", "count"=\>2},  
{"term"=\>"40.0", "count"=\>2},  
{"term"=\>"60.6", "count"=\>1},  
{"term"=\>"400.0", "count"=\>1},  
{"term"=\>"40.5", "count"=\>1}  
]

But it takes very long time if i have a lot of records (

Can you help me please?

Thanks

---

<div class="post-metadata">

**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, 12:59am UTC](https://discuss.elastic.co/t/elasticsearch-float-and-double-values/19969/2 "2017-07-06T00:59:53Z")

</div>

Closed on July 6, 2017, 12:59am UTC