elasticsearch 技术栈（ElasticSearch的可视化应用ElasticHD）
elasticsearch 技术栈（ElasticSearch的可视化应用ElasticHD）select avg(age) min(age) max(age) count(student) count(distinct student) from test group by grade class limit 10 Beyond SQLselect * 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 10 Aggregation下载对应的elasticHD版本，unzip xxx_elasticHd_xxx.zip 修改权限 chmod 0777 ElasticHD 可指定ip端口运行elastichd ./E
ElasticHD 是一款 ElasticSearch的可视化应用。不依赖ES的插件安装，更便捷；导航栏直接填写对应的ES IP和端口就可以操作Es了。目前支持如下功能：
- ES Real time data search
- ES Dashboard data visualization
- ES Index Template (在线修改、查看、上传）
- ES Indices Index deletion and search
- sql Converts to Elasticsearch DSL
- ES 基本查询文档
Installation
Precompiled binaries for supported operating systems are available.
Basic Usage
- linux 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版本 解压，双击运行。当然想指定端口的话同linux
Es version support
测试过elasticsearch 1.5版本到5.2.1的版本都能正常使用。 关于 sql 转化成 dsl 马上会出elasticHD 1.1版本修复一些兼容性错误。
Query
select * 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 10
Aggregation
select avg(age) min(age) max(age) count(student) count(distinct student) from test group by grade class limit 10
Beyond SQL
- range 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 HHss")
- stats
SELECT online FROM online group by stats(field="grade")
- topHits
select top_hits(field="class" hitssort="age:desc" taglimit = "10" hitslimit = "1" _source="name age class gender") from school
源码编译
# 需要go环境 git Clone https://github.com/farmerx/ElasticHD # 进入到应用目录下 cd ElasticHD npm install # build vue 源码 npm run build # 进入到服务端程序目录 cd ./main # 使用statik 压缩编译好的程序(github上的一款go应用) statik -src=../dist # go build GO_ENABLED=0 GOOS=windows GOARCH=amd64 go build -o elasticHD.exe github.com/elasticHD/main
ElasticHD应用页面
