es使用sql语言进行查询，再也不需要dsl语言了

es使用sql语言进行查询

在kibana中我们完全可以使用sql进行查询数据

POST /_sql?format=txt
{
 "query": "SELECT avg(valueMicros) as valueMicros , ip,country FROM adsipvalue group by  ip,country order by valueMicros asc limit 1000"
}

sql转dsl

 POST /_sql/translate
{
"query": "SELECT avg(valueMicros) as valueMicros , ip,country FROM ads_ip_value group by  ip,country order by valueMicros desc limit 1000"
}