Elasticsearch filter via number of mentions

Question

I am trying to write a query which will return me articles about certain keywords but I want the articles to only show if the the given keyword is mentions 5 times in the articles I am using following query But no result

  {
   "query":{

      "multi_match":{
         "query":"Apple",
         "operator":"AND",
         "fields":[
            "Text"
         ]

      }
      ,"min_term_freq" : 5
   },
   "sort":{
      "Date":{
         "order":"desc"
      }
   }
}

score 1 · Answer 1 · answered Feb 04 '15 at 02:33

1

I dont believe there is any min_term_freq option as you have listed. But then you can use scripting in filter to achieve the same -

{
  "query": {
    "filtered": {
      "filter": {
        "script": {
          "script": "_index['Text']['apple'].tf() > 5"
        }
      }
    }
  }
}

answered Feb 04 '15 at 02:33

Vineeth Mohan

18,633
8
63
77

Your query is working fine but if I change the word from apple to any other it doesn't work. – Ironman Feb 04 '15 at 13:47
It should be an exisitng term ... What other term did you try > – Vineeth Mohan Feb 04 '15 at 14:23
I think i got the problem this query is not accepting two words like, tim took. So how do I solve that? – Ironman Feb 04 '15 at 16:43
This only accepts tokenized terms like tim or took , and not "tim took" – Vineeth Mohan Feb 04 '15 at 18:38
Write an AND condition _index['Text']['time'].tf() > 5 && _index['Text']['took'].tf() > 5 – Vineeth Mohan Feb 04 '15 at 18:46
The query is working fine now but it is not sorting data as per time – Ironman Feb 05 '15 at 00:53

Elasticsearch filter via number of mentions

1 Answers1

Linked