作废,请版主删除,谢谢!
本帖最后由 540558233 于 2020-9-14 13:54 编辑此贴作废 写出来了吗，用es-sql 跑了一下，没测正确性。
{
"_source": {
"excludes": [],
"includes": [
"com.alibaba.druid.xzl.sql.ast.expr.SQLAggregateExpr@63ff0831",
"COUNT"
]
},
"aggregations": {
"sysdt_d": {
"aggregations": {
"kv_from": {
"aggregations": {
"ui": {
"aggregations": {
"kv_itemId": {
"aggregations": {
"count": {
"value_count": {
"field": "_index"
}
}
},
"terms": {
"field": "kv_itemId",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "ui",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "kv_from",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "sysdt_d",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 3,
"shard_size": 2000,
"show_term_doc_count_error": false,
"size": 2
}
}
},
"from": 0,
"query": {
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"filter": [
{
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"must": [
{
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"must": [
{
"match_phrase": {
"ei": {
"boost": 1.0,
"query": "ga.sx.btn",
"slop": 0
}
}
},
{
"range": {
"sysdt_d": {
"boost": 1.0,
"from": "2020-07-01",
"include_lower": true,
"include_upper": true
}
}
},
{
"range": {
"sysdt_d": {
"boost": 1.0,
"include_lower": true,
"include_upper": true,
"to": "2020-07-30"
}
}
}
]
}
}
]
}
}
]
}
},
"size": 0,
"stored_fields": "com.alibaba.druid.xzl.sql.ast.expr.SQLAggregateExpr@63ff0831"
} 换php风格好看点
{
"_source": {
"excludes": [],
"includes": [
"com.alibaba.druid.xzl.sql.ast.expr.SQLAggregateExpr@63ff0831",
"COUNT"
]
},
"aggregations": {
"sysdt_d": {
"aggregations": {
"kv_from": {
"aggregations": {
"ui": {
"aggregations": {
"kv_itemId": {
"aggregations": {
"count": {
"value_count": {
"field": "_index"
}
}
},
"terms": {
"field": "kv_itemId",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "ui",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "kv_from",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 0,
"show_term_doc_count_error": false,
"size": 10
}
}
},
"terms": {
"field": "sysdt_d",
"min_doc_count": 1,
"order": [
{
"_count": "desc"
},
{
"_term": "asc"
}
],
"shard_min_doc_count": 3,
"shard_size": 2000,
"show_term_doc_count_error": false,
"size": 2
}
}
},
"from": 0,
"query": {
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"filter": [
{
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"must": [
{
"bool": {
"adjust_pure_negative": true,
"boost": 1.0,
"disable_coord": false,
"must": [
{
"match_phrase": {
"ei": {
"boost": 1.0,
"query": "ga.sx.btn",
"slop": 0
}
}
},
{
"range": {
"sysdt_d": {
"boost": 1.0,
"from": "2020-07-01",
"include_lower": true,
"include_upper": true
}
}
},
{
"range": {
"sysdt_d": {
"boost": 1.0,
"include_lower": true,
"include_upper": true,
"to": "2020-07-30"
}
}
}
]
}
}
]
}
}
]
}
},
"size": 0,
"stored_fields": "com.alibaba.druid.xzl.sql.ast.expr.SQLAggregateExpr@63ff0831"
}
页:
[1]