NumberFormatException on facetting by field

barnybug · January 12, 2012, 6:23pm

See test case here:

gist.github.com

https://gist.github.com/barnybug/1602182

gistfile1.txt

SERVER='http://127.0.0.1:9200/'

curl -XDELETE "$SERVER/test/"
curl -XPUT "$SERVER/test/"
curl -XPUT "$SERVER/test/a/_mapping" -d '{"a": {"properties": {"field1": {"type": "integer"}}}}'
curl -XPUT "$SERVER/test/b/1" -d '{"field1": 1}'
sleep 1
curl -XGET 'http://localhost:9200/test/a/_search?size=0' -d '{"facets":{"f":{"terms":{"field":"field1"}}},"query":{"match_all":{}}}'

Hopefully nothing I'm obviously doing wrong - on 0.18.7 I see this
error to the query:

gist.github.com

https://gist.github.com/barnybug/1602207

gistfile1.txt

{"ok":true,"_index":"test","_type":"b","_id":"1","_version":1}{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 4,
    "failed" : 1,
    "failures" : [ {
      "index" : "test",
      "shard" : 2,

This file has been truncated. show original

"QueryPhaseExecutionException[[test][2]:
query[filtered(ConstantScore(:))-

FilterCacheFilterWrapper(_type:a)],from[0],size[10]: Query Failed
[Failed to execute main query]]; nested: NumberFormatException[Invalid
shift value in prefixCoded string (is encoded value really an INT?)];
"

Help appreciated!

regards,

Barnaby

kimchy · January 12, 2012, 9:56pm

You have a field named field1 on both mapping types, a and b, but they are
not of the same field type. The first is an integer, the second is a long
(automatically derived). For facets / sorting, field types with the same
name across mapping types must be the same (its an optimization to conserve
memory) even though you specifically define the mapping type to search on.

On Thu, Jan 12, 2012 at 8:23 PM, barnybug barnybug@googlemail.com wrote:

See test case here:
gist:1602182 · GitHub

Hopefully nothing I'm obviously doing wrong - on 0.18.7 I see this
error to the query:
gist:1602207 · GitHub
"QueryPhaseExecutionException[[test][2]:
query[filtered(ConstantScore(:))-

FilterCacheFilterWrapper(_type:a)],from[0],size[10]: Query Failed
[Failed to execute main query]]; nested: NumberFormatException[Invalid
shift value in prefixCoded string (is encoded value really an INT?)];
"

Help appreciated!

regards,

Barnaby

barnybug · January 13, 2012, 11:07am

Good spot. Thanks.

regards,

Barnaby

On Jan 12, 9:56 pm, Shay Banon kim...@gmail.com wrote:

You have a field named field1 on both mapping types, a and b, but they are
not of the same field type. The first is an integer, the second is a long
(automatically derived). For facets / sorting, field types with the same
name across mapping types must be the same (its an optimization to conserve
memory) even though you specifically define the mapping type to search on.

On Thu, Jan 12, 2012 at 8:23 PM, barnybug barny...@googlemail.com wrote:

See test case here:
gist:1602182 · GitHub

Hopefully nothing I'm obviously doing wrong - on 0.18.7 I see this
error to the query:
gist:1602207 · GitHub
"QueryPhaseExecutionException[[test][2]:
query[filtered(ConstantScore(:))-

FilterCacheFilterWrapper(_type:a)],from[0],size[10]: Query Failed
[Failed to execute main query]]; nested: NumberFormatException[Invalid
shift value in prefixCoded string (is encoded value really an INT?)];
"

Help appreciated!

regards,

Barnaby

Topic		Replies	Views
NumberFormatException doing a query we've done tons of times (from kibana) Elasticsearch	2	616	July 5, 2017
Failed to add StatisticalFacet on a integer type field ( NumberFormatException: Invalid shift value in prefixCoded string (is encoded value really an INT?) ) Elasticsearch	5	478	July 6, 2017
500 "Number format exception" on Terms Aggregation Elasticsearch	2	808	July 6, 2017
NumberFormatException when sorting by numeric document ID Elasticsearch	9	724	July 6, 2017
Search exceptions, is value really an INT (field names/type) Elasticsearch	3	2925	July 5, 2017

NumberFormatException on facetting by field

Related topics