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