# Longs being shown as strings

**URL:** <https://discuss.elastic.co/t/longs-being-shown-as-strings/18634>\
**Category:** Elasticsearch\
**Created:** [July 13, 2014, 7:06pm UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634 "2014-07-13T19:06:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elad\_Amit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elad_amit/32/1406_2.png) [@Elad\_Amit](https://discuss.elastic.co/u/Elad_Amit)\
**Post date:** [July 13, 2014, 7:06pm UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634/1 "2014-07-13T19:06:51Z")

</div>

I have started sending json entries to logstash with a few number fields  
(e.g. applicationid)  
The information in ES is correctly typed to long but the result of faceting  
on the field is quite strange  
i.e.  
an example entry:

{  
"\_index": "logstash-2014.07.13",  
"\_type": "logbook\_qa",  
"\_id": "QwiJPCjrRQmutQCWTwEjWg",  
"\_score": null,  
"\_source": {  
"classname": "...",  
"eventLogTime": "2014-07-13T18:54:00.5476081+00:00",  
"exceptionmessage": "The remote server returned an error: (530) Not logged in.",  
"exceptionname": "WebException",  
"exceptionseverity": 0,  
"exceptionstacktrace": "...",  
"hostname": "...",  
"logdatetime": "2014-07-13T18:54:00.5476081Z",  
"applicationid": 6363313,  
"methodparameters": "...",  
"methodname": "GetItemsFromFeed",  
"threadid": 24,  
"username": "...",  
"url": "",  
"entrytype": "ERROR",  
"@timestamp": "2014-07-13T18:54:00.547Z",  
"type": "logbook\_qa",  
"message": "..."  
},  
"sort": [  
1405277640547  
]  
}

The mapping:  
{  
"logbook\_qa": {  
"dynamic\_templates": [  
{  
"string\_template": {  
"mapping": {  
"index": "not\_analyzed",  
"type": "string"  
},  
"match": "\*",  
"match\_mapping\_type": "string"  
}  
}  
],  
"\_all": {  
"enabled": false  
},  
"\_source": {  
"compress": true  
},  
"properties": {  
"@timestamp": {  
"type": "date",  
"format": "dateOptionalTime"  
},  
"@version": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"appdomain": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"applicationid": {  
"type": "long"  
},  
"assemblyname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"classname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"entrytype": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"eventLogTime": {  
"type": "date",  
"format": "dateOptionalTime"  
},  
"exceptionmessage": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"exceptionname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"exceptionseverity": {  
"type": "long"  
},  
"exceptionstacktrace": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"host": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"hostname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"logdatetime": {  
"type": "date",  
"format": "dateOptionalTime"  
},  
"message": {  
"type": "string"  
},  
"methodname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"methodparameters": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"tags": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"threadid": {  
"type": "long"  
},  
"threadname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"tracemessage": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"type": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"url": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"username": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
}  
}  
}  
}

The facet query:

{  
"facets": {  
"terms": {  
"terms": {  
"field": "applicationid",  
"size": 10,  
"order": "count",  
"exclude": []  
},  
"facet\_filter": {  
"fquery": {  
"query": {  
"filtered": {  
"query": {  
"bool": {  
"should": [  
{  
"query\_string": {  
"query": "\*"  
}  
}  
]  
}  
},  
"filter": {  
"bool": {  
"must": [  
{  
"fquery": {  
"query": {  
"field": {  
"entrytype": {  
"query": ""ERROR""  
}  
}  
},  
"\_cache": true  
}  
},  
{  
"range": {  
"@timestamp": {  
"from": 1405256548987,  
"to": "now"  
}  
}  
}  
],  
"should": [  
{  
"fquery": {  
"query": {  
"field": {  
"type": {  
"query": ""logbook\_qa""  
}  
}  
},  
"\_cache": true  
}  
}  
]  
}  
}  
}  
}  
}  
}  
}  
},  
"size": 0  
}

The result:  
{  
"took": 259,  
"timed\_out": false,  
"\_shards": {  
"total": 41,  
"successful": 41,  
"failed": 0  
},  
"hits": {  
"total": 212813454,  
"max\_score": 1,  
"hits": []  
},  
"facets": {  
"terms": {  
"\_type": "terms",  
"missing": 0,  
"total": 521392,  
"other": 195522,  
"terms": [  
{  
"term": "\\b",  
"count": 32587  
},  
{  
"term": "X\u0001\u0000",  
"count": 32587  
},  
{  
"term": "T\u0010\u0000",  
"count": 32587  
},  
{  
"term": "P\u0002\u0000\u0000",  
"count": 32587  
},  
{  
"term": "L \u0000\u0000",  
"count": 32587  
},  
{  
"term": "H\u0004\u0000\u0000\u0000",  
"count": 32587  
},  
{  
"term": "D@\u0000\u0000\u0000",  
"count": 32587  
},  
{  
"term": "@\b\u0000\u0000\u0000\u0000",  
"count": 32587  
},  
{  
"term": "\<\u0001\u0000\u0000\u0000\u0000\u0000",  
"count": 32587  
},  
{  
"term": "8\u0010\u0000\u0000\u0000\u0000\u0000",  
"count": 32587  
}  
]  
}  
}  
}

I'd rather not pre-define that these fields are of type string to get  
around this, just feels wrong 🙂

--  
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/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Itamar\_Syn\_Hershko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/itamar_syn_hershko/32/725_2.png) [@Itamar\_Syn\_Hershko](https://discuss.elastic.co/u/Itamar_Syn_Hershko)\
**Post date:** [July 13, 2014, 7:24pm UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634/2 "2014-07-13T19:24:46Z")

</div>

What you are seeing is the Lucene numeric field terms. Try having the  
applicationid field as a not\_analyzed string field for the purpose of  
faceting, instead of having it as a numeric field (which is usable for  
range queries or sorts)

--

Itamar Syn-Hershko  
[http://code972.com](http://code972.com) | @synhershko [https://twitter.com/synhershko](https://twitter.com/synhershko)  
Freelance Developer & Consultant  
Author of RavenDB in Action [http://manning.com/synhershko/](http://manning.com/synhershko/)

On Sun, Jul 13, 2014 at 10:06 PM, Elad Amit [amitelad7@gmail.com](mailto:amitelad7@gmail.com) wrote:

> I have started sending json entries to logstash with a few number fields  
> (e.g. applicationid)  
> The information in ES is correctly typed to long but the result of  
> faceting on the field is quite strange  
> i.e.  
> an example entry:
> 
> {  
> "\_index": "logstash-2014.07.13",  
> "\_type": "logbook\_qa",  
> "\_id": "QwiJPCjrRQmutQCWTwEjWg",  
> "\_score": null,  
> "\_source": {  
> "classname": "...",  
> "eventLogTime": "2014-07-13T18:54:00.5476081+00:00",  
> "exceptionmessage": "The remote server returned an error: (530) Not logged in.",  
> "exceptionname": "WebException",  
> "exceptionseverity": 0,  
> "exceptionstacktrace": "...",  
> "hostname": "...",  
> "logdatetime": "2014-07-13T18:54:00.5476081Z",  
> "applicationid": 6363313,  
> "methodparameters": "...",  
> "methodname": "GetItemsFromFeed",  
> "threadid": 24,  
> "username": "...",  
> "url": "",  
> "entrytype": "ERROR",  
> "@timestamp": "2014-07-13T18:54:00.547Z",  
> "type": "logbook\_qa",  
> "message": "..."  
> },  
> "sort": [  
> 1405277640547  
> ]  
> }
> 
> The mapping:  
> {  
> "logbook\_qa": {  
> "dynamic\_templates": [  
> {  
> "string\_template": {  
> "mapping": {  
> "index": "not\_analyzed",  
> "type": "string"  
> },  
> "match": "\*",  
> "match\_mapping\_type": "string"  
> }  
> }  
> ],  
> "\_all": {  
> "enabled": false  
> },  
> "\_source": {  
> "compress": true  
> },  
> "properties": {  
> "@timestamp": {  
> "type": "date",  
> "format": "dateOptionalTime"  
> },  
> "@version": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "appdomain": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "applicationid": {  
> "type": "long"  
> },  
> "assemblyname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "classname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "entrytype": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "eventLogTime": {  
> "type": "date",  
> "format": "dateOptionalTime"  
> },  
> "exceptionmessage": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "exceptionname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "exceptionseverity": {  
> "type": "long"  
> },  
> "exceptionstacktrace": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "host": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "hostname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "logdatetime": {  
> "type": "date",  
> "format": "dateOptionalTime"  
> },  
> "message": {  
> "type": "string"  
> },  
> "methodname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "methodparameters": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "tags": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "threadid": {  
> "type": "long"  
> },  
> "threadname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "tracemessage": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "type": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "url": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "username": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> }  
> }  
> }  
> }
> 
> The facet query:
> 
> {  
> "facets": {  
> "terms": {  
> "terms": {  
> "field": "applicationid",  
> "size": 10,  
> "order": "count",  
> "exclude":   
> },  
> "facet\_filter": {  
> "fquery": {  
> "query": {  
> "filtered": {  
> "query": {  
> "bool": {  
> "should": [  
> {  
> "query\_string": {  
> "query": "\*"  
> }  
> }  
> ]  
> }  
> },  
> "filter": {  
> "bool": {  
> "must": [  
> {  
> "fquery": {  
> "query": {  
> "field": {  
> "entrytype": {  
> "query": ""ERROR""  
> }  
> }  
> },  
> "\_cache": true  
> }  
> },  
> {  
> "range": {  
> "@timestamp": {  
> "from": 1405256548987,  
> "to": "now"  
> }  
> }  
> }  
> ],  
> "should": [  
> {  
> "fquery": {  
> "query": {  
> "field": {  
> "type": {  
> "query": ""logbook\_qa""  
> }  
> }  
> },  
> "\_cache": true  
> }  
> }  
> ]  
> }  
> }  
> }  
> }  
> }  
> }  
> }  
> },  
> "size": 0  
> }
> 
> The result:  
> {  
> "took": 259,  
> "timed\_out": false,  
> "\_shards": {  
> "total": 41,  
> "successful": 41,  
> "failed": 0  
> },  
> "hits": {  
> "total": 212813454,  
> "max\_score": 1,  
> "hits":   
> },  
> "facets": {  
> "terms": {  
> "\_type": "terms",  
> "missing": 0,  
> "total": 521392,  
> "other": 195522,  
> "terms": [  
> {  
> "term": "\\b",  
> "count": 32587  
> },  
> {  
> "term": "X\u0001\u0000",  
> "count": 32587  
> },  
> {  
> "term": "T\u0010\u0000",  
> "count": 32587  
> },  
> {  
> "term": "P\u0002\u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "L \u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "H\u0004\u0000\u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "D@\u0000\u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "@\b\u0000\u0000\u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "\<\u0001\u0000\u0000\u0000\u0000\u0000",  
> "count": 32587  
> },  
> {  
> "term": "8\u0010\u0000\u0000\u0000\u0000\u0000",  
> "count": 32587  
> }  
> ]  
> }  
> }  
> }
> 
> I'd rather not pre-define that these fields are of type string to get  
> around this, just feels wrong 🙂
> 
> --  
> 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/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zt1e2HyOZJ9LXHTKs9X\_s8iEvWZ06iDu5WvZnqbSvshXw%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAHTr4Zt1e2HyOZJ9LXHTKs9X_s8iEvWZ06iDu5WvZnqbSvshXw%40mail.gmail.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Elad\_Amit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elad_amit/32/1406_2.png) [@Elad\_Amit](https://discuss.elastic.co/u/Elad_Amit)\
**Post date:** [July 14, 2014, 5:20am UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634/3 "2014-07-14T05:20:56Z")

</div>

treating it as a string is what I am trying to avoid 🙂  
I have other fields typed as long which are not exhibiting this behavior  
which is why I am finding this a bit odd

i.e.  
mapping:  
{  
"iis-log": {  
"dynamic\_templates": [  
{  
"string\_template": {  
"mapping": {  
"index": "not\_analyzed",  
"type": "string"  
},  
"match": "\*",  
"match\_mapping\_type": "string"  
}  
}  
],  
"\_all": {  
"enabled": false  
},  
"\_source": {  
"compress": true  
},  
"properties": {  
"@timestamp": {  
"type": "date",  
"format": "dateOptionalTime"  
},  
"@version": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"EventTime": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"bytesreceived": {  
"type": "long"  
},  
"bytessent": {  
"type": "long"  
},  
"clientip": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"host": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"hostname": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"logstash\_host": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"message": {  
"type": "string"  
},  
"method": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"queryparam": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"status": {  
"type": "long"  
},  
"substatus": {  
"type": "long"  
},  
"tags": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"timetaken": {  
"type": "long"  
},  
"type": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
},  
"useragent": {  
"type": "string",  
"index": "not\_analyzed",  
"omit\_norms": true,  
"index\_options": "docs"  
}  
}  
}  
}

> > The facet query:
> > 
> > {  
> > "facets": {  
> > "terms": {  
> > "terms": {  
> > "field": "applicationid",  
> > "size": 10,  
> > "order": "count",  
> > "exclude":   
> > },  
> > "facet\_filter": {  
> > "fquery": {  
> > "query": {  
> > "filtered": {  
> > "query": {  
> > "bool": {  
> > "should": [  
> > {  
> > "query\_string": {  
> > "query": "\*"  
> > }  
> > }  
> > ]  
> > }  
> > },  
> > "filter": {  
> > "bool": {  
> > "must": [  
> > {  
> > "fquery": {  
> > "query": {  
> > "field": {  
> > "entrytype": {  
> > "query": ""ERROR""  
> > }  
> > }  
> > },  
> > "\_cache": true  
> > }  
> > },  
> > {  
> > "range": {  
> > "@timestamp": {  
> > "from": 1405256548987,  
> > "to": "now"  
> > }  
> > }  
> > }  
> > ],  
> > "should": [  
> > {  
> > "fquery": {  
> > "query": {  
> > "field": {  
> > "type": {  
> > "query": ""logbook\_qa""  
> > }  
> > }  
> > },  
> > "\_cache": true  
> > }  
> > }  
> > ]  
> > }  
> > }  
> > }  
> > }  
> > }  
> > }  
> > }  
> > },  
> > "size": 0  
> > }
> > 
> > The result:  
> > {  
> > "took": 259,  
> > "timed\_out": false,  
> > "\_shards": {  
> > "total": 41,  
> > "successful": 41,  
> > "failed": 0  
> > },  
> > "hits": {  
> > "total": 212813454,  
> > "max\_score": 1,  
> > "hits":   
> > },  
> > "facets": {  
> > "terms": {  
> > "\_type": "terms",  
> > "missing": 0,  
> > "total": 521392,  
> > "other": 195522,  
> > "terms": [  
> > {  
> > "term": "\\b",  
> > "count": 32587  
> > },  
> > {  
> > "term": "X\u0001\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "T\u0010\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "P\u0002\u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "L \u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "H\u0004\u0000\u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "D@\u0000\u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "@\b\u0000\u0000\u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "\<\u0001\u0000\u0000\u0000\u0000\u0000",  
> > "count": 32587  
> > },  
> > {  
> > "term": "8\u0010\u0000\u0000\u0000\u0000\u0000",  
> > "count": 32587  
> > }  
> > ]  
> > }  
> > }  
> > }
> > 
> > I'd rather not pre-define that these fields are of type string to get  
> > around this, just feels wrong 🙂
> > 
> > --  
> > 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) \<javascript:\>.  
> > To view this discussion on the web visit  
> > [https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com)  
> > [https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > .  
> > For more options, visit [https://groups.google.com/d/optout](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/07952273-1590-4ab3-a9cb-af5cc011a948%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/07952273-1590-4ab3-a9cb-af5cc011a948%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Elad\_Amit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elad_amit/32/1406_2.png) [@Elad\_Amit](https://discuss.elastic.co/u/Elad_Amit)\
**Post date:** [July 14, 2014, 6:57am UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634/4 "2014-07-14T06:57:54Z")

</div>

ok, intriguing, looks like the problem was that I had multiple types in the  
same index with the same field name with different types which made ES go a  
bit nuts  
migrated all of them and everything works fine now 🙂

On Monday, July 14, 2014 8:20:57 AM UTC+3, Elad Amit wrote:

> treating it as a string is what I am trying to avoid 🙂  
> I have other fields typed as long which are not exhibiting this behavior  
> which is why I am finding this a bit odd
> 
> i.e.  
> mapping:  
> {  
> "iis-log": {  
> "dynamic\_templates": [  
> {  
> "string\_template": {  
> "mapping": {  
> "index": "not\_analyzed",  
> "type": "string"  
> },  
> "match": "\*",  
> "match\_mapping\_type": "string"  
> }  
> }  
> ],  
> "\_all": {  
> "enabled": false  
> },  
> "\_source": {  
> "compress": true  
> },  
> "properties": {  
> "@timestamp": {  
> "type": "date",  
> "format": "dateOptionalTime"  
> },  
> "@version": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "EventTime": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "bytesreceived": {  
> "type": "long"  
> },  
> "bytessent": {  
> "type": "long"  
> },  
> "clientip": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "host": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "hostname": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "logstash\_host": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "message": {  
> "type": "string"  
> },  
> "method": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "queryparam": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "status": {  
> "type": "long"  
> },  
> "substatus": {  
> "type": "long"  
> },  
> "tags": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "timetaken": {  
> "type": "long"  
> },  
> "type": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> },  
> "useragent": {  
> "type": "string",  
> "index": "not\_analyzed",  
> "omit\_norms": true,  
> "index\_options": "docs"  
> }  
> }  
> }  
> }
> 
> > > The facet query:
> > > 
> > > {  
> > > "facets": {  
> > > "terms": {  
> > > "terms": {  
> > > "field": "applicationid",  
> > > "size": 10,  
> > > "order": "count",  
> > > "exclude":   
> > > },  
> > > "facet\_filter": {  
> > > "fquery": {  
> > > "query": {  
> > > "filtered": {  
> > > "query": {  
> > > "bool": {  
> > > "should": [  
> > > {  
> > > "query\_string": {  
> > > "query": "\*"  
> > > }  
> > > }  
> > > ]  
> > > }  
> > > },  
> > > "filter": {  
> > > "bool": {  
> > > "must": [  
> > > {  
> > > "fquery": {  
> > > "query": {  
> > > "field": {  
> > > "entrytype": {  
> > > "query": ""ERROR""  
> > > }  
> > > }  
> > > },  
> > > "\_cache": true  
> > > }  
> > > },  
> > > {  
> > > "range": {  
> > > "@timestamp": {  
> > > "from": 1405256548987,  
> > > "to": "now"  
> > > }  
> > > }  
> > > }  
> > > ],  
> > > "should": [  
> > > {  
> > > "fquery": {  
> > > "query": {  
> > > "field": {  
> > > "type": {  
> > > "query": ""logbook\_qa""  
> > > }  
> > > }  
> > > },  
> > > "\_cache": true  
> > > }  
> > > }  
> > > ]  
> > > }  
> > > }  
> > > }  
> > > }  
> > > }  
> > > }  
> > > }  
> > > },  
> > > "size": 0  
> > > }
> > > 
> > > The result:  
> > > {  
> > > "took": 259,  
> > > "timed\_out": false,  
> > > "\_shards": {  
> > > "total": 41,  
> > > "successful": 41,  
> > > "failed": 0  
> > > },  
> > > "hits": {  
> > > "total": 212813454,  
> > > "max\_score": 1,  
> > > "hits":   
> > > },  
> > > "facets": {  
> > > "terms": {  
> > > "\_type": "terms",  
> > > "missing": 0,  
> > > "total": 521392,  
> > > "other": 195522,  
> > > "terms": [  
> > > {  
> > > "term": "\\b",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "X\u0001\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "T\u0010\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "P\u0002\u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "L \u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "H\u0004\u0000\u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "D@\u0000\u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "@\b\u0000\u0000\u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "\<\u0001\u0000\u0000\u0000\u0000\u0000",  
> > > "count": 32587  
> > > },  
> > > {  
> > > "term": "8\u0010\u0000\u0000\u0000\u0000\u0000",  
> > > "count": 32587  
> > > }  
> > > ]  
> > > }  
> > > }  
> > > }
> > > 
> > > I'd rather not pre-define that these fields are of type string to get  
> > > around this, just feels wrong 🙂
> > > 
> > > --  
> > > 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/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com)  
> > > [https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/cc9aeb4e-f235-497e-88f3-624bb1d524cd%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > .  
> > > For more options, visit [https://groups.google.com/d/optout](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/06f0f099-1547-4158-b1bf-8519219a1a7e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/06f0f099-1547-4158-b1bf-8519219a1a7e%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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, 1:16am UTC](https://discuss.elastic.co/t/longs-being-shown-as-strings/18634/5 "2017-07-06T01:16:10Z")

</div>