GROUP BY SQL returns no data

Elastic Stack Elasticsearch
1

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.

2

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"
3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.