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


(Ranranxiaoya) #1

Hi all,

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


(Mark Walkom) #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:


(Andrei Stefan) #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.


(Ranranxiaoya) #4

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


(system) #5

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