原始数据如下
{ "took" : 1, "timed_out" : false, "_shards" : { "total" : 1, "successful" : 1, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 8, "relation" : "eq" }, "max_score" : 1.0, "hits" : [ { "_index" : "customer", "_type" : "external", "_id" : "4", "_score" : 1.0, "_source" : { "name" : "nadia", "sex" : "gril", "age" : 31 } }, { "_index" : "customer", "_type" : "external", "_id" : "5", "_score" : 1.0, "_source" : { "name" : "jxx", "sex" : "gril", "age" : 45, "addr" : "北京" } }, { "_index" : "customer", "_type" : "external", "_id" : "7", "_score" : 1.0, "_source" : { "name" : "abb", "sex" : "boy", "age" : 35, "addr" : "南京" } }, { "_index" : "customer", "_type" : "external", "_id" : "8", "_score" : 1.0, "_source" : { "name" : "abb11", "sex" : "boy", "age" : 36, "addr" : "南京" } }, { "_index" : "customer", "_type" : "external", "_id" : "2", "_score" : 1.0, "_source" : { "name" : "木子小僧888666", "sex" : "boy", "age" : 25, "addr" : "白宫" } }, { "_index" : "customer", "_type" : "external", "_id" : "3", "_score" : 1.0, "_source" : { "name" : "特朗普", "sex" : "boy", "age" : 88, "addr" : "白宫" } }, { "_index" : "customer", "_type" : "external", "_id" : "1", "_score" : 1.0, "_source" : { "name" : "木子小僧666999888", "sex" : "boy", "age" : 30 } }, { "_index" : "customer", "_type" : "external", "_id" : "dwy-YXcB9G0dRFSpm0LY", "_score" : 1.0, "_source" : { "properties" : { "content" : { "type" : "text", "analyzer" : "ik_max_word", "search_analyzer" : "ik_max_word" } } } } ] } }
聚合代码如下：
GET /customer/_search { "query": { "match_all": {} }, "aggs": { "ageAgg":{ "terms": { "field": "age", "size": 10 } } } }
会出现以下错误：
{ "error" : { "root_cause" : [ { "type" : "illegal_argument_exception", "reason" : "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [age] in order to load field data by uninverting the inverted index. Note that this can use significant memory." } ], "type" : "search_phase_execution_exception", "reason" : "all shards failed", "phase" : "query", "grouped" : true, "failed_shards" : [ { "shard" : 0, "index" : "customer", "node" : "EzyH308RT0iU4WNgOa2J5Q", "reason" : { "type" : "illegal_argument_exception", "reason" : "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [interests] in order to load field data by uninverting the inverted index. Note that this can use significant memory." } } ], "caused_by" : { "type" : "illegal_argument_exception", "reason" : "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [interests] in order to load field data by uninverting the inverted index. Note that this can use significant memory.", "caused_by" : { "type" : "illegal_argument_exception", "reason" : "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [interests] in order to load field data by uninverting the inverted index. Note that this can use significant memory." } } }, "status" : 400 }
我们需要执行一下
PUT /customer/_mapping?pretty { "properties": { "age": { "type": "text", "fielddata": true } } }
将fielddata=true