es中keyword字符串类型排序问题

野性酷女 2022-12-30 08:21 347阅读 0赞

kibana中请求如下  
size为返回条数，source为返回字段，aggs为聚合查询，sum为求和

GET /tms-pro-insurance-record-beta-1/_search
    { 
      "track_scores": false,
      "_source": [
        "order_num",
        "company_id",
        "Order|b_tr_car_batch",
        "create_time",
        "ol_create_time",
        "show_order_flags",
        "insure_com_id",
        "id",
        "uuid",
        "od_id",
        "od_link_id",
        "b_basic_id"
      ],
      "query": { 
        "bool": { 
          "must": [
            { 
              "term": { 
                "company_id": 44392
              }
            }
          ],
          "filter": { 
            "bool": { 
              "must": [
                { 
                  "term": { 
                    "status": 1
                  }
                }
              ]
            }
          }
        }
      },
      "size": 20, 
      "aggs": { 
        "g_num": { 
          "sum": { 
            "field": "g_num"
          }
        }
        
      },
      "sort": [
        { 
          "id": "desc"
        },
        { 
          "create_time": "desc"
        }
      ]
    }

返回数据如下

{ 
      "took" : 3,
      "timed_out" : false,
      "_shards" : { 
        "total" : 5,
        "successful" : 5,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : { 
        "total" : 18,
        "max_score" : null,
        "hits" : [
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_99",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200073",
              "create_time" : "2020-12-24 08:42:16",
              "company_id" : "44392",
              "od_link_id" : 152417298,
              "id" : "99",
              "order_num" : "A66600120120126",
              "b_basic_id" : "20249562",
              "uuid" : "88888_99",
              "od_id" : "105791251",
              "show_order_flags" : [
                "can_order_pickup"
              ]
            },
            "sort" : [
              "99"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_90",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200066",
              "create_time" : "2020-12-22 16:59:04",
              "company_id" : "44392",
              "od_link_id" : 152417272,
              "id" : "90",
              "order_num" : "A66600120120117",
              "b_basic_id" : "20249547",
              "uuid" : "88888_90",
              "od_id" : "105791226",
              "show_order_flags" : [
                "can_order_pickup"
              ]
            },
            "sort" : [
              "90"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_89",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200065",
              "create_time" : "2020-12-22 16:57:11",
              "company_id" : "44392",
              "od_link_id" : 152417271,
              "id" : "89",
              "order_num" : "A66600120120116",
              "b_basic_id" : "20249546",
              "uuid" : "88888_89",
              "od_id" : "105791225",
              "show_order_flags" : [ ]
            },
            "sort" : [
              "89"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_82",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200058",
              "create_time" : "2020-12-21 11:24:56",
              "company_id" : "44392",
              "od_link_id" : 152417231,
              "id" : "82",
              "order_num" : "A66600120120099",
              "b_basic_id" : "20249524",
              "uuid" : "88888_82",
              "od_id" : "105791197",
              "show_order_flags" : [
                "passed_om",
                "can_order_pickup"
              ]
            },
            "sort" : [
              "82"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_103",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200076",
              "create_time" : "2020-12-24 13:50:58",
              "company_id" : "44392",
              "od_link_id" : 152417304,
              "id" : "103",
              "order_num" : "A66600120120132",
              "b_basic_id" : "20249565",
              "uuid" : "88888_103",
              "od_id" : "105791257",
              "show_order_flags" : [
                "can_order_pickup"
              ]
            },
            "sort" : [
              "103"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_101",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200075",
              "create_time" : "2020-12-24 10:08:51",
              "company_id" : "44392",
              "od_link_id" : 152417302,
              "id" : "101",
              "order_num" : "A66600120120130",
              "b_basic_id" : "20249564",
              "uuid" : "88888_101",
              "od_id" : "105791255",
              "show_order_flags" : [
                "can_order_pickup"
              ]
            },
            "sort" : [
              "101"
            ]
          },
          { 
            "_index" : "tms-pro-insurance-record-beta-1",
            "_type" : "_doc",
            "_id" : "88888_100",
            "_score" : null,
            "_source" : { 
              "Order|b_tr_car_batch" : "A666001GX201200074",
              "create_time" : "2020-12-24 08:48:11",
              "company_id" : "44392",
              "od_link_id" : 152417300,
              "id" : "100",
              "order_num" : "A66600120120128",
              "b_basic_id" : "20249563",
              "uuid" : "88888_100",
              "od_id" : "105791253",
              "show_order_flags" : [
                "can_order_pickup"
              ]
            },
            "sort" : [
              "100"
            ]
          }
        ]
      },
      "aggregations" : { 
        "g_num" : { 
          "value" : 18.0
        }
      }
    }

在id为keyword类型的情况下，根据id排序会按字符串排序，顺序和要求的不同，所以如果不按时间排序的话，可以以int类型字段排序