Will elasticsearch SQL support for cardinality aggregation (DISTINCT) in future?

Elastic Stack Elasticsearch
1

Hi all,

Will elasticsearch SQL support for cardinality aggregation (DISTINCT) in future?

2

We're open to all feature requests, it'd be great if you could raise it on https://github.com/elastic/elasticsearch/issues/new :slight_smile:

3

Hi @ranranxiaoya,
What exact functionality are you looking for regarding DISTINCT?

I'm asking because, at the moment, something like this SELECT COUNT(DISTINCT(first_name.keyword)) FROM test_emp; is already possible and it's using cardinality aggregation behind the scene.

4

This is exactly what I need. Thank you very much.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.