This this instead:
{
"query": {
"filtered": {
"query": {
"bool": {
"should": [
{
"match": {
"NODE_HOSTNAME": "cloudserver.aricent.com"
}
},
{
"match": {
"NODE_GROUP_NAME": "MYSQL"
}
}
]
}
},
"filter": {
"bool": {
"must": [
{
"range": {
"NODE_CREATE_TIME": {
"from": "2014-03-14 16:32:35",
"to": "2014-03-14 18:43:55"
}
}
},
{
"term": {
"CLOUD_TYPE": {
"value": "cloudstack"
}
}
}
],
"must_not": {
"term": {
"NODE_ID": {
"value": "12235"
}
}
}
}
}
}
},
"sort": [
{
"NODE_ID": {
"order": "desc"
}
}
]
}
Note: Your query says to match anything that contains MYSQL or
cloudserver..... Not sure if that is your intention or not
--
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/CAPt3XKSTnF7OZGpEf0ZqJ05ZmBgOY_pCy7JjEZEk5b_%3DCR21ow%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.