select count(distinct age) bug.

[zerix]

when I use
{
"query": "select distinct customer_gender from kibana_sample_data_ecommerce"
}
It will be return the right result male/female.

but when I run :
{
"query": "select count(distinct customer_gender) from kibana_sample_data_ecommerce"
}

It will return the error result:

{
"schema": [
{
"name": "COUNT(customer_gender)",
"type": "integer"
}
],
"total": 1,
"datarows": [
[
4675
]
],
"size": 1,
"status": 200
}

I used with es 7.6.1 and SQL plugin 1.6.0.

[penghuo]

Thanks for reporting the issue.

[penghuo]

Expected Elasticsearch DSL

{
  "from" : 0,
  "size" : 0,
  "_source" : {
    "includes" : [
      "COUNT"
    ],
    "excludes" : [ ]
  },
  "aggregations" : {
    "COUNT_0" : {
      "cardinality" : {
        "field" : "customer_gender"
      }
    }
  }
}