ElasticsearchでSQLを使う

$HOME/curl -XPOST "http://localhost:9200/_xpack/sql" -d'
 {"query": "DESCRIBE movies"}'

===============================================
{"columns":[{"name":"column","type":"keyword"},{"name":"type","type":"keyword"},{"name":"mapping","type":"keyword"}],"rows":[["genre","VARCHAR","text"],["genre.keyword","VARCHAR","keyword"],["id","VARCHAR","text"],["id.keyword","VARCHAR","keyword"],["title","VARCHAR","text"],["title.keyword","VARCHAR","keyword"],["year","BIGINT","long"]]} 

root@els01:~# $HOME/curl -XPOST "http://localhost:9200/_xpack/sql?format=txt" -d'
>  {"query": "DESCRIBE movies"}'
    column     |     type      |    mapping
---------------+---------------+---------------
genre          |VARCHAR        |text
genre.keyword  |VARCHAR        |keyword
id             |VARCHAR        |text
id.keyword     |VARCHAR        |keyword
title          |VARCHAR        |text
title.keyword  |VARCHAR        |keyword
year           |BIGINT         |long

root@els01:~# $HOME/curl -XPOST "http://localhost:9200/_xpack/sql?format=txt" -d'
> {"query": "select title from movies LIMIT 10"}'
           title
---------------------------
Toy Story
Jumanji
Grumpier Old Men
Waiting to Exhale
Father of the Bride Part II
Heat
Sabrina
Tom and Huck
Sudden Death
GoldenEye