count(distinct xxx) not support

[airclear]

select distinct host.name from metricbeat where `@timestamp` > '2020-04-29T06:12:34.352Z'  

return 7 rows:

{
"schema": [
{
"name": "host.name",
"type": "keyword"
}
],
"total": 7,
"datarows": [
[
"xxxxx"
]
,
[
"xxxxx"
]
,
[
"xxxxx"
]
,
[
"xxxxx"
]
,
[
"xxxxx"
]
,
[
"xxxxx"
]
,
[
"xxxxx"
]
],
"size": 7,
"status": 200
}

select count( distinct host.name ) as hostcount from metricbeat where `@timestamp` > '2020-04-29T06:12:34.352Z'  

return 0

[aetter]

Hi @airclear, this might be a bug with SQL rather than a problem with the documentation. I've opened a new issue over in the SQL repository.