DBeaver连接Elasticsearch

我会带着你远行 2023-09-30 12:05 14阅读 0赞

一、使用SQL来查询Elasticsearch数据

二、使用免费开源项目[opendistro-for-elasticsearch][]

具体步骤：

1、下载ES对应版本的插件，本文使用的为7.6.1，具体下载地址为（如果想下载其他版本，改一下数字就可以下载）：

[https://d3g5vo6xdbdb9a.cloudfront.net/downloads/elasticsearch-plugins/opendistro-sql/opendistro\_sql-1.7.0.0.zip][https_d3g5vo6xdbdb9a.cloudfront.net_downloads_elasticsearch-plugins_opendistro-sql_opendistro_sql-1.7.0.0.zip]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16][]

具体版本对应关系可参考网址：[Standalone Elasticsearch Plugin Install - Open Distro for Elasticsearch Documentation][]

2、插件安装

elasticsearch-7.6.1/bin目录，执行./elasticsearch-plugin install file:///tmp/opendistro\_sql-1.7.0.0.zip

3、重启ES服务

4、下载JDBC的jar包

[仓库服务][Link 1]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

5、DBeaver相关配置

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 3][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 5][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 6][]

[opendistro-for-elasticsearch]: https://github.com/opendistro-for-elasticsearch
[https_d3g5vo6xdbdb9a.cloudfront.net_downloads_elasticsearch-plugins_opendistro-sql_opendistro_sql-1.7.0.0.zip]: https://d3g5vo6xdbdb9a.cloudfront.net/downloads/elasticsearch-plugins/opendistro-sql/opendistro_sql-1.7.0.0.zip
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/20210925185439703.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[Standalone Elasticsearch Plugin Install - Open Distro for Elasticsearch Documentation]: https://opendistro.github.io/for-elasticsearch-docs/docs/install/plugins/
[Link 1]: https://developer.aliyun.com/mvn/search
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/20210925190209308.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/20210925190329466.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/2021092519041839.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/2021092519044676.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 5]: https://img-blog.csdnimg.cn/20210925190725304.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5bCP5rW35q2M5ZOl_size_20_color_FFFFFF_t_70_g_se_x_16 6]: https://img-blog.csdnimg.cn/20210925190906536.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5bCP5rW35q2M5ZOl,size_20,color_FFFFFF,t_70,g_se,x_16