elasticsearch嵌套查询聚合数据-创新互联
先展示数据结构如下:
成都创新互联是一家专注于成都网站设计、做网站与策划设计,海南网站建设哪家好?成都创新互联做网站,专注于网站建设10年,网设计领域的专业建站公司;建站业务涵盖:海南等地区。海南做网站价格咨询:18980820575{ "itemId": "132417862061", "site": "US", "sellerId": "aaaaa", "increamentId": "3753595", "ebayTrackList": [ { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2017-12-15" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2017-12-29" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-02-03" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-03-12" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-03-20" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-03-24" }, { "numCount": 0, "pageView": 2, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-04-01" }, { "numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-04-02" } ], "publisher": "2714", "title": "MOTOSPEED LED Backlight 87 keys Bluetooth Mechanical Keyboard Red Switches T1W8", "sku": [ "C5060" ], "img": "https://cache.yisu.com/upload/information/20200310/72/153898.jpg?set_id=8800005007", "price": 55.05, "status": 1, "currency": "USD", "createTime": "1512074612", "updateTime": "1522694170", "mark": null, "fromCountry": "Shen Zhen", "oldSku": null }
目前的需求是假如我要知道2018-04-02,2018-04-03号的pageView之和,很明显需要ebayTrackList.date过滤求和ebayTrackList.pageView字段
语句如下
{ "query":{ "bool" : { "must" : [ { "term" : {"itemId":"132417862061"} }, { "nested" : { "path" : "ebayTrackList", "query" : { "bool" : { "must" : [ { "terms" : {"ebayTrackList.date" : ["2018-04-03","2018-04-02"]} } ] } } } } ] } }, "aggs":{ "numTotalCount" : { "nested" : { "path" : "ebayTrackList" }, "aggs" : { "sd_value" : { "filter" : { "terms" : {"ebayTrackList.date" : ["2018-04-03","2018-04-02"]} }, "aggs" : { "sum_count" : { "sum" : { "field" : "ebayTrackList.pageView" } } } } } } } }
另外有需要云服务器可以了解下创新互联scvps.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
文章标题:elasticsearch嵌套查询聚合数据-创新互联
URL网址:http://pwwzsj.com/article/dhhdss.html