使用SQL查询Elasticsearch
来源:互联网 发布:淘宝店铺动态怎么写 编辑:程序博客网 时间:2024/05/19 18:42
插件名:Elasticsearch-SQL
下载地址:https://github.com/NLPchina/elasticsearch-sql
注意:安装好后记得重启es
一些示例:
Query
SELECT * FROM bank WHERE age >30 AND gender = 'm'
Aggregation
select COUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age) FROM bank GROUP BY gender ORDER BY SUM(age), m DESC
Delete
DELETE FROM bank WHERE age >30 AND gender = 'm'
Beyond sql
Search
SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDER BY _score DESC LIMIT 3Aggregations
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
阅读全文
0 0
- 使用SQL查询Elasticsearch
- 使用SQL语法来查询Elasticsearch:Elasticsearch-SQL
- 使用SQL语法来查询Elasticsearch:Elasticsearch-SQL
- Elasticsearch-sql 用SQL查询Elasticsearch语句
- Elasticsearch 查询使用
- ElasticSearch查询的使用
- 用SQL语句查询elasticsearch
- elasticsearch sql的使用
- ElasticSearch使用SQL
- ElasticSearch使用教程四(ElasticSearch查询详解)
- ElasticSearch使用教程四(ElasticSearch查询详解)
- elasticsearch 查询及等价的sql
- Elasticsearch使用scroll进行分页查询
- ElasticSearch使用—多条件查询
- elasticsearch-查询
- Elasticsearch查询
- Elasticsearch查询
- ElasticSearch查询
- Python: PS 滤镜--波浪特效
- iOS单个应用程序的最大可用内存是多少?
- java InputStream读取不到数据
- makefile整体性的一些概念
- Hadoop Hive sql语法详解
- 使用SQL查询Elasticsearch
- mongoDB高级查询整理
- The filename xls/xxx.xls is not readable
- 论文答辩还有3天
- QT编写的程序从Windows操作系统中移植到树莓派中编译并运行
- 多态
- 【Intellij IDEA】eclipse项目导入 【转】
- tf.get_variable中变量的重复利用,reuse关键字
- 小人物也需要有梦想