DISTINCT - COUNT Combination Reg.

[csdharma]

Hi,
I am using the driver for the past 6 months and working fine. Now there is a requirement which is not supported by the driver. When we try to query case like SELECT COUNT(DISTINCT(INVOICE_NUMBER)) FROM FACT_TABLE the condition fails and does not return any value. This requirement is for capturing the count of unique invoice from FACT Table as the FACT table is denormalised with both header and line level transaction records. The COUNT(DISTINCT(<COL_NAME>)) can occur more than once in query as well. Can you please help us in getting this accomplished. Thanks.

[standino]

same with #30

[csdharma]

I have seen #30. I am using elasticsearch 2.3.3 and tried using the count(distinct colname) query but no response. There is a chance that we might be using more than one aggregation as well like..
select count(distinct col1), count(distinct col2) from table.

It will be very easy for us if the driver supports. Thanks