GROUP BY SQL returns no data

Hey ALL,

I am running simple SQL in the Kibana SQL workspace and getting no data back. Appreciate for any clues!

select status, count(*) as status_cnt from my-index4 group by status

Thanks,
Dimon.

Have you tried to run the query using the SQL REST api?

Can you try to put the index name in double quotes:

select status, count(*) as status_cnt from "my-index4" group by status

(keep in mind in REST API - json - you need to escape the double quotes with \:

"query" : "select status, count(*) as status_cnt from \"my-index4\" group by status"