Elasticsearch-SQL

All features following require ES with groovy script enabled.

Distinct precision_threshold depends on ES or you can specify by second parameters.When you have lot of shards, 40000  consume too much memory. 

select,groupBy now support functions and field alias 

nested function is also available,eg.  split(substring('newtype',0,3),'c')[0]

Binary operation support now, eg.  floor(substring(newtype,0,14)/100)/5)*5

floor

split

trim

log

log10

substring

round

sqrt

concat_ws

+

-

* 

/

%

check Example file:

SQLs: