elasticsearch - Elastic search NumberFormatException aggregation terms query -
i don't know doing wrong. have term aggregation on integer field "status", getting numberformatexception
running query. have 2 status fields 1 in _source.status type integer , 1 _source.report.status type long
error message
{ "error": "searchphaseexecutionexception[failed execute phase [query], shards failed; shardfailures {[qieoas8ss4ynp938pixzyg][outboxprov1][3]: elasticsearchexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: uncheckedexecutionexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: numberformatexception[invalid shift value in prefixcoded bytes (is encoded value int?)]; }{[qieoas8ss4ynp938pixzyg][outboxprov1][4]: elasticsearchexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: uncheckedexecutionexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: numberformatexception[invalid shift value in prefixcoded bytes (is encoded value int?)]; }{[qieoas8ss4ynp938pixzyg][outboxprov1][0]: elasticsearchexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: uncheckedexecutionexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: numberformatexception[invalid shift value in prefixcoded bytes (is encoded value int?)]; }{[qieoas8ss4ynp938pixzyg][outboxprov1][1]: elasticsearchexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: uncheckedexecutionexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: numberformatexception[invalid shift value in prefixcoded bytes (is encoded value int?)]; }{[qieoas8ss4ynp938pixzyg][outboxprov1][2]: elasticsearchexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: uncheckedexecutionexception[java.lang.numberformatexception: invalid shift value in prefixcoded bytes (is encoded value int?)]; nested: numberformatexception[invalid shift value in prefixcoded bytes (is encoded value int?)]; }]", "status": 500 }
query
{ "size": 0, "query": { "match_all": {} }, "aggs": { "total": { "terms": { "field": "status", // type : "integer" "order": { "_term": "asc" } } }, "immediate_total": { "terms": { "field": "immediate", "order": { "_term": "asc" } } }, "daily_post_count": { "filter": { "range": { "created_date": { "from": "2014-11-27", "to": "2014-11-27" } } }, "aggs": { "today_posts": { "terms": { "field": "status", // type : "integer" "order": { "_term": "asc" } } }, "today_immediate": { "terms": { "field": "immediate", "order": { "_term": "asc" } } } } } } }
mapping
{ "test": { "mappings": { "message": { "properties": { "approved_date": { "type": "date", "format": "dateoptionaltime" }, "approver": { "type": "string" }, "content": { "type": "string", "store": true }, "contents": { "properties": { "'facebook'": { "type": "string" }, "approver": { "type": "string" }, "contents": { "type": "string" }, "created_date": { "type": "date", "format": "dateoptionaltime" }, "facebok": { "type": "string" }, "facebook": { "type": "string" }, "failed": { "type": "long" }, "hash": { "type": "string" }, "immediate": { "type": "long" }, "link": { "type": "string" }, "linkedin": { "type": "string" }, "message_date": { "type": "date", "format": "dateoptionaltime" }, "network_connectors": { "type": "string" }, "post_count": { "type": "long" }, "preview": { "type": "string" }, "preview_description": { "type": "string" }, "preview_image_url": { "type": "string" }, "preview_title": { "type": "string" }, "sent": { "type": "long" }, "status": { "type": "long" }, "twitter": { "type": "string" } } }, "created_date": { "type": "date", "format": "dateoptionaltime" }, "created_ip": { "type": "ip" }, "created_user": { "type": "string", "index": "not_analyzed" }, "failed": { "type": "long" }, "folder": { "type": "integer" }, "hash": { "type": "string" }, "immediate": { "type": "long" }, "link": { "type": "string" }, "message_date": { "type": "date", "format": "dateoptionaltime" }, "modified_date": { "type": "date", "format": "dateoptionaltime" }, "network_connectors": { "type": "string", "index": "not_analyzed" }, "post_count": { "type": "long" }, "preview": { "type": "string" }, "preview_description": { "type": "string" }, "preview_image_url": { "type": "string" }, "preview_title": { "type": "string" }, "report": { "properties": { "info": { "type": "string" }, "networks": { "type": "string" }, "status": { "type": "long" } } }, "sent": { "type": "long" }, "status": { "type": "integer" }, "team_id": { "type": "string", "index": "not_analyzed" } } } } } }
please me solve issue. thank you.
Comments
Post a Comment