Hello
Few word about the schema , i have one type of document (Reviews) that
contain list of reviews (nested object) each review has folowing fields :
polarity(negative or opposite ), keyword(main word of the review) , *reviewer
*.
my goal is to find top negative and positive keyword, and for each keyword
find the count of its opposite(if the keyword was on top positive ,i need
to find negative count for the keyword)
for example (based on data presented below)
top negative
iphone - 2
opposite count (positive) - 2
samsung - 1
opposite count(positive) - 0
top positive
iphone - 2
opposite count (negative) - 2
Thank you in advance for you time.
The schema :
curl -XPOST "http://localhost:9200/forum_poc" -d '
{
"settings": {
"number_of_shards": 9,
"number_of_replicas": 1
},
"mappings": {
"default": {
"_all": {
"enabled": false
},
"_source": {
"enabled": true
},
"dynamic": "false"
},
"ReviewEvent": {
"_source": {
"enabled": true
},
"properties": {
"Reviews": {
"type": "nested",
"include_in_parent": true,
"properties": {
"polarity": {
"type": "string",
"index": "not_analyzed",
"store": "true"
},
"reviewer": {
"type": "string",
"index": "not_analyzed",
"store": "true"
},
"keyword": {
"type": "string",
"index": "not_analyzed",
"store": "true"
}
}
}
}
}
}
}'
}
The Data :
curl -XPOST "http://localhost:9200/forum_poc" -d '
{"index":{"_index":"forum_poc","_type":"ReviewEvent","_id":0}}
{"Reviews":[{"polarity":"negative","reviewer":"jhon","keyword":"iphone"},{"polarity":"negative","reviewer":"kevin","keyword":"samsung"}]}
{"index":{"_index":"forum_poc","_type":"ReviewEvent","_id":1}}
{"Reviews":[{"polarity":"positive","reviewer":"Doron","keyword":"iphone"}]}
{"index":{"_index":"forum_poc","_type":"ReviewEvent","_id":2}}
{"Reviews":[{"polarity":"negative","reviewer":"Michel","keyword":"iphone"}]}
{"index":{"_index":"forum_poc","_type":"ReviewEvent","_id":4}}
{"Reviews":[{"polarity":"positive","reviewer":"Afi","keyword":"iphone"}]}
'
My query:
POST forum_poc/_search?search_type=count
{
"aggs": {
"aggregation": {
"nested": {
"path": "Reviews"
},
"aggs": {
"polarity": {
"terms": {
"field": "polarity",
"size": 10
},
"aggs": {
"keyword": {
"terms": {
"field": "keyword",
"size": 10
}
}
}
}
}
}
}
}
i need the opposite count for each keyword.
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 9,
"successful": 9,
"failed": 0
},
"hits": {
"total": 4,
"max_score": 0,
"hits": []
},
"aggregations": {
"aggregation": {
"doc_count": 5,
"polarity": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "negative",
"doc_count": 3,
"keyword": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "iphone",
"doc_count": 2
},
{
"key": "samsung",
"doc_count": 1
}
]
}
},
{
"key": "positive",
"doc_count": 2,
"keyword": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "iphone",
"doc_count": 2
}
]
}
}
]
}
}
}
--
This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this on behalf of the
addressee you must not use, copy, disclose or take action based on this
message or any information herein.
If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Thank you.
--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8b770e85-8003-4e2d-b084-9ffb688e45d6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.