I have come here from SQL world and have fallen into Unique Count trap called
Very disappointed that
unique count here is not the same as
count distinct in SQL.
Is there any chance to get the explicit unique count in Kibana? Any approximations are not acceptable for my task.
Some explanation: I have built SQL data mart with large amount of fields i.e. have joined a lot of SQL entities to get all desired data and all labels in one SQL data mart. And have got some expected multiplication of rows due to the ID of some entity can appear in my mart in different rows. And have transferred these data into one ES index via Logstash. Then,
unique count by ClientID field in Kibana, comparison with
count (distinct ClientID) executed on SQL mart, and bad mood for at least the rest of the day as a result.