Sql query return is empty

[Christophe_Dumont]

I would like to make a query to retrieve the records of the 'layers' column (index name = ids)
When i run this command :
GET /_sql?format=txt
{
"query": "DESCRIBE ids"
}

it's ok
column | type | mapping
----------------+---------------+---------------
@timestamp |TIMESTAMP |datetime
@version |VARCHAR |text
@version.keyword|VARCHAR |keyword
layers |VARCHAR |text
layers.keyword |VARCHAR |keyword
message |VARCHAR |text
message.keyword |VARCHAR |keyword

but when i execute the command :
POST _sql?format=txt
{
"query": "select * from ids"
}

i'm getting an empty answer

@timestamp | @version |

POST _sql?format=txt
{
"query": "select count(*) from ids"
}

count(*)
---------------
8914

[Badger]

This has nothing to do with logstash. You should move it to the elasticsearch forum.