通过sql查询es数据

环境:
ES版本:6.5

1.查询索引
curl -H "Content-Type: application/json" -XPOST "http://192.168.1.135:19200/_xpack/sql?format=txt&pretty" -d'
{
    "query": "SELECT * FROM vacc_update where id=1",
    "fetch_size": 5
}
'

2.通过命令行模式查询
./elasticsearch-sql-cli http://elastic:elastic@192.168.1.135:19200 ##带账号密码的
./elasticsearch-sql-cli http://192.168.1.135:19200 ##不带账号密码的