实测：NLPchina/elasticsearch-sql

最新推荐文章于 2024-04-30 08:15:00 发布
最新推荐文章于 2024-04-30 08:15:00 发布
阅读量1.5k 收藏 4
点赞数
分类专栏： Elasticsearch 7.x学习笔记
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chengyuqiang/article/details/119542432
版权

1、安装elasticsearch-sql插件

（1）安装elasticsearch-sql插件

D:\app\elasticsearch-7.12.0>bin\elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
"warning: usage of JAVA_HOME is deprecated, use ES_JAVA_HOME"
-> Installing https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
-> Downloading https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
[=================================================] 100%??
-> Installed sql
-> Please restart Elasticsearch to activate any plugins installed

D:\app\elasticsearch-7.12.0>

（2）启动elasticsearch

D:\app\elasticsearch-7.12.0>bin\elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
"warning: usage of JAVA_HOME is deprecated, use ES_JAVA_HOME"
-> Installing https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
-> Downloading https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip
[=================================================] 100%??
-> Installed sql
-> Please restart Elasticsearch to activate any plugins installed

D:\app\elasticsearch-7.12.0>bin\elasticsearch
"warning: usage of JAVA_HOME is deprecated, use ES_JAVA_HOME"
Java HotSpot(TM) 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
Unable to get Charset 'cp65001' for property 'sun.stdout.encoding', using default UTF-8 and continuing.
[2021-08-09T16:29:32,395][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] version[7.12.0], pid[12244], build[default/zip/78722783c38caa25a70982b5b042074cde5d3b3a/2021-03-18T06:17:15.410153305Z], OS[Windows 10/10.0/amd64], JVM[Oracle Corporation/Java HotSpot(TM) 64-Bit Server VM/11.0.3/11.0.3+12-LTS]
[2021-08-09T16:29:32,403][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] JVM home [C:\Program Files\Java\jdk-11.0.3], using bundled JDK [false]
[2021-08-09T16:29:32,405][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.locale.providers=SPI,COMPAT, --add-opens=java.base/java.io=ALL-UNNAMED, -XX:+UseConcMarkSweepGC, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSInitiatingOccupancyOnly, -Djava.io.tmpdir=D:\Users\chengyq\AppData\Local\Temp\elasticsearch, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=data, -XX:ErrorFile=logs/hs_err_pid%p.log, -Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m, -Xms1024m, -Xmx1024m, -XX:MaxDirectMemorySize=536870912, -Delasticsearch, -Des.path.home=D:\app\elasticsearch-7.12.0, -Des.path.conf=D:\app\elasticsearch-7.12.0\config, -Des.distribution.flavor=default, -Des.distribution.type=zip, -Des.bundled_jdk=true]
[2021-08-09T16:29:37,674][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [aggs-matrix-stats]
[2021-08-09T16:29:37,676][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [analysis-common]
[2021-08-09T16:29:37,681][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [constant-keyword]
[2021-08-09T16:29:37,682][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [flattened]
[2021-08-09T16:29:37,683][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [frozen-indices]
[2021-08-09T16:29:37,684][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [ingest-common]
[2021-08-09T16:29:37,684][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [ingest-geoip]
[2021-08-09T16:29:37,685][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [ingest-user-agent]
[2021-08-09T16:29:37,686][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [kibana]
[2021-08-09T16:29:37,687][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [lang-expression]
[2021-08-09T16:29:37,687][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [lang-mustache]
[2021-08-09T16:29:37,688][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [lang-painless]
[2021-08-09T16:29:37,689][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [mapper-extras]
[2021-08-09T16:29:37,695][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [mapper-version]
[2021-08-09T16:29:37,696][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [parent-join]
[2021-08-09T16:29:37,697][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [percolator]
[2021-08-09T16:29:37,698][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [rank-eval]
[2021-08-09T16:29:37,698][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [reindex]
[2021-08-09T16:29:37,699][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [repositories-metering-api]
[2021-08-09T16:29:37,700][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [repository-encrypted]
[2021-08-09T16:29:37,701][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [repository-url]
[2021-08-09T16:29:37,702][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [search-business-rules]
[2021-08-09T16:29:37,703][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [searchable-snapshots]
[2021-08-09T16:29:37,708][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [snapshot-repo-test-kit]
[2021-08-09T16:29:37,709][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [spatial]
[2021-08-09T16:29:37,710][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [transform]
[2021-08-09T16:29:37,712][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [transport-netty4]
[2021-08-09T16:29:37,713][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [unsigned-long]
[2021-08-09T16:29:37,713][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [vectors]
[2021-08-09T16:29:37,714][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [wildcard]
[2021-08-09T16:29:37,715][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-aggregate-metric]
[2021-08-09T16:29:37,716][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-analytics]
[2021-08-09T16:29:37,722][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-async]
[2021-08-09T16:29:37,723][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-async-search]
[2021-08-09T16:29:37,724][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-autoscaling]
[2021-08-09T16:29:37,725][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-ccr]
[2021-08-09T16:29:37,728][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-core]
[2021-08-09T16:29:37,728][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-data-streams]
[2021-08-09T16:29:37,733][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-deprecation]
[2021-08-09T16:29:37,734][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-enrich]
[2021-08-09T16:29:37,737][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-eql]
[2021-08-09T16:29:37,738][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-fleet]
[2021-08-09T16:29:37,745][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-graph]
[2021-08-09T16:29:37,748][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-identity-provider]
[2021-08-09T16:29:37,749][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-ilm]
[2021-08-09T16:29:37,749][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-ingest]
[2021-08-09T16:29:37,751][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-logstash]
[2021-08-09T16:29:37,752][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-ml]
[2021-08-09T16:29:37,754][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-monitoring]
[2021-08-09T16:29:37,754][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-ql]
[2021-08-09T16:29:37,760][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-rollup]
[2021-08-09T16:29:37,763][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-runtime-fields]
[2021-08-09T16:29:37,764][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-security]
[2021-08-09T16:29:37,765][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-sql]
[2021-08-09T16:29:37,770][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-stack]
[2021-08-09T16:29:37,776][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-text-structure]
[2021-08-09T16:29:37,776][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-voting-only-node]
[2021-08-09T16:29:37,777][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded module [x-pack-watcher]
[2021-08-09T16:29:37,778][INFO ][o.e.p.PluginsService     ] [TPA-VDI-OA11-17] loaded plugin [sql]
[2021-08-09T16:29:38,878][INFO ][o.e.e.NodeEnvironment    ] [TPA-VDI-OA11-17] using [1] data paths, mounts [[Data (D:)]], net usable_space [95.3gb], net total_space [199.9gb], types [NTFS]
[2021-08-09T16:29:38,880][INFO ][o.e.e.NodeEnvironment    ] [TPA-VDI-OA11-17] heap size [990.7mb], compressed ordinary object pointers [true]
[2021-08-09T16:29:39,001][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] node name [TPA-VDI-OA11-17], node ID [31x-7zHgTPG_kJ7DQWDGVg], cluster name [elasticsearch], roles [transform, data_frozen, master, remote_cluster_client, data, ml, data_content, data_hot, data_warm, data_cold, ingest]
[2021-08-09T16:29:46,091][INFO ][o.e.x.m.p.l.CppLogMessageHandler] [TPA-VDI-OA11-17] [controller/9336] [Main.cc@117] controller (64 bit): Version 7.12.0 (Build 778cc7261dfdd1) Copyright (c) 2021 Elasticsearch BV
[2021-08-09T16:29:46,755][INFO ][o.e.x.s.a.s.FileRolesStore] [TPA-VDI-OA11-17] parsed [0] roles from file [D:\app\elasticsearch-7.12.0\config\roles.yml]
[2021-08-09T16:29:49,321][INFO ][o.e.t.NettyAllocator     ] [TPA-VDI-OA11-17] creating NettyAllocator with the following configs: [name=unpooled, suggested_max_allocation_size=1mb, factors={es.unsafe.use_unpooled_allocator=null, g1gc_enabled=false, g1gc_region_size=0b, heap_size=990.7mb}]
[2021-08-09T16:29:49,449][INFO ][o.e.d.DiscoveryModule    ] [TPA-VDI-OA11-17] using discovery type [zen] and seed hosts providers [settings]
[2021-08-09T16:29:50,238][INFO ][o.e.g.DanglingIndicesState] [TPA-VDI-OA11-17] gateway.auto_import_dangling_indices is disabled, dangling indices will not be automatically detected or imported and must be managed manually
[2021-08-09T16:29:51,030][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] initialized
[2021-08-09T16:29:51,031][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] starting ...
[2021-08-09T16:29:51,073][INFO ][o.e.x.s.c.PersistentCache] [TPA-VDI-OA11-17] persistent cache index loaded
[2021-08-09T16:29:51,494][INFO ][o.e.t.TransportService   ] [TPA-VDI-OA11-17] publish_address {127.0.0.1:9300}, bound_addresses {127.0.0.1:9300}, {[::1]:9300}
[2021-08-09T16:29:51,964][WARN ][o.e.b.BootstrapChecks    ] [TPA-VDI-OA11-17] the default discovery settings are unsuitable for production use; at least one of [discovery.seed_hosts, discovery.seed_providers, cluster.initial_master_nodes] must be configured
[2021-08-09T16:29:51,966][INFO ][o.e.c.c.Coordinator      ] [TPA-VDI-OA11-17] cluster UUID [xP6UaBjkTeCtah8_WO5RbQ]
[2021-08-09T16:29:51,987][INFO ][o.e.c.c.ClusterBootstrapService] [TPA-VDI-OA11-17] no discovery configuration found, will perform best-effort cluster bootstrapping after [3s] unless existing master is discovered
[2021-08-09T16:29:52,189][INFO ][o.e.c.s.MasterService    ] [TPA-VDI-OA11-17] elected-as-master ([1] nodes joined)[{TPA-VDI-OA11-17}{31x-7zHgTPG_kJ7DQWDGVg}{jCe6oELgReChSpDLcSwTYQ}{127.0.0.1}{127.0.0.1:9300}{cdfhilmrstw}{ml.machine_memory=12884430848, xpack.installed=true, transform.node=true, ml.max_open_jobs=20, ml.max_jvm_size=1038876672} elect leader, _BECOME_MASTER_TASK_, _FINISH_ELECTION_], term: 2, version: 37, delta: master node changed {previous [], current [{TPA-VDI-OA11-17}{31x-7zHgTPG_kJ7DQWDGVg}{jCe6oELgReChSpDLcSwTYQ}{127.0.0.1}{127.0.0.1:9300}{cdfhilmrstw}{ml.machine_memory=12884430848, xpack.installed=true, transform.node=true, ml.max_open_jobs=20, ml.max_jvm_size=1038876672}]}
[2021-08-09T16:29:52,455][INFO ][o.e.c.s.ClusterApplierService] [TPA-VDI-OA11-17] master node changed {previous [], current [{TPA-VDI-OA11-17}{31x-7zHgTPG_kJ7DQWDGVg}{jCe6oELgReChSpDLcSwTYQ}{127.0.0.1}{127.0.0.1:9300}{cdfhilmrstw}{ml.machine_memory=12884430848, xpack.installed=true, transform.node=true, ml.max_open_jobs=20, ml.max_jvm_size=1038876672}]}, term: 2, version: 37, reason: Publication{term=2, version=37}
[2021-08-09T16:29:52,849][INFO ][o.e.h.AbstractHttpServerTransport] [TPA-VDI-OA11-17] publish_address {127.0.0.1:9200}, bound_addresses {127.0.0.1:9200}, {[::1]:9200}
[2021-08-09T16:29:52,849][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] started
[2021-08-09T16:29:53,052][INFO ][o.e.l.LicenseService     ] [TPA-VDI-OA11-17] license [267a1720-5d10-42f0-b8db-66ea642485f0] mode [basic] - valid
[2021-08-09T16:29:53,055][INFO ][o.e.x.s.s.SecurityStatusChangeListener] [TPA-VDI-OA11-17] Active license is now [BASIC]; Security is disabled
[2021-08-09T16:29:53,068][INFO ][o.e.g.GatewayService     ] [TPA-VDI-OA11-17] recovered [0] indices into cluster_state
[2021-08-09T16:57:16,122][INFO ][o.e.n.Node               ] [TPA-VDI-OA11-17] stopping ...
[2021-08-09T16:57:16,132][INFO ][o.e.x.w.WatcherService   ] [TPA-VDI-OA11-17] stopping watch service, reason [shutdown initiated]
[2021-08-09T16:57:16,139][INFO ][o.e.x.w.WatcherLifeCycleService] [TPA-VDI-OA11-17] watcher has stopped and shutdown
[2021-08-09T16:57:16,162][INFO ][o.e.x.m.p.NativeController] [TPA-VDI-OA11-17] Native controller process has stopped - no new native processes can be started

可以看到loaded plugin [sql]插件已经启动。

2、导入测试数据

POST /blog/_bulk?refresh
{ "index": { "_id": "1" }}
{ "title": "VMware安装" ,"author":"程裕强","content":"VMware Workstation虚拟机软件安装图解" , "url":"http://x.co/6nc81","postdate":"2018-12-11"}
{ "index": {"_id": "2" }}
{ "title":  "Linux安装" ,"author":  "程裕强" ,"content": "VMware模拟Linux服务器安装图解" , "url": "http://x.co/6nc82","postdate":"2018-12-12"}
{ "index": { "_id": "3" }}
{ "title":  "Xshell6安装" , "author": "程裕强" ,"content": "Xshell6个人版安装与远程操作连接服务器..." , "url": "http://x.co/6nc84" ,"postdate":"2018-12-13"}
{ "index": {"_id": "4" }}
{ "title": "CentOS 7.x基本设置" ,"author":"程裕强","content":"CentOS 7.x基本设置","url":"http://x.co/6nc85" ,"postdate":"2018-12-15"}
{ "create": {"_id": "5" }}
{ "title": "JDK安装与配置","author":"程裕强" ,"content": "图解JDK安装配置" , "url": "http://x.co/6nc86","postdate":"2018-12-15"}
{ "create": {"_id": "6" }}
{ "title": "Intellij IDEA安装","author":"程裕强" ,"content": "图解Windows平台下Intellij IDEA安装配置" , "url": "http://x.co/6nc89","postdate":"2019-01-03"}

GET blog/_search

在这里插入图片描述

3、安装谷歌浏览器的elasticsearch-sql-site-chrome插件

（1）下载插件：https://github.com/shi-yuan/elasticsearch-sql-site-chrome
在这里插入图片描述
（2）解压
在这里插入图片描述

（3）在chrome浏览器输入：chrome://extensions/
先打开开发者模式，然后出现“加载已解压的扩展程序”按钮，单击该按钮，加载刚才已解压的扩展程序
在这里插入图片描述
（4）开打插件
在这里插入图片描述
（5）执行SQL命令 （首先在右上角填写对应的ES集群地址，此处填写了本地地址：http://127.0.0.1:9200/）
在这里插入图片描述
在这里插入图片描述

程裕强
关注
  • 0
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
elasticsearch-sql:使用SQL查询Elasticsearch
05-10
重要的 从7.5.0.0开始，路径/_sql更改为/_nlpcn/sql ，路径/_sql/_explain更改为/_nlpcn/sql/explain 。 已淘汰 请注意，该项目不再处于活动开发中，已弃用，请使用AWS支持并在Apache 2下获得许可的正式版和 。 弹性搜索 建置状态 1.7.6 2.0.0 2.1.0 2.1.1 2.1.2 2.2.0 2.2.1 2.3.0 2.3.1 2.3.2 2.3.3 2.3.4 2.3.5 2.4.0 2.4.1 2.4.2 2.4.3 2.4.4 2.4.5 2.4.6 5.0.1 5.1.1 5.1.2 5.2.0 5.2.1 5.2.2 5.3.0 5.3.1 5.3.2 5.3.3 5.4.0 5.4.1 5.4.2 5.4.3 5.5.0 5.5.1 5.5.2 5.5.3 5.6.0 5.6.1 5.6.2 5.6
Elasticsearch 安装 Elasticsearch-SQL 插件使用 SQL 操作
学亮编程手记
08-20 838
Elasticsearch 的查询语言 (DSL) 语法很复杂，查询的功能 (filter/query/match/agg/geo) 各种各样，不管是通过 restful API 还是通过 java 的 API 进行操作，都非常不方便。而 Elasticsearch-SQL 插件可以使用传统 SQL 语法查询 Elasticsearch，使用起来非常不错。Elasticsearch-SQL 项目地址：https://github.com/NLPchina/elasticsearch-sql。
NLPChina、Ansj、nlp-lang
最新发布
编码时光
04-30 326
NLPChina Ansj nlp-lang
Elasticsearch-SQL 使用SQL查询Elasticsearch 安装及JDBC实现过程（附图片详解）
qq_654603797
04-18 3601
Elasticsearch的查询语言(DSL)， Elasticsearch-SQL可以用sql查询Elasticsearch。 Elasticsearch-sql的项目地址：https://github.com/NLPchina/elasticsearch-sql 1、Elasticsearch-sql实现的功能： 1)插件式的安装 2)SQL查询 3)超越SQL之外的查询 4...
ElasticSearch 安装启动及报错处理
xinu's note
08-24 549
ElasticSearch 安装启动及报错处理 下载及安装 https://www.elastic.co/cn/downloads/elasticsearch 选择合适的版本，服务器使用centos系统 wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-7.7.1-linux-x86_64.tar.gz tar -zxvf elasticsearch-7.7.1-linux-x86_64.tar.gz # 安装到/
ElasticSearch-SQL使用方式总结
yang灬仔
11-06 1819
ES-SQL插件 此插件提供了es 的类sql查询的相关接口。支持绝大多数的sql查询支持 github地址:https://github.com/NLPchina/elasticsearch-sql 环境准备 需安装elasticsearch node.js npm 下载安装 进入es根目录,执行如下命令(注意插件版本号需要同自身es版本保持一致) ./bin/e...
Elasticsearch插件：elasticsearch-sql安装和使用
web13985085406的博客
08-16 631
使用此插件，您可以使用熟悉的SQL语法查询elasticsearch。您还可以在SQL中使用ES函数。
Elasticsearch 介绍及java集成
yuechuzhixing的博客
07-18 9208
Elasticsearch 介绍及java集成
elasticsearch-sql2：基于Java Rest高级客户端的Elasticsearch-Sql组件【已淘汰】
01-28
这个版本的elasticsearch-sql是基于阿里巴巴的Druid中的SqlParser组件，由于elasticsearch许多功能并不适合使用sql表达式，导致实现elasticsearch一些高级功能的时候越来越受到SqlParser的限制，所以这个版本的...
ember-eui：https：//elastic.github.ioeui的Ember组件
02-04
灰烬 该项目旨在提供实现的css层的余烬组件 图示 为使图标正常工作，您需要： 安装ember-svg-jar 将以下ember-svg-jar选项添加到ember-cli-build.js ： 注意：我们目前正在使用来自ember-svg-jar的叉子，用于hbs...
ES 拼音分词器 https://github.com/medcl/elasticsearch-analysis-pinyin
06-08
ES中的拼音分词器： 拼音分词器是一种在中文文本中将汉字转换为对应拼音的工具。它可以将中文文本分解为拼音首字母或完整拼音，并将其作为词汇进行索引和搜索。 拼音分词器的主要作用是为了支持拼音检索或拼音搜索...
bitnami-docker-elasticsearch-exporter:用于Elasticsearch-exporter的Bitnami Docker映像
03-10
什么是Elasticsearch Exporter？ Prometheus导出器，用于有关ElasticSearch的各种指标。 TL; DR $ docker run --name elasticsearch-exporter bitnami/elasticsearch-exporter:latest 为什么要使用Bitnami Images...
elasticsearch-sql-JDBCDriver:elasticsearch-sql的JDBC Driver封装
04-28
elasticsearch-sql-JDBCDriver elasticsearch-sql的JDBC Driver封装 目前暂时只做了针对 elasticsearch 6.2.4的封装，调用了druid 1.0.16、transport 6.2.4、elasticsearch-sql 6.2.4组件。其中druid组件不要调用...
NLPchina/ansj_seg
小飞侠的博客
03-14 3720
分词方式 Jonk edited this page 26 days ago · 5 revisions  Pages 20 HOME 安装及使用 获得jar包分词方式 使用技巧 配置文件说明用户自定义词典定制你自己的CRF模型歧义纠正辞典 动作链模式 停用词过滤书名发现电子邮箱发现身份证号码发现词性
elasticsearch-sql 示例
weberhuangxingbo的博客
11-24 580
背景 elasticsearch-sql 项目是一个非常活跃的 ES SQL 插件项目，能够紧跟 ES 官方的最新版本。 目前 ES 官方稳定版本为 5.5.1, 开发版本为 6.x；elasticsearch-sql 支持从 1.7.6 到 5.5.1 的所有 ES 稳定版本。 SQL 语法 Query SELECT * FROM bank WHERE age >30 AND gender = 'm' Aggregation select COUNT(*),SUM(age),MI
Elasticsearch学习--elasticearch sql插件安装与使用
井底之蛙
04-15 7205
1、Elasticsearch sqles的查询虽然功能很强大，但是查询语言(DSL)很麻烦，不管是封装json还是通过python/java的api进行封装，都不方便。而elasticsearch-SQL可以用sql查询es，对于不熟悉es的DSL的人来说，更为简便和易读。Elasticsearch-sql支持的功能：（1）插件式的安装（2）SQL查询（3）超越SQL之外的查询（4）对JDBC方...
[ELK] “reason“=＞“no such index and [action.auto_create_index]
qq_37952113的博客
11-15 901
[ELK] "reason"=>"no such index and [action.auto_create_index]
elasticsearch-sql安装和使用
SimpleSimpleSimples的博客
03-10 773
1.elasticsearch-sql在线安装 $./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip 2.elasticsearch-sql离线安装 ./elasticse...
ES安装sql插件
zsj777的专栏
11-30 1368
GitHub - NLPchina/elasticsearch-sql: Use SQL to query Elasticsearch Since 7.5.0.0, the path/_sqlis changed to/_nlpcn/sql, and the path/_sql/_explainis changed to/_nlpcn/sql/explain. ES版本7.12.0.0 ./bin/elasticsearch-plugin install https://github...
docker-compose.yml 文件中拉取flink容器 版本为1.17.0并在flink包的lib文件夹下加入三个以下三个依赖：https://repo.maven.apache.org/maven2/org/apache/flink/flink-sql-connector-elasticsearch7/3.0.1-1.17/flink-sql-connector-elasticsearch7-3.0.1-1.17.jar、https://repo1.maven.org/maven2/com/ververica/flink-sql-connector-mysql-cdc/2.3.0/flink-sql-connector-mysql-cdc-2.3.0.jar、https://repo1.maven.org/maven2/com/ververica/flink-sql-connector-postgres-cdc/2.3.0/flink-sql-connector-postgres-cdc-2.3.0.jar
06-07
- ./lib/flink-sql-connector-elasticsearch7-3.0.1-1.17.jar:/opt/flink/lib/flink-sql-connector-elasticsearch7-3.0.1-1.17.jar - ./lib/flink-sql-connector-mysql-cdc-2.3.0.jar:/opt/flink/lib/flink-sql-...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值