准备升级ES-2.x到 ElasticSearch-5.4.1版本,已经运行起来,并且把elasticsearch-sql-5.4.1.0已经安装成功。
怎么想2.X版本一样,访问:localhost:9200/_plugin/sql/ 进入页面,然后输入SQL语句进行查询?
在https://github.com/NLPchina/elasticsearch-sql elasticsearch-sql中关于版本2.x和5.x的差别
On elasticsearch 1.x / 2.x, visit the elasticsearch-sql web front-end:http://localhost:9200/_plugin/sql/
On elasticsearch 5.x, download and extract site.
Then start the web front-end like this:
cd site-server
npm install express --save
node node-server.js
Simple query:
http://localhost:9200/_sql?sql=select * from indexName limit 10
Explain SQL to elasticsearch query DSL:
http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10
通过这两个请求可以查询到数据,但怎么像2.x版本一样查询? 求助?????
怎么想2.X版本一样,访问:localhost:9200/_plugin/sql/ 进入页面,然后输入SQL语句进行查询?
在https://github.com/NLPchina/elasticsearch-sql elasticsearch-sql中关于版本2.x和5.x的差别
On elasticsearch 1.x / 2.x, visit the elasticsearch-sql web front-end:http://localhost:9200/_plugin/sql/
On elasticsearch 5.x, download and extract site.
Then start the web front-end like this:
cd site-server
npm install express --save
node node-server.js
Simple query:
http://localhost:9200/_sql?sql=select * from indexName limit 10
Explain SQL to elasticsearch query DSL:
http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10
通过这两个请求可以查询到数据,但怎么像2.x版本一样查询? 求助?????
2 个回复
laoyang360 - 《一本书讲透Elasticsearch》作者,Elastic认证工程师 [死磕Elasitcsearch]知识星球地址:http://t.cn/RmwM3N9;微信公众号:铭毅天下; 博客:https://elastic.blog.csdn.net
赞同来自:
wengqiankun - es新手
赞同来自:
5.x不提供site服务了。需要自己把插件放容器了运行