先展示數(shù)據(jù)結(jié)構(gòu)如下:

成都創(chuàng)新互聯(lián)是一家專注于成都網(wǎng)站設(shè)計、做網(wǎng)站與策劃設(shè)計,海南網(wǎng)站建設(shè)哪家好?成都創(chuàng)新互聯(lián)做網(wǎng)站,專注于網(wǎng)站建設(shè)10年,網(wǎng)設(shè)計領(lǐng)域的專業(yè)建站公司;建站業(yè)務涵蓋:海南等地區(qū)。海南做網(wǎng)站價格咨詢: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" } }
                        		}
                        	}
                        }
        }
	}
}

另外有需要云服務器可以了解下創(chuàng)新互聯(lián)scvps.cn，海內(nèi)外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。

當前名稱：elasticsearch嵌套查詢聚合數(shù)據(jù)-創(chuàng)新互聯(lián)
網(wǎng)頁路徑：http://weahome.cn/article/dhhdss.html