ElasticHD ElasticSearch的可视化应用 项目简介
ElasticHD 是一款 ElasticSearch的可视化应用。不依赖ES的插件安装，更便捷；导航栏直接填写对应的ES IP和端口就可以操作Es了。目前支持如下功能：ES Real time data searchES Dashboard data visualizationES Index Template (在线修改、查看、上传）ES Indices Index deletion and searchSQL Converts to Elasticsearch DSLES 基本查询文档InstallationPrecompiled binaries for supported operating systems are available.Basic Usagelinux and MacOs use ElasticHD下载对应的elasticHD版本，unzip xxx_elasticHd_xxx.zip
修改权限 chmod 0777 ElasticHD
可指定ip端口运行elastichd ./ElasticHD -p 127.0.0.1:9800 默认 ip和端口也是这个windows直接下载对应windows版本,解压，双击运行。当然想指定端口的话同linuxEs version support测试过elasticsearch 1.5版本到5.2.1的版本都能正常使用。 关于 sql 转化成 dsl 马上会出elasticHD 1.1版本修复一些兼容性错误。ContributingContributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change.ElasticHD SQL Converts to ElasticSearch DSL UsageSQL Features Support:[x] SQL Select[x] SQL Where[x] SQL Order BySQL[x] SQL Group By[x] SQL AND & OR[x] SQL Like & NOT Like[x] SQL COUNT distinct[x] SQL In & Not In[x] SQL Between[x] SQL avg()、count(*), count(field), min(field), max(field)Beyond SQL Features Support：[x] ES TopHits[x] ES date_histogram[x] ES STATS[x] ES RANGE[x] ES DATE_RANGEImprovement : now the query DSL is much more flatSQL UsageQueryselect * from test where a=1 and b="c" and create_time between '2015-01-01T00:00:00+0800' and '2016-01-01T00:00:00+0800' and process_id > 1 order by id desc limit 100,10Aggregationselect avg(age),min(age),max(age),count(student),count(distinct student) from test group by grade,class limit 10Beyond SQLrange age group 20-25,25-30,30-35,35-40 SELECT COUNT(age) FROM bank GROUP BY range(age, 20,25,30,35,40)range date group by your config SELECT online FROM online GROUP BY date_range(field="insert_time",format="yyyy-MM-dd" ,"2014-08-18","2014-08-17","now-8d","now-7d","now-6d","now")range date group by day select * from test group by date_histogram(field="changeTime",interval="1h",format="yyyy-MM-dd HH
修改权限 chmod 0777 ElasticHD
可指定ip端口运行elastichd ./ElasticHD -p 127.0.0.1:9800 默认 ip和端口也是这个windows直接下载对应windows版本,解压，双击运行。当然想指定端口的话同linuxEs version support测试过elasticsearch 1.5版本到5.2.1的版本都能正常使用。 关于 sql 转化成 dsl 马上会出elasticHD 1.1版本修复一些兼容性错误。ContributingContributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change.ElasticHD SQL Converts to ElasticSearch DSL UsageSQL Features Support:[x] SQL Select[x] SQL Where[x] SQL Order BySQL[x] SQL Group By[x] SQL AND & OR[x] SQL Like & NOT Like[x] SQL COUNT distinct[x] SQL In & Not In[x] SQL Between[x] SQL avg()、count(*), count(field), min(field), max(field)Beyond SQL Features Support：[x] ES TopHits[x] ES date_histogram[x] ES STATS[x] ES RANGE[x] ES DATE_RANGEImprovement : now the query DSL is much more flatSQL UsageQueryselect * from test where a=1 and b="c" and create_time between '2015-01-01T00:00:00+0800' and '2016-01-01T00:00:00+0800' and process_id > 1 order by id desc limit 100,10Aggregationselect avg(age),min(age),max(age),count(student),count(distinct student) from test group by grade,class limit 10Beyond SQLrange age group 20-25,25-30,30-35,35-40 SELECT COUNT(age) FROM bank GROUP BY range(age, 20,25,30,35,40)range date group by your config SELECT online FROM online GROUP BY date_range(field="insert_time",format="yyyy-MM-dd" ,"2014-08-18","2014-08-17","now-8d","now-7d","now-6d","now")range date group by day select * from test group by date_histogram(field="changeTime",interval="1h",format="yyyy-MM-dd HH