Skip to content

Instantly share code, notes, and snippets.

@cerias
Last active February 18, 2017 17:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cerias/bd5eaf7ec96c4a2e26b10a6f35210faa to your computer and use it in GitHub Desktop.
Save cerias/bd5eaf7ec96c4a2e26b10a6f35210faa to your computer and use it in GitHub Desktop.
{
"size" : 0,
"query" : {
"match" : {
"sire.id" : {
"query" : 46178,
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 1.0
}
}
},
"aggregations" : {
"horse" : {
"terms" : {
"field" : "id",
"size" : 100,
"min_doc_count" : 1,
"shard_min_doc_count" : 0,
"show_term_doc_count_error" : false,
"order" : [
{
"_count" : "desc"
},
{
"_term" : "asc"
}
]
},
"aggregations" : {
"child" : {
"terms" : {
"field" : "sire.id",
"size" : 10,
"min_doc_count" : 1,
"shard_min_doc_count" : 0,
"show_term_doc_count_error" : false,
"order" : {
"results.doc_count" : "desc"
}
},
"aggregations" : {
"results" : {
"children" : {
"type" : "Result"
},
"aggregations" : {
"filter" : {
"filter" : {
"bool" : {
"filter" : [
{
"range" : {
"competition.date" : {
"from" : "2015-01-01T00:00Z",
"to" : "2015-12-30T00:00Z",
"include_lower" : true,
"include_upper" : true,
"boost" : 1.0
}
}
},
{
"match" : {
"competition.eventType" : {
"query" : "Jumping",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"aggregations" : {
"ipv" : {
"terms" : {
"field" : "horseId",
"size" : 50000,
"min_doc_count" : 5,
"shard_min_doc_count" : 0,
"show_term_doc_count_error" : false,
"order" : [
{
"_count" : "desc"
},
{
"_term" : "asc"
}
]
},
"aggregations" : {
"stats" : {
"stats" : {
"field" : "isvValueTotal"
}
}
}
},
"bucketStats" : {
"stats_bucket" : {
"buckets_path" : [
"ipv>stats.avg"
],
"gap_policy" : "skip"
}
}
}
}
}
},
"ipv_child" : {
"bucket_script" : {
"buckets_path" : {
"sum_buckets" : "results>filter>bucketStats.sum",
"count_buckets" : "results>filter>bucketStats.count"
},
"script" : {
"inline" : "params.sum_buckets / params.count_buckets",
"lang" : "painless"
},
"gap_policy" : "skip"
}
}
}
},
"grandChild" : {
"terms" : {
"field" : "sire.sire.id",
"size" : 10,
"min_doc_count" : 1,
"shard_min_doc_count" : 0,
"show_term_doc_count_error" : false,
"order" : {
"results.doc_count" : "desc"
}
},
"aggregations" : {
"results" : {
"children" : {
"type" : "Result"
},
"aggregations" : {
"filter" : {
"filter" : {
"bool" : {
"filter" : [
{
"range" : {
"competition.date" : {
"from" : "2015-01-01T00:00Z",
"to" : "2015-12-30T00:00Z",
"include_lower" : true,
"include_upper" : true,
"boost" : 1.0
}
}
},
{
"match" : {
"competition.eventType" : {
"query" : "Jumping",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"aggregations" : {
"ipv" : {
"terms" : {
"field" : "horseId",
"size" : 50000,
"min_doc_count" : 5,
"shard_min_doc_count" : 0,
"show_term_doc_count_error" : false,
"order" : [
{
"_count" : "desc"
},
{
"_term" : "asc"
}
]
},
"aggregations" : {
"stats" : {
"stats" : {
"field" : "isvValueTotal"
}
}
}
},
"bucketStats" : {
"stats_bucket" : {
"buckets_path" : [
"ipv>stats.avg"
],
"gap_policy" : "skip"
}
}
}
}
}
},
"ipv_child" : {
"bucket_script" : {
"buckets_path" : {
"sum_buckets" : "results>filter>bucketStats.sum",
"count_buckets" : "results>filter>bucketStats.count"
},
"script" : {
"inline" : "params.sum_buckets / params.count_buckets",
"lang" : "painless"
},
"gap_policy" : "skip"
}
}
}
},
"ipv_value_total" : {
"bucket_script" : {
"buckets_path" : {
"child" : "child>ipv_child.value",
"grandChild" : "grandChild>ipv_child.value"
},
"script" : {
"inline" : "params.child + (params.grandChild/2)",
"lang" : "painless"
},
"gap_policy" : "skip"
}
}
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment