Code Monkey home page Code Monkey logo

elastichd's Introduction

近期准备对ElasticHD进行重构, 大家可以把自己的需求提issue~。

技术栈主要用: Vue + TypeScript + golang

欢迎大家提出自己的issue。

日期(2020年3月8日 ~ 2020年4月1)收集需求。

还有如果大家需要有导入导出 MicroSoft Office Word的需求可以一起找我。

github账号: farmerx

ElasticHD

Build Status Go Documentation Go Report Card license Release GitHub issues

ElasticHD is a ElasticSearch visual management tool. It does not require any software. It works in your web browser, allowing you to manage and monitor your ElasticSearch clusters from anywhere at any time. Built on responsive CSS design, ElasticHD adjusts itself to any screen size on any device.The following functions are supported:

  • ES Real time data search and query
  • ES Dashboard data visualization
  • ES Indices Management
  • Managing Type Mappings
  • SQL Converts to Elasticsearch DSL
  • Device Friendly

ElasticHD Application Pages

image image image image image image image

Authentication

ElasticSearch server that supports privileged authentication, URL format:http://user:password@host:port

Installation

Precompiled binaries for supported operating systems are available.

Basic Usage

  • Linux and MacOS use ElasticHD
Step1: Download the corresponding elasticHD version,unzip xxx_elasticHd_xxx.zip
Step2: chmod 0777 ElasticHD
Step3: exec elastichd ./ElasticHD -p 127.0.0.1:9800 
  • windows
Step1: Download the corresponding elasticHD version,Double click zip package to unzip
Step2: exec elastichd ./ElasticHD -p 127.0.0.1:9800 

Standalone Executable

ElasticHD does not require any software. It works in your web browser, allowing you to manage and monitor your ElasticSearch clusters from anywhere at any time. Built on responsive CSS design, ElasticHD adjusts itself to any screen size on any device.

Es version support

Compatible with all ES versions

Contributing

Contributions 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 Usage

SQL Features Support:

  • SQL Select
  • SQL Where
  • SQL Order BySQL
  • SQL Group By
  • SQL AND & OR
  • SQL Like & NOT Like
  • SQL COUNT distinct
  • SQL In & Not In
  • SQL Between
  • SQL avg()、count(*), count(field), min(field), max(field)

Beyond SQL Features Support:

  • ES TopHits
  • ES date_histogram
  • ES STATS
  • ES RANGE
  • ES DATE_RANGE
  • Improvement : now the query DSL is much more flat*

SQL Usage

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 HH:mm:ss")
    
  • 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
    

Source code compilation

git clone https://github.com/360EntSecGroup-Skylar/ElasticHD
cd ElasticHD
npm install
npm run build
cd ./main
statik -src=../dist
# go build
GO_ENABLED=0 GOOS=windows GOARCH=amd64  go build -o elasticHD.exe github.com/elasticHD/main

Docker Quick Start:

Image link: docker images

  • Make Docker Images docker build -t elastichd:latest .

  • Docker Usage:

docker run -p 9200:9200 -d --name elasticsearch elasticsearch
docker run -p 9800:9800 -d --link elasticsearch:demo containerize/elastichd
Open http://localhost:9800 in Browser
Connect with http://demo:9200

Todo

  • More plugins support
  • The indices list supports search, better sorting, detailed viewing, and more
  • Program logo design
  • Monitoring information collection

Licenses

This program is under the terms of the MIT License. See LICENSE for the full license text.

elastichd's People

Contributors

farmerx avatar llitfkitfk avatar xuri avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

elastichd's Issues

How to use QueryUI

I want know how to use QueryUI to search data, I try sql or es search grammar ,but without effect

Problem about indexing searching

I had to insert the following document into the ES.

PUT /megacorp/employee/1
{
    "first_name" : "John",
    "last_name" :  "Smith",
    "age" :        25,
    "about" :      "I love to go rock climbing",
    "interests": [ "sports", "music" ]
}

PUT /megacorp/employee/2
{
    "first_name" :  "Jane",
    "last_name" :   "Smith",
    "age" :         32,
    "about" :       "I like to collect rock albums",
    "interests":  [ "music" ]
}

PUT /megacorp/employee/3
{
    "first_name" :  "Douglas",
    "last_name" :   "Fir",
    "age" :         35,
    "about":        "I like to build cabinets",
    "interests":  [ "forestry" ]
}

I want to search with matching phrase in ElasticHD.

GET /megacorp/employee/_search
{
    "query" : {
        "match_phrase" : {
            "about" : "rock climbing"
        }
    }
}

I expected as:

{
   ...
   "hits": {
      "total":      1,
      "max_score":  0.23013961,
      "hits": [
         {
            ...
            "_score":         0.23013961,
            "_source": {
               "first_name":  "John",
               "last_name":   "Smith",
               "age":         25,
               "about":       "I love to go rock climbing",
               "interests": [ "sports", "music" ]
            }
         }
      ]
   }
}

But I got the following ones:

{
-"_shards": {
"failed": 0,
"successful": 5,
"total": 5
},
-"hits": {
-"hits": [
-{
"_id": "2",
"_index": "megacorp",
"_score": 1,
-"_source": {
"about": "I like to collect rock albums",
"age": 32,
"first_name": "Jane",
-"interests": [
"music"
],
"last_name": "Smith"
},
"_type": "employee"
},
-{
"_id": "1",
"_index": "megacorp",
"_score": 1,
-"_source": {
"about": "I love to go rock climbing",
"age": 25,
"first_name": "John",
-"interests": [
"sports",
"music"
],
"last_name": "Smith"
},
"_type": "employee"
},
-{
"_id": "3",
"_index": "megacorp",
"_score": 1,
-"_source": {
"about": "I like to build cabinets",
"age": 35,
"first_name": "Douglas",
-"interests": [
"forestry"
],
"last_name": "Fir"
},
"_type": "employee"
}
],
"max_score": 1,
"total": 3
},
"timed_out": false,
"took": 47
}

Can you please help me find what 's going on here?

qin

请问1.4版本为什么queryui的查询功能用不了,js报错了

can't .vue file

These relative modules were not found:

  • ./monitor in .//babel-loader/lib!.//vue-loader/lib/selector.js?type=script&index=0!./src/components/Home.vue
  • ./queryui in .//babel-loader/lib!.//vue-loader/lib/selector.js?type=script&index=0!./src/components/Home.vue

错误的json请求也有返回值

随便填写一个错误的json,发起请求,有正常的返回值。
错误的json如:{"query":{"match2_all":{}}}
返回值同{"query":{"match_all":{}}}一致。

期望能原样返回es给出的错误,如:{"error":{"root_cause":[{"type":"parsing_exception","reason":"no [query] registered for [match2_all]","line":4,"col":23}],"type":"parsing_exception","reason":"no [query] registered for [match2_all]","line":4,"col":23},"status":400}

怎么运行啊

下载了elasticHD_linux_amd64.zip 这个包,但是不知道怎么运行

无法使用

按照README.md安装了,搜索一点不起作用,输入什么查询语句都是相同的结果,QUERYUI也无法使用,我看控制台一直报错,不知道是我打开的方式不对吗?????

现在下载怎么都是源码包了

您好,刚找遍了您的项目wiki,在Releases下载的1.4也是源码包,不能直接解压、授权、运行;麻烦楼主看下 是我下载的有问题,还是现开放的下载包有问题;
或者直接给个下载地址;谢拉!

权限管理

不支持ldap,还有只读权限的管理?

sql convert to dsl的包可否独立出来

我的es查询客户端也是用的go,目前是一个es的golang客户端的library,他不是封装成sql转换的,我觉的你这样的sql转换更省事,不知道这个转换可否在github上单独开个项目,通过go get安装

怎么支持apache reverse proxy?

尝试将应用部署在内网然后通过apache reverse proxy 向外曝露。Reverse proxy配置如下:

    ProxyRequests Off
    # elastichd 
    ProxyPass /elastichd/ http://elastichd:9800/
    <Location /elastichd/>
        ProxyPassReverse /
        ProxyHTMLEnable On
        ProxyHTMLURLMap / /elastichd/
        #
        AddOutputFilter Sed css
        OutputSed "s/\/static\//\/elastichd\/static\//g"
    </Location>

访问 localhost/elastichd/ 显示空白页。

请问该如何调整?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.