Elasticsearch-SQL
安装
https://github.com/NLPchina/elasticsearch-sql
一、基本用法
Visit The elasticsearch-sql web front end:
http://localhost:9200/_plugin/sql/
Simple query
http://localhost:9200/_sql?sql=select * from indexName limit 10
Explain SQLto elasticsearch query DSL
http://localhost:9200/_sql/_explain?sql=select * from indexName limit 10
二、sql的用法
--Query
SELECT * FROM bank WHERE age >30AND gender = 'm'
--Aggregation
selectCOUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age)
FROM bank GROUPBY gender ORDERBYSUM(age), m DESC
--DeleteDELETEFROM bank WHERE age >30AND gender = 'm'
三、sql以外的用法
--Search
SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDERBY _score DESC LIMIT 3
--Aggregations
--range age group20-25,25-30,30-35,35-40SELECTCOUNT(age) FROM bank GROUPBY range(age, 20,25,30,35,40)
--range dategroupbydaySELECT online FROM online GROUPBY date_histogram(field='insert_time','interval'='1d')
--range dategroupby your config
SELECT online FROM online GROUPBY 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