Elasticsearch sql query does not work when index name contains "-"

SQL treats - as a minus operation, which doesn't makes sense in this particular context. So, in order to use the index as is, you can simply put it in quotes:

DESCRIBE "filebeat-6.5.0-2019.01.04"