Hey guys, I have this mappings:
{
"ckdocuments": {
"mappings": {
"msv": {
"properties": {
"MSV": {
"type": "nested",
"properties": {
"country": {
"type": "string",
"index": "not_analyzed"
},
"date": {
"type": "date",
"format": "YYYY-MM-dd HH:mm:ss"
},
"hits": {
"type": "nested",
"properties": {
"click_type": {
"type": "string",
"index": "not_analyzed"
}
}
}
}
},
"c": {
"type": "string"
},
"doc_creation_time": {
"type": "date",
"format": "YYYY-MM-dd HH:mm:ss"
},
"views": {
"properties": {
"country": {
"type": "string"
},
"date": {
"type": "date",
"format": "YYYY-MM-dd HH:mm:ss"
},
"hits": {
"properties": {
"click_type": {
"type": "string"
}
}
}
}
}
}
}
}
}
}
with this documents:
GET ckdocuments/msv/1
"_source": {
"MSV": [
{
"country": "US",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
],
"views": [
{
"country": "US",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
},
{
"country": "IL",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
]
}
GET ckdocuments/msv/2
"_source": {
"doc_creation_time": "2013-01-01 00:00:00",
"MSV": [
{
"country": "IL",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "pixel"
}
]
},
{
"country": "US",
"date": "2013-01-02 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
],
"views": [
{
"country": "US",
"date": "2013-01-01 00:00:00",
"hits": []
},
{
"country": "US",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "pixel"
},
{
"click_type": "pixel"
}
]
},
{
"country": "US",
"date": "2013-01-02 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
]
}
GET ckdocuments/msv/3
"_source": {
"MSV": [
{
"country": "IL",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
],
"views": [
{
"country": "US",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
},
{
"country": "IL",
"date": "2013-01-01 00:00:00",
"hits": [
{
"click_type": "click"
}
]
}
]
}
I am trying to make an aggregation query by "MSV.country" with filtering
that the results will be only the MSVs that have "MSV.hits.click_type =
click" AND "MSV.date" is in the range 2013-01-01 2013-01-02 // format
yyyy-mm-dd
this is the query i am trying to run:
GET ckdocuments/msv/_search
{
"aggregations": {
"MSV1":{
"filter":{
"nested": {
"path": "MSV",
"query": {
"bool": {
"must": [
{
"nested": {
"path": "MSV.hits",
"query": {
"term": {
"MSV.hits.click_type": "click"
}
}
}
},
{
"range": {
"MSV.date": {
"from":"2013-01-01 00:00:00",
"to": "2013-01-01 00:00:00"
}
}
}]
}
}
}
},
"aggregations":{
"country":{
"terms":{
"field": "MSV.country"
}
}
}
}
},
"size":0
}
and this is the results:
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 3,
"max_score": 0,
"hits": []
},
"aggregations": {
"MSV1": {
"doc_count": 2,
"country": {
"buckets": []
}
}
}
}
I dont understand why i don't see 1 IL results and 1 US results (as marked
in green).
Thnx for you attention :D
Niv
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/41795a50-5239-4aa8-8a85-9928561ca7fd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
