Remove duplicate documents from a search in kibana4

Elastic Stack Kibana
1

I have an index with a lot of paper with the same value for the same field. I have one deduplication on this field.

Aggregators will come to me as counters. I would like a list of documents.

My index :

Doc 1 {domain: 'domain1.fr', name: 'name1', date: '01-01-2014'}
Doc 2 {domain: 'domain1.fr', name: 'name1', date: '01-02-2014'}
Doc 3 {domain: 'domain2.fr', name: 'name2', date: '01-03-2014'}
Doc 4 {domain: 'domain2.fr', name: 'name2', date: '01-04-2014'}
Doc 5 {domain: 'domain3.fr', name: 'name3', date: '01-05-2014'}
Doc 6 {domain: 'domain3.fr', name: 'name3', date: '01-06-2014'}
I want this result (deduplication result by domain field) :

Doc 6 {domain: 'domain3.fr', name: 'name3', date: '01-06-2014'}
Doc 4 {domain: 'domain2.fr', name: 'name2', date: '01-04-2014'}
Doc 2 {domain: 'domain1.fr', name: 'name1', date: '01-02-2014'}

i search use this:

/POST http://localhost:9200/test/dedup/_search?search_type=count&pretty=true
{
 "aggs":{
"dedup" : {
  "terms":{
    "field": "name"
   },
   "aggs":{
     "dedup_docs":{
       "top_hits":{
         "size":1
       }
     }
   }    
  }
 }
}

how can i show in kibana 4?

1 Like
2

Kibana does not yet support the top hits aggregation, but please feel free to +1 this issue: https://github.com/elastic/kibana/issues/3546