Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente | |||
|
elasticsearch:requettes:distinct [18/11/2018 18:37] thierry ↷ Page déplacée et renommée de ela_distinct à elasticsearch:requettes:distinct |
— (Version actuelle) | ||
|---|---|---|---|
| Ligne 1: | Ligne 1: | ||
| - | ====== Distinct ====== | ||
| - | source: [[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]] | ||
| - | ===== Commande ===== | ||
| - | On veux récupérer sous le nom de ''uniqDID'' les différents ''kSID'' contenus dans ''test/measures/'' | ||
| - | |||
| - | ''"size": 0'' est la pour limiter le nombre de document retournés a 0, car ce n'est pas les documents qui nous importent ici. | ||
| - | |||
| - | kSID**.keyword** est présent pour transformé le type text et keyword, car apparemment cela ne fonctionne que sur les keywords. | ||
| - | |||
| - | <code javascript> | ||
| - | GET test/measures/_search | ||
| - | { | ||
| - | "size": 0, | ||
| - | "aggs" : { | ||
| - | "uniqDID" : { | ||
| - | "terms" : { "field" : "kSID.keyword" } | ||
| - | } | ||
| - | } | ||
| - | } | ||
| - | </code> | ||
| - | |||
| - | ===== En PHP ===== | ||
| - | <code php> | ||
| - | $params = [ | ||
| - | "index" => "test", | ||
| - | "type" => "measures", | ||
| - | 'body' => | ||
| - | [ | ||
| - | "size" => 0, | ||
| - | "aggs" => [ | ||
| - | "uniqDID" => [ | ||
| - | "terms" => [ | ||
| - | "field" => "kSID.keyword" | ||
| - | ] | ||
| - | ] | ||
| - | ] | ||
| - | ] | ||
| - | ]; | ||
| - | $client = ClientBuilder::create()->build(); | ||
| - | $result = $client->search($params); | ||
| - | </code> | ||
| - | |||
| - | ===== Resultat ===== | ||
| - | <code javascript> | ||
| - | { | ||
| - | "took": 35, | ||
| - | "timed_out": false, | ||
| - | "_shards": { | ||
| - | "total": 5, | ||
| - | "successful": 5, | ||
| - | "skipped": 0, | ||
| - | "failed": 0 | ||
| - | }, | ||
| - | "hits": { | ||
| - | "total": 491426, | ||
| - | "max_score": 0, | ||
| - | "hits": [] | ||
| - | }, | ||
| - | "aggregations": { | ||
| - | "uniqDID": { | ||
| - | "doc_count_error_upper_bound": 0, | ||
| - | "sum_other_doc_count": 0, | ||
| - | "buckets": [ | ||
| - | { | ||
| - | "key": "PILL", | ||
| - | "doc_count": 486154 | ||
| - | }, | ||
| - | { | ||
| - | "key": "%YOURSID%", | ||
| - | "doc_count": 3784 | ||
| - | }, | ||
| - | { | ||
| - | "key": "toto", | ||
| - | "doc_count": 73 | ||
| - | } | ||
| - | ] | ||
| - | } | ||
| - | } | ||
| - | } | ||
| - | </code> | ||
| - | |||