Elasticsearch-SQL,
Elasticsearch-SQL
Elasticsearch-SQL fork from https://github.com/NLPchina/elasticsearch-sql visit interactive web to feel.features
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
functions support
- floor
- split
- trim
- log
- log10
- substring
- round
- sqrt
- concat_ws
- +
- -
- *
- /
- %
Example
check Example file:org.nlpcn.es4sql.Test
SQLs:SELECT newtype as nt from twitter2
SELECT sum(num) as num2,newtype as nt
from twitter2
group by nt order by num2
SELECT sum(num_d) as num2,split(newtype,',') as nt
from twitter2
group by nt
order by num2
SELECT sum(num_d) as num2,floor(num) as nt
from twitter2
group by floor(num),newtype
order by num2
SELECT split('newtype','b')[1] as nt,sum(num_d) as num2
from twitter2
group by nt
SELECT split(substring('newtype',0,3),'c')[0] as nt,num_d
from twitter2
group by nt
SELECT trim(newtype) as nt
from twitter2
SELECT floor(floor(substring(time,0,14)/100)/5)*5 as nt,
count(distinct(mid)) as cvalue
FROM twitter2
where ty='buffer' and day='20160815' and domain='baidu.com'
group by nt
order by cvalue
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。