Elasticsearch插件：elasticsearch-sql安装和使用

最新推荐文章于 2024-07-09 20:12:07 发布
最新推荐文章于 2024-07-09 20:12:07 发布
阅读量2.3w 收藏 16
点赞数 3
分类专栏： Elasticsearch：入门与深入 文章标签： Elasticsearch 插件 elasticsearch-sql

使用此插件，您可以使用熟悉的SQL语法查询elasticsearch。您还可以在SQL中使用ES函数。

有两种方法可以使用此插件：

  1. 使用其余的api 
http://localhost:9200/_sql?sql=select * from indexName limit 10

2. 或者通过浏览器访问 http://localhost:9200/_plugin/sql 


Web前端概述

 

安装

安装为插件：版本（sql插件与Elasticsearch的版本对应关系）

elasticsearch versionlatest versionremarksbranch
1.x1.7.6tested against elastic 1.7.6elastic1.x
2.0.02.0.4delete commands not supportedelastic2.0
2.1.02.1.0.2delete commands not supportedelastic2.1
2.1.12.1.1.1delete commands not supportedelastic2.1.1
2.1.22.1.2.0delete commands not supportedelastic2.1.2
2.2.02.2.0.1delete commands not supportedelastic2.2.0
2.2.12.2.1.0delete commands not supportedelastic2.2.1
2.3.02.3.0.0delete commands not supportedelastic2.3.0
2.3.12.3.1.1delete commands not supportedelastic2.3.1
2.3.22.3.2.0delete commands not supportedelastic2.3.2
2.3.32.3.3.0delete commands not supportedelastic2.3.3
2.3.42.3.4.0delete commands not supportedelastic2.3.4
2.3.52.3.5.0delete commands not supportedelastic2.3.5
2.4.02.4.0.1delete commands not supportedelastic2.4.0
2.4.12.4.1.0delete commands not supportedelastic2.4.1
2.4.22.4.2.1delete commands not supportedelastic2.4.2
2.4.32.4.3.0delete commands not supportedelastic2.4.3
2.4.42.4.4.0delete commands not supportedelastic2.4.4
2.4.52.4.5.0delete commands not supportedelastic2.4.5
2.4.62.4.6.0delete commands not supportedelastic2.4.6
5.0.15.0.1.0delete commands not supportedelastic5.0.1
5.1.15.1.1.0delete commands not supportedelastic5.1.1
5.1.25.1.2.0delete commands not supportedelastic5.1.2
5.2.05.2.0.0delete commands not supportedelastic5.2.0
5.2.15.2.1.0delete commands not supportedelastic5.2.1
5.2.25.2.2.0delete commands not supportedelastic5.2.2
5.3.05.3.0.0delete commands not supportedelastic5.3.0
5.3.15.3.1.0delete commands not supportedelastic5.3.1
5.3.25.3.2.0delete commands not supportedelastic5.3.2
5.3.35.3.3.0delete commands not supportedelastic5.3.3
5.4.05.4.0.0delete commands not supportedelastic5.4.0
5.4.15.4.1.0delete commands not supportedelastic5.4.1
5.4.25.4.2.0delete commands not supportedelastic5.4.2
5.4.35.4.3.0delete commands not supportedelastic5.4.3
5.5.05.5.0.1delete commands not supportedelastic5.5.0
5.5.15.5.1.0delete commands not supportedelastic5.5.1
5.5.25.5.2.0delete commands not supportedelastic5.5.2
5.5.35.5.3.0delete commands not supportedelastic5.5.3
5.6.05.6.0.0delete commands not supportedelastic5.6.0
5.6.15.6.1.0delete commands not supportedelastic5.6.1
5.6.25.6.2.0delete commands not supportedelastic5.6.2
5.6.35.6.3.0delete commands not supportedelastic5.6.3
5.6.45.6.4.0delete commands not supportedelastic5.6.4
5.6.55.6.5.0delete commands not supportedelastic5.6.5
5.6.65.6.6.0 elastic5.6.6
5.6.75.6.7.0 elastic5.6.7
5.6.85.6.8.0 elastic5.6.8
5.6.95.6.9.0 elastic5.6.9
5.6.105.6.10.0 elastic5.6.10
6.0.06.0.0.0 elastic6.0.0
6.0.16.0.1.0 elastic6.0.1
6.1.06.1.0.0 elastic6.1.0
6.1.16.1.1.0 elastic6.1.1
6.1.26.1.2.0 elastic6.1.2
6.1.36.1.3.0 elastic6.1.3
6.1.46.1.4.0 elastic6.1.4
6.2.06.2.0.0 elastic6.2.0
6.2.16.2.1.0 elastic6.2.1
6.2.26.2.2.0 elastic6.2.2
6.2.36.2.3.0 elastic6.2.3
6.2.46.2.4.0 elastic6.2.4
6.3.06.3.0.0 elastic6.3.0
6.3.16.3.1.0 elastic6.3.1

不同Elasticsearch版本的安装命令

Elasticsearch 1.x

./bin/plugin -u https://github.com/NLPchina/elasticsearch-sql/releases/download/1.7.6/elasticsearch-sql-1.7.6.zip --install sql

Elasticsearch 2.0.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.0.4/elasticsearch-sql-2.0.4.zip

Elasticsearch 2.1.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.0.2/elasticsearch-sql-2.1.0.2.zip

Elasticsearch 2.1.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.1.1/elasticsearch-sql-2.1.1.1.zip

Elasticsearch 2.1.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.2.0/elasticsearch-sql-2.1.2.0.zip

Elasticsearch 2.2.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.0.1/elasticsearch-sql-2.2.0.1.zip

Elasticsearch 2.2.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.1.0/elasticsearch-sql-2.2.1.0.zip

Elasticsearch 2.3.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip

Elasticsearch 2.3.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.1.1/elasticsearch-sql-2.3.1.1.zip

Elasticsearch 2.3.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.2.0/elasticsearch-sql-2.3.2.0.zip

Elasticsearch 2.3.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.3.0/elasticsearch-sql-2.3.3.0.zip

Elasticsearch 2.3.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.4.0/elasticsearch-sql-2.3.4.0.zip

Elasticsearch 2.3.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.5.0/elasticsearch-sql-2.3.5.0.zip

Elasticsearch 2.4.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.0.1/elasticsearch-sql-2.4.0.1.zip

Elasticsearch 2.4.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.1.0/elasticsearch-sql-2.4.1.0.zip

Elasticsearch 2.4.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.2.1/elasticsearch-sql-2.4.2.1.zip

Elasticsearch 2.4.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.3.0/elasticsearch-sql-2.4.3.0.zip

Elasticsearch 2.4.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.4.0/elasticsearch-sql-2.4.4.0.zip

Elasticsearch 2.4.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.5.0/elasticsearch-sql-2.4.5.0.zip

Elasticsearch 2.4.6

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.6.0/elasticsearch-sql-2.4.6.0.zip

Elasticsearch 5.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.0.1/elasticsearch-sql-5.0.1.0.zip

Elasticsearch 5.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.1.0/elasticsearch-sql-5.1.1.0.zip

Elasticsearch 5.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.2.0/elasticsearch-sql-5.1.2.0.zip

Elasticsearch 5.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.0.0/elasticsearch-sql-5.2.0.0.zip

Elasticsearch 5.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.1.0/elasticsearch-sql-5.2.1.0.zip

Elasticsearch 5.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.2.0/elasticsearch-sql-5.2.2.0.zip

Elasticsearch 5.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.0.0/elasticsearch-sql-5.3.0.0.zip

Elasticsearch 5.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.1.0/elasticsearch-sql-5.3.1.0.zip

Elasticsearch 5.3.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.2.0/elasticsearch-sql-5.3.2.0.zip

Elasticsearch 5.3.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.3.0/elasticsearch-sql-5.3.3.0.zip

Elasticsearch 5.4.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/elasticsearch-sql-5.4.0.0.zip

Elasticsearch 5.4.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/elasticsearch-sql-5.4.1.0.zip

Elasticsearch 5.4.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.2.0/elasticsearch-sql-5.4.2.0.zip

Elasticsearch 5.4.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.3.0/elasticsearch-sql-5.4.3.0.zip

Elasticsearch 5.5.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.0.0/elasticsearch-sql-5.5.0.1.zip

Elasticsearch 5.5.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.1.0/elasticsearch-sql-5.5.1.0.zip

Elasticsearch 5.5.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.2.0/elasticsearch-sql-5.5.2.0.zip

Elasticsearch 5.5.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.3.0/elasticsearch-sql-5.5.3.0.zip

Elasticsearch 5.6.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.0.0/elasticsearch-sql-5.6.0.0.zip

Elasticsearch 5.6.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.1.0/elasticsearch-sql-5.6.1.0.zip

Elasticsearch 5.6.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.2.0/elasticsearch-sql-5.6.2.0.zip

Elasticsearch 5.6.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.3.0/elasticsearch-sql-5.6.3.0.zip

Elasticsearch 5.6.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.4.0/elasticsearch-sql-5.6.4.0.zip

Elasticsearch 5.6.5

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.5.0/elasticsearch-sql-5.6.5.0.zip

Elasticsearch 5.6.6

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.6.0/elasticsearch-sql-5.6.6.0.zip

Elasticsearch 5.6.7

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.7.0/elasticsearch-sql-5.6.7.0.zip

Elasticsearch 5.6.8

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.8.0/elasticsearch-sql-5.6.8.0.zip

Elasticsearch 5.6.9

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.9.0/elasticsearch-sql-5.6.9.0.zip

Elasticsearch 5.6.10

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.10.0/elasticsearch-sql-5.6.10.0.zip

Elasticsearch 6.0.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.0.0/elasticsearch-sql-6.0.0.0.zip

Elasticsearch 6.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.1.0/elasticsearch-sql-6.0.1.0.zip

Elasticsearch 6.1.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.0.0/elasticsearch-sql-6.1.0.0.zip

Elasticsearch 6.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.1.0/elasticsearch-sql-6.1.1.0.zip

Elasticsearch 6.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.2.0/elasticsearch-sql-6.1.2.0.zip

Elasticsearch 6.1.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.3.0/elasticsearch-sql-6.1.3.0.zip

Elasticsearch 6.1.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.4.0/elasticsearch-sql-6.1.4.0.zip

Elasticsearch 6.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.0.0/elasticsearch-sql-6.2.0.0.zip

Elasticsearch 6.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.1.0/elasticsearch-sql-6.2.1.0.zip

Elasticsearch 6.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.2.0/elasticsearch-sql-6.2.2.0.zip

Elasticsearch 6.2.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip

Elasticsearch 6.2.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.4.0/elasticsearch-sql-6.2.4.0.zip

Elasticsearch 6.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.0.0/elasticsearch-sql-6.3.0.0.zip

Elasticsearch 6.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.1.0/elasticsearch-sql-6.3.1.1.zip

After doing this, you need to restart the Elasticsearch server. Otherwise you may get errors like Invalid index name [sql], must not start with '']; ","status":400}.

执行此操作后，您需要重新启动Elasticsearch服务器。否则你可能会收到错误

Invalid index name [sql], must not start with '']; ","status":400}。

重新启动Elasticsearch服务器

#停止Elasticsearch进程
kill `ps -ef | grep Elasticsearch | grep -v grep | awk '{print $2}'`
#启动Elasticsearch进程
/elasticsearch-5.4.3/bin/elasticsearch -d

基本用法

在elasticsearch 1.x / 2.x上，可以直接访问elasticsearch-sql web前端页面：

http://localhost:9200/_plugin/sql/

在elasticsearch 5.x / 6.x上,需要先下载个网站插件 download and extract site.

具体下载地址是：

https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/es-sql-site-standalone.zip

启动插件:

cd site-server
npm install express --save
node node-server.js
  • 简单的查询
http://localhost:9200/_sql?sql=select * from indexName limit 10
  • 解释SQL
http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10

SQL用法

  • 简单查询

      SELECT * FROM bank WHERE age >30 AND gender = 'm'

  • 聚合查询

      select COUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age)
  FROM bank GROUP BY gender ORDER BY SUM(age), m DESC

  • 删除

      DELETE FROM bank WHERE age >30 AND gender = 'm'

超越SQL

  • Search

      SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDER BY _score DESC LIMIT 3

  • 聚合

    • 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 day

        SELECT online FROM online GROUP BY date_histogram(field='insert_time','interval'='1d')

    • 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')

  • ES Geographic（地理位置）

      SELECT * FROM locations WHERE GEO_BOUNDING_BOX(fieldname,100.0,1.0,101,0.0)

  • Select type

      SELECT * FROM indexName/type

SQL功能

  • SQL Select
  • SQL Delete
  • SQL Where
  • SQL Order By
  • SQL Group By
  • SQL AND & OR
  • SQL Like
  • SQL COUNT distinct
  • SQL In
  • SQL Between
  • SQL Aliases
  • SQL Not Null
  • SQL(ES) Date
  • SQL avg()
  • SQL count()
  • SQL last()
  • SQL max()
  • SQL min()
  • SQL sum()
  • SQL Nulls
  • SQL isnull()
  • SQL now()
  • SQL floor
  • SQL split
  • SQL trim
  • SQL log
  • SQL log10
  • SQL substring
  • SQL round
  • SQL sqrt
  • SQL concat_ws
  • SQL union and minus

支持JDBC (处于试验阶段的功能)

Check details : JDBC Support

public void testJDBC() throws Exception {
        Properties properties = new Properties();
        properties.put("url", "jdbc:elasticsearch://127.0.0.1:9300/" + TestsConstants.TEST_INDEX);
        DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory.createDataSource(properties);
        Connection connection = dds.getConnection();
        PreparedStatement ps = connection.prepareStatement("SELECT  gender,lastname,age from  " + TestsConstants.TEST_INDEX + " where lastname='Heath'");
        ResultSet resultSet = ps.executeQuery();
        List<String> result = new ArrayList<String>();
        while (resultSet.next()) {
              System.out.println(resultSet.getString("lastname") + "," + resultSet.getInt("age") + "," + resultSet.getString("gender"))
        }
        ps.close();
        connection.close();
        dds.close();
    }

 

Beyond sql features

  • ES TopHits
  • ES MISSING
  • ES STATS
  • ES GEO_INTERSECTS
  • ES GEO_BOUNDING_BOX
  • ES GEO_DISTANCE
  • ES GEOHASH_GRID aggregation

参考来源：https://github.com/NLPchina/elasticsearch-sql

琦彦
关注
  • 3
    点赞
  • 踩
  • 16
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
elasticsearch（es-sql）的安装和使用
weixin_38411472的博客
09-13 6804
elasticsearch的搭建和插件使用 （如果搭建的是6.2.4版本的可以去这个地址去下载，有es的安装包以及es-sql、kibana、nodejs、sql-query等： https://download.csdn.net/download/weixin_38411472/10664023） 一．elasticsearch的安装文档： 1.安装java（因为es底层是Java写...
elasticsearch-sql安装使用文档.docx
03-11
Elasticsearch（简称ES）是一个强大的分布式全文搜索引擎，而Elasticsearch-SQL插件则使得我们能够通过熟悉的SQL语法来查询ES中的数据，极大地降低了使用门槛，尤其对熟悉关系型数据库的开发者而言。下面我们将详细...
Elasticsearch 安装 Elasticsearch-SQL 插件使用 SQL 操作
学亮编程手记
08-20 855
Elasticsearch 的查询语言 (DSL) 语法很复杂，查询的功能 (filter/query/match/agg/geo) 各种各样，不管是通过 restful API 还是通过 java 的 API 进行操作，都非常不方便。而 Elasticsearch-SQL 插件可以使用传统 SQL 语法查询 Elasticsearch，使用起来非常不错。Elasticsearch-SQL 项目地址：https://github.com/NLPchina/elasticsearch-sql。
Elasticsearch_sql插件安装+使用
xdg15294969271的博客
05-14 422
前提是你先安装好了elasticseach，安装过程在我有说，可以看一下。在elasticsearch容器启动的情况下，进入到elasticsearch容器，仓库，比如我的版本是8.11.2，那么我就选择对应的命令。进入到elasticsearch容器以后执行以上命令即可。执行完毕以后记得重启elasticsearch和kibana，然后看一下插件安装成功没有，查看插件是否安装成功的命令是，首先进去elasticsearch的docke容器里面，然后执行以下命令可以看到一个sql就代表安装成功了。
ES 安装 elasticsearch-sql插件
m0_66557301的博客
08-16 627
原因：elasticsearch-sql与自带的x-pack-sql模块冲突，vi /opt/elasticsearch/config/elasticsearch.yml 修改。xpack.sql.enabled: false重启ES。5、修改启动端口，然后启动server。3、下载SQL的Server。
elasticsearch和elasticsearch-sql安装教程
penn
02-25 1488
一、选定版本，参考系统当前spring boot版本，选择elasticsearch版本 二、下载并安装elasticsearch 查看服务是否成功 打开浏览器：localhost:9200 三、安装elasticsearch-sql插件 进入elasticsearch目录： ./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6..
elasticsearch SQL：在Elasticsearch中启用和使用SQL功能
热门推荐
码到三十五
07-09 1万+
。Elasticsearch SQL是Elasticsearch的扩展功能，允许用户使用SQL语法查询Elasticsearch数据。通过SQL接口，开发者可以利用熟悉的SQL语言，编写更直观、更易懂的查询，并且避免对大量复杂的原生REST请求的编写。
Elasticsearch-sql安装
bobozai86的博客
10-08 854
1、node安装 到官网下载最新版本的node，这里我下载的是v10.16.3，网址为： https://nodejs.org/dist/ 在/usr/local目录下创建node文件夹，把下载的文件拷贝到此文件夹下，并解压： 把bin目录下的node、npm命令软链接到/usr/local/bin目录下，这样可以使用相对路径执行node命令，进入bin目录： ln -s node...
elasticsearch 数据库 Elasticsearch-sql 插件的安装和启动以及JDBC访问elasticsearch
qq_40534888的博客
01-26 2213
我安装的elasticsearch版本是elasticsearch-6.2.3，6.3版本之后，elasticsearch内置集成了x-pack插件，只能使用部分功能，需要使用全部功能需要授权的，而通过SQL访问elasticsearch需要授权的部分(收费的)，但是有大神已经破解了。 插件地址 https://github.com/NLPchina/elasticsearch-sql 安装...
elasticsearch-sql-2.4.3.0.zip 插件 安装包
08-11
通常，Elasticsearch插件会安装在`$ES_HOME/plugins`目录下，其中`$ES_HOME`是Elasticsearch安装目录。 4. **离线安装**: 由于在线安装可能会因为网络问题导致失败，我们选择离线安装方式。在Elasticsearch的安装...
elasticsearch-sql-2.2.0.1.zip
03-11
SQL是针对Elasticsearch的一款社区开发插件，它的主要功能是将传统的SQL查询语句引入到Elasticsearch之中，使得用户能够通过熟悉的SQL语法来操作和查询Elasticsearch索引中的数据，极大地降低了非编程背景用户的使用...
elasticsearch-sql-7.9.2.0(maven包)
12-21
总之，"elasticsearch-sql-7.9.2.0(maven包)"是一个方便开发者将SQL查询引入Elasticsearch的强大工具，结合Maven的便捷性，可以轻松地在Java项目中集成和使用。通过熟悉Elasticsearch的基本概念和SQL插件的使用方法...
elasticsearch-sql插件(es2.2.0版本)
02-04
安装elasticsearch-sql-2.2.0.1插件的过程通常包括以下步骤： 1. **下载插件**: 描述中提到的`elasticsearch-sql-2.2.0.1`是该版本插件的压缩包文件名，首先需要将这个文件下载到本地。 2. **确保Elasticsearch...
毕设系统—智慧工地监控管理系统-可执行内含文档代码-可执行内含文档代码.zip
07-28
毕设系统—智慧工地监控管理系统-可执行内含文档代码-可执行内含文档代码.zip
一种基于关键能力的体系贡献率评估方法_李丹.caj
最新发布
07-28
一种基于关键能力的体系贡献率评估方法_李丹
化学/环境学-线性拟合/零级反应动力学拟合/一级反应动力学拟合/二级反应动力学拟合/三级反应动力学拟合软件
07-28
在进行实验的过程中，常常遇到做出一组数据却不知其效果的困扰，如做出标准曲线却不知其拟合优度。一般需用电脑的专业软件进行拟合，如Origin、MATLAB等，但存在操作步骤复杂，软件需付费等问题。基于上述情况，针对线性拟合（linear fitting）和零级反应动力学拟合（zero-order reaction kinetics fitting）、一级反应动力学拟合（first-order reaction kinetics fitting）、二级反应动力学拟合（second-order reaction kinetics fitting）、三级反应动力学拟合（third-order reaction kinetics fitting）等特殊拟合场景，开发了一个软件，其优势有： a.使用BSD许可证，即允许免费使用、修改和分发； b.支持手机（Android系统）和电脑（Windows系统）双平台使用，便于在实验现场检验实验效果； c.软件界面均采用中文。
731545397801645熊猫侠v1.1.50.apk
07-28
731545397801645熊猫侠v1.1.50.apk
如何使用 es7.1.1 elasticsearch-sql
07-28
要使用 Elasticsearch SQL 插件，您需要先确保您已经安装了 Elasticsearch 7.1.1 版本。然后，按照以下步骤进行操作： 1. 安装 Elasticsearch SQL 插件： - 打开终端或命令提示符窗口。 - 运行以下命令安装 Elasticsearch SQL 插件： ``` ./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.1.1.0/elasticsearch-sql-7.1.1.0.zip ``` - 安装完成后，重启 Elasticsearch 以使插件生效。 2. 使用 Elasticsearch SQL： - 打开终端或命令提示符窗口。 - 进入 Elasticsearch 的安装目录。 - 运行以下命令以启动 Elasticsearch SQL 查询： ``` ./bin/elasticsearch-sql-cli ``` - 您将进入 Elasticsearch SQL 的命令行界面。 - 现在，您可以开始使用 SQL 语法来查询 Elasticsearch 数据。 例如，您可以运行以下命令来执行一个简单的 SELECT 查询： ``` SELECT * FROM your_index_name WHERE your_field_name = 'your_value' ``` 注意：在上述查询中，`your_index_name` 是您要查询的索引名称，`your_field_name` 是您要查询的字段名称，`your_value` 是您要匹配的字段值。 这样，您就可以使用 Elasticsearch SQL 插件来执行 SQL 查询并检索 Elasticsearch 中的数据了。请记住，Elasticsearch SQL 插件提供了一种方便的方式来使用 SQL 语法进行查询，但它可能不适用于所有类型的查询，特别是复杂的查询。因此，在使用插件时，请确保您了解其使用限制和适用场景。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值