N久沒動(dòng)手寫東西了，原來的博客估計(jì)被我玩廢了。這次講一個(gè)開發(fā)中遇到的問題。
現(xiàn)在有一個(gè)document如下：

{
  "_index": "test_index_8088",
  "_type": "_doc",
  "_id": "fa358749ec18e",
  "_version": 1,
  "_score": 8.956308,
  "_source": {
    "collectGroupId": "126",
    "createTime": "2018-10-28 21:05:45",
    "products": [
      "6Gq9wI-cAAgAATtm48QX17zNzBinKTwIkMfZClrLxnGxx01Tcui",
      "7Mrm-iPgAAgAASFBdrR7bYVCPK6acU-_9fam7K5ZuzLUysdNuii",
      "9b_L759yAAgAASNTxVpC3L9CV_cKoRgFeuzH6LWbgPrndqO539t",
      "A9jPFpaeAAgAAQby28p89RsysknPafv3NUOspVoORTTUsvCOowj",
      "AFZJwTu0AAgAAR3wO_EfpkYEIrG_cS0hOdLmIRgOoIZH05xqRcE",
      "AcPVcTbmAAgAAQldtAxISNo3eGe7sXNa66x7S6BKYit9uNjtTQE",
      "CG8Exa1AAAgAAS-UnPEWxT_yHLNs_2IYVpJwcdm1wQLlEF99Pu_",
      "ClARKM7eAAgAAQgWWJJtsAYDuY5CVWi9ibuZeOMqHzWZBedrtZT",
      "DCcGF8cSAAgAAQb4RZko-mE6EsBtRrCS4qawDc4Nf9YShXzogiG",
      "G7r4dRkYAAgAAREwvmZvI-FXFBxKpEaFTDQfbCIaK8qp2NVYM1b",
      "HiXaAldyAAgAAS6bVaEFohXAb_jJmP0zhUewaUFeIeERd3N5Krg",
      "KhZNddRIAAgAARzY4EA8UHf9R0vRuwKE9Nq6Fbm8Q-RV55RRnwL",
      "LQgqBgrsAAgAARPY2i52soLNgeg46mRfLoxBptoGsl2VVGMABrL",
      "My9WHr7KAAgAASyQu5ku6ltNl7Hz3yNUHOxQxRKZLuOiVmqWGHQ",
      "NS2uRagaAAgAAQ37ddZ0IxihFxyZPXRbUggd3f6h14iMo8uH7P8",
      "Oi8FzUv-AAgAAS8gPhAFyteFxb3W3n0O2Y5P-ZGkk7egm81gA6v",
      "PsxpwxQaAAgAATsSsAkc3IuyqAcI2hM2XXWayrN-ejcD8WXYtC4",
      "PxAmpUOcAAgAARwLvIEseJ-JmIOA45HcrLJtZX3UR2jnkU-5j6n",
      "Q5g-uCnMAAgAASNziwp8ovaMcUpBUYHPKrKqZkj5pTFmOD6Nyyz",
      "RE9oJOugAAgAARRWsGEt5TDTRJbR1jpGCB6OAZp0c7AYUrZogRb",
      "TkdtqYWcAAgAARDqZ_J9QuV_CR88qMCpe7BJWL-oe05yYPejl7g",
      "UC0y4BBoAAgAATsjzkQE1CAXxwPAESvbXcmo_9ygqwpHHvvAG6P",
      "VAQ2teJwAAgAAQWq1pZHGY0PmTtsN9FvHFeynhxs9WIk9o9kTDz",
      "YEXHe2jYAAgAASu3QqB2dcVB6OKO7lsMCOSVxuTtJbHO7pnUnwA",
      "ZjpMJ0-QAAgAAQ1vAXErFv-XfzkrkuWX2lhT14nDgRcwPuc26_M",
      "_D-xqoEcAAgAAT5dxKQT7fvNuRQEG7h7HDroOF5rdCKMgJpqIcp",
      "_T8K0LzIAAgAATY4kPRXDfM9094X4_PCXFKjwdlMhONRb8ZcmEH",
      "_tyqjLHMAAgAAQBb_kA7FOsaketh7sOauAmtTxGpobm26qIW07C",
      "cRo_BhFWAAgAAT43m5AvxO9N18ZEQ_JfAlZd7N-GAkn5JaxEWAD",
      "cr31zA9GAAgAAQ-6sEA4O2pgQplW_kq7gHoGn3mkMSi2Kjz9bhx",
      "dKAAV6G2AAgAATfskVpYQA4uPPEo3PfxkUxqD5Pssjl1ZmxfSOb",
      "e91zvaNQAAgAAQvRwoQgPrahjvK8g4lKr6fkLRh1DVPdWk_cRXS",
      "eP-es5liAAgAATs3NuQ-77zfUq3mBJyD6Zg-nFMZan9InCLfxHX",
      "eaw9J4oCAAgAASQ1r8QN9Ca9TJFGUsYnYoSKZD3QpqjqYSwIaaE",
      "foyca7GqAAgAARC0mQQSh9W3xdz9zJBw98KBn00SXmSxKadEFRp",
      "gcYfQvCEAAgAASg4xo5OfJ6gDnYTcIEveKlN7TU3jykaFGdyM8h",
      "hJsqPPP0AAgAAQsAi8Zs0az6cc3yAZxm-sBKOu_ZzDNtZ2iSxn3",
      "jKeNbhNKAAgAAT6L7pEXhY8pISiTvn4NBfP2kSqK1O8-LvsPZvV",
      "kScrbEaUAAgAAROihYBn4DWiF1k-pin2LAi3l6QehnBgObYuzB2",
      "l_t5JKsaAAgAAQQUNwEjxYD1CLACmoCe0lgm2QFLzsFTjxmJEeL",
      "lbY0AYoKAAgAARcV18EkMEPRLdWQBYLYEe3Jymf3Qenkdnf2Kii",
      "mEluiu10AAgAAStluSQiBEH4MJwp1Opert0LX0SqQVjn5NoCzuo",
      "nGzMA6bSAAgAATsPrMQS3hO-Kp3JcxMptBxvCwil4ixZSfU0z3j",
      "n_Iho9pSAAgAATbCVJEQGFS9FZS6J2mAww1sedHSMiuALETUDBK",
      "oXbd1Qy-AAgAAQrWDHRMaygEdrZCc0fzYMBgcJ2LHTRbvD3lNij",
      "q1L8AY10AAgAASRzsQhpscmj7RrPMcQhV6ns_WulrUh0QcocJf0",
      "sQJwR3saAAgAAQ6OEbEXy9Wncv292_6kGKsvNGlgZBUspFW2y9A",
      "t6YDLucMAAgAATDezxhu5rgyxkk0gGRivjVIzxHm9g5RIp655cX",
      "uEMMe8M4AAgAAQlWmjk4hvweEQ6nKJGPSS0LpVHKV9yd4PnVgru",
      "vlIqggKWAAgAAQuco_5dCQ8CKiF7Mt0qLP9aTeTfuQYB3CM_RiA"
    ],
    "allowAdd": 0,
    "dataType": 0,
    "defaultValue": "2018-10-28 13:05:45",
    "propertyId": 145,
    "propertyName": "被爬蟲扒竊的開始時(shí)間",
    "sortCode": 1,
    "stageId": 187,
    "thickness": 378
  }
}

ps: 參數(shù)為測(cè)試使用的參數(shù)，部分是針對(duì)博文修改

現(xiàn)在有一個(gè)頭疼的事情是，boss想知道這個(gè)index下的的產(chǎn)品數(shù)量，因?yàn)閜roducts項(xiàng)是個(gè)數(shù)組，查官方聚合搜索文檔，貌似沒啥答案，只能求助萬能的Stack Overflow。

https://stackoverflow.com/questions/49250267/how-to-get-array-count-of-nested-object-in-elastic-search

抱歉我又搬磚了

那么用這種方式的queryDSL的寫法現(xiàn)在已經(jīng)換了，用上述的document舉個(gè)栗子

# kibana DEV Tools腳本
GET test_index_8088/_doc/_search
{
  "size":0,
  "aggs": {
    "productNum": {
      "sum": {
        "script": {
          "source": "params._source.products.size()"
        }
      }
    }
  }
}

對(duì)的，"inline" 換成了"source"，
這統(tǒng)計(jì)的是test_index_8088 index下的所有product數(shù)量，針對(duì)特定的要求，可以添加query環(huán)節(jié)。后面我也會(huì)看看聚合，還有script腳本查詢。有機(jī)會(huì)分享給各位。

轉(zhuǎn)載請(qǐng)注明出處：http://www.itdecent.cn/p/3bc797dcfa62
如有錯(cuò)誤，請(qǐng)務(wù)必指正。謝謝
我的博客：https://micorochio.github.io/