复杂组合查询 - drjsite/elasticsearch-sql GitHub Wiki

1. bool 查询

select * from apple where (provider='苹果' and minPrice>=5000) or productCode=404

2. range

select * from apple where minPrice range in (1,3];
select * from apple where minPrice >1 or minPrice <=3;