Last active
December 15, 2015 06:19
-
-
Save roytmana/5215441 to your computer and use it in GitHub Desktop.
ES 0.9RC1 Facet Broken
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//0.9 fails to count missing values when faceting on a numeric field. If some records are missing the value, they will not be accounted for in facet's "missing" field. faceting on string field seems to work fine | |
//It worked fine in 0.2.x | |
//Another issue is that setting facet size to 0 returns no facets rather than all of them | |
//Create Index | |
curl -XPOST http://localhost:9200/test -d { | |
"settings": { | |
"number_of_shards": 1, | |
"number_of_replicas": 1 | |
} | |
} | |
//load data | |
curl -XPOST http://localhost:9200/test/test1/_bulk -d | |
{"index":{"_id":"1"}} | |
{"id":"1","name":"1","key":1} | |
{"index":{"_id":"2"}} | |
{"id":"2","name":"2"} | |
{"index":{"_id":"3"}} | |
{"id":"3","name":"3","key":3} | |
{"index":{"_id":"4"}} | |
{"id":"4","name":"4"} | |
{"index":{"_id":"5"}} | |
{"id":"5","name":"5","key":5} | |
{"index":{"_id":"6"}} | |
{"id":"6","name":"6"} | |
{"index":{"_id":"7"}} | |
{"id":"7","name":"7","key":7} | |
{"index":{"_id":"8"}} | |
{"id":"8","name":"8"} | |
{"index":{"_id":"9"}} | |
{"id":"9","name":"9","key":9} | |
{"index":{"_id":"10"}} | |
{"id":"10","name":"10"} | |
{"index":{"_id":"11"}} | |
{"id":"11","name":"11","key":11} | |
{"index":{"_id":"12"}} | |
{"id":"12","name":"12"} | |
{"index":{"_id":"13"}} | |
{"id":"13","name":"13","key":13} | |
{"index":{"_id":"14"}} | |
{"id":"14","name":"14"} | |
{"index":{"_id":"15"}} | |
{"id":"15","name":"15","key":15} | |
{"index":{"_id":"16"}} | |
{"id":"16","name":"16"} | |
{"index":{"_id":"17"}} | |
{"id":"17","name":"17","key":17} | |
{"index":{"_id":"18"}} | |
{"id":"18","name":"18"} | |
{"index":{"_id":"19"}} | |
{"id":"19","name":"19","key":19} | |
{"index":{"_id":"20"}} | |
{"id":"20","name":"20"} | |
{"index":{"_id":"21"}} | |
{"id":"21","name":"21","key":21} | |
{"index":{"_id":"22"}} | |
{"id":"22","name":"22"} | |
{"index":{"_id":"23"}} | |
{"id":"23","name":"23","key":23} | |
{"index":{"_id":"24"}} | |
{"id":"24","name":"24"} | |
{"index":{"_id":"25"}} | |
{"id":"25","name":"25","key":25} | |
{"index":{"_id":"26"}} | |
{"id":"26","name":"26"} | |
{"index":{"_id":"27"}} | |
{"id":"27","name":"27","key":27} | |
{"index":{"_id":"28"}} | |
{"id":"28","name":"28"} | |
{"index":{"_id":"29"}} | |
{"id":"29","name":"29","key":29} | |
{"index":{"_id":"30"}} | |
{"id":"30","name":"30"} | |
{"index":{"_id":"31"}} | |
{"id":"31","name":"31","key":31} | |
{"index":{"_id":"32"}} | |
{"id":"32","name":"32"} | |
{"index":{"_id":"33"}} | |
{"id":"33","name":"33","key":33} | |
{"index":{"_id":"34"}} | |
{"id":"34","name":"34"} | |
{"index":{"_id":"35"}} | |
{"id":"35","name":"35","key":35} | |
{"index":{"_id":"36"}} | |
{"id":"36","name":"36"} | |
{"index":{"_id":"37"}} | |
{"id":"37","name":"37","key":37} | |
{"index":{"_id":"38"}} | |
{"id":"38","name":"38"} | |
{"index":{"_id":"39"}} | |
{"id":"39","name":"39","key":39} | |
{"index":{"_id":"40"}} | |
{"id":"40","name":"40"} | |
{"index":{"_id":"41"}} | |
{"id":"41","name":"41","key":41} | |
{"index":{"_id":"42"}} | |
{"id":"42","name":"42"} | |
{"index":{"_id":"43"}} | |
{"id":"43","name":"43","key":43} | |
{"index":{"_id":"44"}} | |
{"id":"44","name":"44"} | |
{"index":{"_id":"45"}} | |
{"id":"45","name":"45","key":45} | |
{"index":{"_id":"46"}} | |
{"id":"46","name":"46"} | |
{"index":{"_id":"47"}} | |
{"id":"47","name":"47","key":47} | |
{"index":{"_id":"48"}} | |
{"id":"48","name":"48"} | |
{"index":{"_id":"49"}} | |
{"id":"49","name":"49","key":49} | |
{"index":{"_id":"50"}} | |
{"id":"50","name":"50"} | |
{"index":{"_id":"51"}} | |
{"id":"51","name":"51","key":51} | |
{"index":{"_id":"52"}} | |
{"id":"52","name":"52"} | |
{"index":{"_id":"53"}} | |
{"id":"53","name":"53","key":53} | |
{"index":{"_id":"54"}} | |
{"id":"54","name":"54"} | |
{"index":{"_id":"55"}} | |
{"id":"55","name":"55","key":55} | |
{"index":{"_id":"56"}} | |
{"id":"56","name":"56"} | |
{"index":{"_id":"57"}} | |
{"id":"57","name":"57","key":57} | |
{"index":{"_id":"58"}} | |
{"id":"58","name":"58"} | |
{"index":{"_id":"59"}} | |
{"id":"59","name":"59","key":59} | |
{"index":{"_id":"60"}} | |
{"id":"60","name":"60"} | |
{"index":{"_id":"61"}} | |
{"id":"61","name":"61","key":61} | |
{"index":{"_id":"62"}} | |
{"id":"62","name":"62"} | |
{"index":{"_id":"63"}} | |
{"id":"63","name":"63","key":63} | |
{"index":{"_id":"64"}} | |
{"id":"64","name":"64"} | |
{"index":{"_id":"65"}} | |
{"id":"65","name":"65","key":65} | |
{"index":{"_id":"66"}} | |
{"id":"66","name":"66"} | |
{"index":{"_id":"67"}} | |
{"id":"67","name":"67","key":67} | |
{"index":{"_id":"68"}} | |
{"id":"68","name":"68"} | |
{"index":{"_id":"69"}} | |
{"id":"69","name":"69","key":69} | |
{"index":{"_id":"70"}} | |
{"id":"70","name":"70"} | |
{"index":{"_id":"71"}} | |
{"id":"71","name":"71","key":71} | |
{"index":{"_id":"72"}} | |
{"id":"72","name":"72"} | |
{"index":{"_id":"73"}} | |
{"id":"73","name":"73","key":73} | |
{"index":{"_id":"74"}} | |
{"id":"74","name":"74"} | |
{"index":{"_id":"75"}} | |
{"id":"75","name":"75","key":75} | |
{"index":{"_id":"76"}} | |
{"id":"76","name":"76"} | |
{"index":{"_id":"77"}} | |
{"id":"77","name":"77","key":77} | |
{"index":{"_id":"78"}} | |
{"id":"78","name":"78"} | |
{"index":{"_id":"79"}} | |
{"id":"79","name":"79","key":79} | |
{"index":{"_id":"80"}} | |
{"id":"80","name":"80"} | |
{"index":{"_id":"81"}} | |
{"id":"81","name":"81","key":81} | |
{"index":{"_id":"82"}} | |
{"id":"82","name":"82"} | |
{"index":{"_id":"83"}} | |
{"id":"83","name":"83","key":83} | |
{"index":{"_id":"84"}} | |
{"id":"84","name":"84"} | |
{"index":{"_id":"85"}} | |
{"id":"85","name":"85","key":85} | |
{"index":{"_id":"86"}} | |
{"id":"86","name":"86"} | |
{"index":{"_id":"87"}} | |
{"id":"87","name":"87","key":87} | |
{"index":{"_id":"88"}} | |
{"id":"88","name":"88"} | |
{"index":{"_id":"89"}} | |
{"id":"89","name":"89","key":89} | |
{"index":{"_id":"90"}} | |
{"id":"90","name":"90"} | |
{"index":{"_id":"91"}} | |
{"id":"91","name":"91","key":91} | |
{"index":{"_id":"92"}} | |
{"id":"92","name":"92"} | |
{"index":{"_id":"93"}} | |
{"id":"93","name":"93","key":93} | |
{"index":{"_id":"94"}} | |
{"id":"94","name":"94"} | |
{"index":{"_id":"95"}} | |
{"id":"95","name":"95","key":95} | |
{"index":{"_id":"96"}} | |
{"id":"96","name":"96"} | |
{"index":{"_id":"97"}} | |
{"id":"97","name":"97","key":97} | |
{"index":{"_id":"98"}} | |
{"id":"98","name":"98"} | |
{"index":{"_id":"99"}} | |
{"id":"99","name":"99","key":99} | |
{"index":{"_id":"100"}} | |
{"id":"100","name":"100"} | |
{"index":{"_id":"101"}} | |
{"id":"101","name":"101","key":101} | |
{"index":{"_id":"102"}} | |
{"id":"102","name":"102"} | |
{"index":{"_id":"103"}} | |
{"id":"103","name":"103","key":103} | |
{"index":{"_id":"104"}} | |
{"id":"104","name":"104"} | |
{"index":{"_id":"105"}} | |
{"id":"105","name":"105","key":105} | |
{"index":{"_id":"106"}} | |
{"id":"106","name":"106"} | |
{"index":{"_id":"107"}} | |
{"id":"107","name":"107","key":107} | |
{"index":{"_id":"108"}} | |
{"id":"108","name":"108"} | |
{"index":{"_id":"109"}} | |
{"id":"109","name":"109","key":109} | |
{"index":{"_id":"110"}} | |
{"id":"110","name":"110"} | |
{"index":{"_id":"111"}} | |
{"id":"111","name":"111","key":111} | |
{"index":{"_id":"112"}} | |
{"id":"112","name":"112"} | |
{"index":{"_id":"113"}} | |
{"id":"113","name":"113","key":113} | |
{"index":{"_id":"114"}} | |
{"id":"114","name":"114"} | |
{"index":{"_id":"115"}} | |
{"id":"115","name":"115","key":115} | |
{"index":{"_id":"116"}} | |
{"id":"116","name":"116"} | |
{"index":{"_id":"117"}} | |
{"id":"117","name":"117","key":117} | |
{"index":{"_id":"118"}} | |
{"id":"118","name":"118"} | |
{"index":{"_id":"119"}} | |
{"id":"119","name":"119","key":119} | |
{"index":{"_id":"120"}} | |
{"id":"120","name":"120"} | |
{"index":{"_id":"121"}} | |
{"id":"121","name":"121","key":121} | |
{"index":{"_id":"122"}} | |
{"id":"122","name":"122"} | |
{"index":{"_id":"123"}} | |
{"id":"123","name":"123","key":123} | |
{"index":{"_id":"124"}} | |
{"id":"124","name":"124"} | |
{"index":{"_id":"125"}} | |
{"id":"125","name":"125","key":125} | |
{"index":{"_id":"126"}} | |
{"id":"126","name":"126"} | |
{"index":{"_id":"127"}} | |
{"id":"127","name":"127","key":127} | |
{"index":{"_id":"128"}} | |
{"id":"128","name":"128"} | |
{"index":{"_id":"129"}} | |
{"id":"129","name":"129","key":129} | |
{"index":{"_id":"130"}} | |
{"id":"130","name":"130"} | |
{"index":{"_id":"131"}} | |
{"id":"131","name":"131","key":131} | |
{"index":{"_id":"132"}} | |
{"id":"132","name":"132"} | |
{"index":{"_id":"133"}} | |
{"id":"133","name":"133","key":133} | |
{"index":{"_id":"134"}} | |
{"id":"134","name":"134"} | |
{"index":{"_id":"135"}} | |
{"id":"135","name":"135","key":135} | |
{"index":{"_id":"136"}} | |
{"id":"136","name":"136"} | |
{"index":{"_id":"137"}} | |
{"id":"137","name":"137","key":137} | |
{"index":{"_id":"138"}} | |
{"id":"138","name":"138"} | |
{"index":{"_id":"139"}} | |
{"id":"139","name":"139","key":139} | |
{"index":{"_id":"140"}} | |
{"id":"140","name":"140"} | |
{"index":{"_id":"141"}} | |
{"id":"141","name":"141","key":141} | |
{"index":{"_id":"142"}} | |
{"id":"142","name":"142"} | |
{"index":{"_id":"143"}} | |
{"id":"143","name":"143","key":143} | |
{"index":{"_id":"144"}} | |
{"id":"144","name":"144"} | |
{"index":{"_id":"145"}} | |
{"id":"145","name":"145","key":145} | |
{"index":{"_id":"146"}} | |
{"id":"146","name":"146"} | |
{"index":{"_id":"147"}} | |
{"id":"147","name":"147","key":147} | |
{"index":{"_id":"148"}} | |
{"id":"148","name":"148"} | |
{"index":{"_id":"149"}} | |
{"id":"149","name":"149","key":149} | |
{"index":{"_id":"150"}} | |
{"id":"150","name":"150"} | |
{"index":{"_id":"151"}} | |
{"id":"151","name":"151","key":151} | |
{"index":{"_id":"152"}} | |
{"id":"152","name":"152"} | |
{"index":{"_id":"153"}} | |
{"id":"153","name":"153","key":153} | |
{"index":{"_id":"154"}} | |
{"id":"154","name":"154"} | |
{"index":{"_id":"155"}} | |
{"id":"155","name":"155","key":155} | |
{"index":{"_id":"156"}} | |
{"id":"156","name":"156"} | |
{"index":{"_id":"157"}} | |
{"id":"157","name":"157","key":157} | |
{"index":{"_id":"158"}} | |
{"id":"158","name":"158"} | |
{"index":{"_id":"159"}} | |
{"id":"159","name":"159","key":159} | |
{"index":{"_id":"160"}} | |
{"id":"160","name":"160"} | |
{"index":{"_id":"161"}} | |
{"id":"161","name":"161","key":161} | |
{"index":{"_id":"162"}} | |
{"id":"162","name":"162"} | |
{"index":{"_id":"163"}} | |
{"id":"163","name":"163","key":163} | |
{"index":{"_id":"164"}} | |
{"id":"164","name":"164"} | |
{"index":{"_id":"165"}} | |
{"id":"165","name":"165","key":165} | |
{"index":{"_id":"166"}} | |
{"id":"166","name":"166"} | |
{"index":{"_id":"167"}} | |
{"id":"167","name":"167","key":167} | |
{"index":{"_id":"168"}} | |
{"id":"168","name":"168"} | |
{"index":{"_id":"169"}} | |
{"id":"169","name":"169","key":169} | |
{"index":{"_id":"170"}} | |
{"id":"170","name":"170"} | |
{"index":{"_id":"171"}} | |
{"id":"171","name":"171","key":171} | |
{"index":{"_id":"172"}} | |
{"id":"172","name":"172"} | |
{"index":{"_id":"173"}} | |
{"id":"173","name":"173","key":173} | |
{"index":{"_id":"174"}} | |
{"id":"174","name":"174"} | |
{"index":{"_id":"175"}} | |
{"id":"175","name":"175","key":175} | |
{"index":{"_id":"176"}} | |
{"id":"176","name":"176"} | |
{"index":{"_id":"177"}} | |
{"id":"177","name":"177","key":177} | |
{"index":{"_id":"178"}} | |
{"id":"178","name":"178"} | |
{"index":{"_id":"179"}} | |
{"id":"179","name":"179","key":179} | |
{"index":{"_id":"180"}} | |
{"id":"180","name":"180"} | |
{"index":{"_id":"181"}} | |
{"id":"181","name":"181","key":181} | |
{"index":{"_id":"182"}} | |
{"id":"182","name":"182"} | |
{"index":{"_id":"183"}} | |
{"id":"183","name":"183","key":183} | |
{"index":{"_id":"184"}} | |
{"id":"184","name":"184"} | |
{"index":{"_id":"185"}} | |
{"id":"185","name":"185","key":185} | |
{"index":{"_id":"186"}} | |
{"id":"186","name":"186"} | |
{"index":{"_id":"187"}} | |
{"id":"187","name":"187","key":187} | |
{"index":{"_id":"188"}} | |
{"id":"188","name":"188"} | |
{"index":{"_id":"189"}} | |
{"id":"189","name":"189","key":189} | |
{"index":{"_id":"190"}} | |
{"id":"190","name":"190"} | |
{"index":{"_id":"191"}} | |
{"id":"191","name":"191","key":191} | |
{"index":{"_id":"192"}} | |
{"id":"192","name":"192"} | |
{"index":{"_id":"193"}} | |
{"id":"193","name":"193","key":193} | |
{"index":{"_id":"194"}} | |
{"id":"194","name":"194"} | |
{"index":{"_id":"195"}} | |
{"id":"195","name":"195","key":195} | |
{"index":{"_id":"196"}} | |
{"id":"196","name":"196"} | |
{"index":{"_id":"197"}} | |
{"id":"197","name":"197","key":197} | |
{"index":{"_id":"198"}} | |
{"id":"198","name":"198"} | |
{"index":{"_id":"199"}} | |
{"id":"199","name":"199","key":199} | |
{"index":{"_id":"200"}} | |
{"id":"200","name":"200"} | |
//query | |
{ | |
"query": { | |
"match_all": {} | |
}, | |
"from": 0, | |
"facets": { | |
"key": { | |
"terms": { | |
"field": "key", | |
"size": 5 | |
} | |
} | |
}, | |
"size": 0 | |
} | |
//facet "missing" field is 0 completely missing 100 records where key field is blank | |
//total number of records is 200 facet is only accountin for 100 where key is not blank | |
{ | |
"took": 0, | |
"timed_out": false, | |
"_shards": { | |
"total": 1, | |
"successful": 1, | |
"failed": 0 | |
}, | |
"hits": { | |
"total": 200, | |
"max_score": 1.0, | |
"hits": [] | |
}, | |
"facets": { | |
"key": { | |
"_type": "terms", | |
"missing": 0, | |
"total": 100, | |
"other": 95, | |
"terms": [ | |
{ | |
"term": 199, | |
"count": 1 | |
}, | |
{ | |
"term": 197, | |
"count": 1 | |
}, | |
{ | |
"term": 195, | |
"count": 1 | |
}, | |
{ | |
"term": 193, | |
"count": 1 | |
}, | |
{ | |
"term": 191, | |
"count": 1 | |
} | |
] | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment