How to select all values ​​of one field in elasticsearch?

Question

elasticsearch

Tell me how to make an analog
select distinct title from my_index

Answer 1

Terms aggregation

Answer 2

Elastic is not a database, but a search index. But in general there are so-called aggregations

Answer 3

use something like:

'aggs' => [
                    'unique_ids' => [
                        'terms' => [
                            'field' => 'CategoryID',
                        ]
                    ]
                ]