Last active
February 18, 2017 17:54
-
-
Save cerias/bd5eaf7ec96c4a2e26b10a6f35210faa to your computer and use it in GitHub Desktop.
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
{ | |
"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