dsl语句

最新推荐文章于 2024-09-13 00:05:35 发布

江上渔者21号

最新推荐文章于 2024-09-13 00:05:35 发布

阅读量683

点赞数

分类专栏： Elasticsearch

本文链接：https://blog.csdn.net/u010325193/article/details/88126888

版权

Elasticsearch 专栏收录该内容

28 篇文章 2 订阅

订阅专栏

糊糊匹配和精切匹配查询会报错

{
  "query": {
    "match" : {
      "caseId" : 22311575
    }
    ,
    "bool": {
      "must": [
        {
          "match_all": {}
        }
      ],
      "must_not": [],
      "should": [],
      "filter": []
    }
  },
  "from": 0,
  "size": 10,
  "sort": []
}

直接模糊匹配就可以了

{
  "query": {
    "match" : {
      "caseId" : 22311575
    }
  },
  "from": 0,
  "size": 10,
  "sort": []
}

{
  "took": 2,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 1,
    "hits": [
      {
        "_index": "csc-case",
        "_type": "case-info",
        "_id": "22311575",
        "_score": 1,
        "_source": {
          "orderId": "[\"45721812\",\"4414567049\"]",
          "dataObject_168": "45721812",
          "latest_dataobject_168_scn": 9836440143286,
          "_case_dtc_168_binlog_uptime": 1529660079000,
          "_case_dtc_168_database_uptime": 1529660079000,
          "_case_dtc_168_uptime": 1529660079513,
          "caseId": "22311575",
          "dataObject_166": "4414567049",
          "latest_dataobject_166_scn": 9836440143286,
          "_case_dtc_166_database_uptime": 1529660079000,
          "_case_dtc_166_uptime": 1529660079569,
          "_case_dtc_166_binlog_uptime": 1529660079000,
          "_case_dtc_2_binlog_uptime": 1529660079000,
          "_case_dtc_2_database_uptime": 1529660079000,
          "dataObject_2": "1711775149",
          "_case_dtc_2_uptime": 1529660079644,
          "latest_dataobject_2_scn": 9836440143286,
          "_case_dtc_65_uptime": 1529660079689,
          "latest_dataobject_65_scn": 9836440143286,
          "_case_dtc_65_database_uptime": 1529660079000,
          "_case_dtc_65_binlog_uptime": 1529660079000,
          "dataObject_65": "1711775149",
          "caseTypeId": "258",
          "questionId": "5258",
          "addTime": 1529660079000,
          "subSource": "-1",
          "creatorId": "5851",
          "businessId": "2",
          "businessName": null,
          "fifthCategoryId": null,
          "orderTypeId": "118",
          "memo": null,
          "fourthCategoryId": null,
          "source": "2",
          "ownerId": "5851",
          "questionTypeId": "836",
          "content": null,
          "priorityId": "5",
          "feedbackTime": null,
          "customerType": "1001",
          "questionReasonId": "3150",
          "updaterId": "5851",
          "closerId": "5851",
          "closeTime": 1529660080000,
          "contactNumber": "[\"\",\"17354650131\"]",
          "customerId": "1711775149",
          "bizId": null,
          "startTime": 1529660079000,
          "nameSpace": null,
          "deadline": 1529746479000,
          "flowId": "301",
          "latest_main_es_update_time": 1529660080437,
          "updateTime": 1529660080000,
          "latest_main_scn": 9836440417392,
          "statusId": "2",
          "nodeId": "31871",
          "lifeCycle": "1",
          "caseStatistics_reopenCount": 0,
          "caseStatistics_callOutCount": 0,
          "caseStatistics_lastAttachmentTime": null,
          "latest_statistics_update_time": 1529660080728,
          "latest_statistics_db_update_time": 1529660081000,
          "caseStatistics_refundSuccessCount": 0,
          "lastest_statistics_scn": 9836440528174,
          "caseStatistics_attachmentCount": 0,
          "caseStatistics_latestAttachmentStaffId": null,
          "caseStatistics_urgeCount": 0,
          "caseStatistics_lastCommentTime": null,
          "caseStatistics_smsCount": 0,
          "caseStatistics_latestReopenStaffId": null,
          "caseStatistics_commentCount": 0,
          "caseStatistics_chatCount": 1,
          "caseStatistics_refundInvokeCount": 0,
          "caseStatistics_callInCount": 0,
          "caseStatistics_pushCount": 0,
          "caseStatistics_refundAmountCount": 0,
          "caseStatistics_latestReopenTime": null,
          "caseStatistics_lastCommentStaffId": null,
          "caseStatistics_elephantCount": 0,
          "caseStatistics_emailCount": 0,
          "caseStatistics_refundSubmitCount": 0
        }
      }
    ]
  }
}