我们用下面的数据测试：

可以用postman批量导入es,实现一个类似sql的查询：

select * from users 
where (name like '%张三%' or name like '%李四%') 
	and sex=1 and city_id in (1,2)
	and (address like '%广州%' or address like '%深圳%') 
	and create_time>'2020-04-04 12:30:30'
order by position desc
limit 10,2

id,tel,        name,  sex,city_id,city_name,lon,lat,             create_time,        address,
1, 13533592801,张三丰,1,  1,      深圳市,   114.364493,22.719571,2020-04-04 15:57:20,广东省深圳市龙岗区坪山站
2, 13533592802,张三花,2,  1,      深圳市,   114.062088,22.632069,2020-04-04 15:58:52,广东省深圳市龙岗区坂田站
3, 13533592803,张三,  1,  2,      广州市,   113.261805,23.265706,2020-04-04 16:03:12,广东省广州市天河客运站
4, 13533592804,李四四,1,  4,      中山市,   113.408984,22.522077,2020-04-04 16:23:22,广东省中山市客运站
5, 13533592805,李诗四,2,  3,      东莞市,   113.747034,23.025384,2020-04-04 16:35:38,广东省东莞市棠涌客运站
6, ,           空数据,0,  0,      ,         0,0,2020-03-04,,
-----------------------------------------------------------------------以下数据格式不要改：不能格式化json,最后一行数据后回车两次-------------------------------------------
{"create":{"_index":"student"}}
{"id":"1","tel":"13533592801","name":"张三丰","sex":"1","city_id":"1","city_name":"深圳市","location":{"lat":22.719571,"lon":114.364493},"create_time":"2020-04-04 15:57:20","address":"广东省深圳市龙岗区坪山站"}
{"create":{"_index":"student"}}
{"id":"2","tel":"13533592802","name":"张三花","sex":"2","city_id":"1","city_name":"深圳市","location":{"lat":22.632069,"lon":114.062088},"create_time":"2020-04-04 15:58:52","address":"广东省深圳市龙岗区坂田站"}
{"create":{"_index":"student"}}
{"id":"3","tel":"13533592803","name":"张三","sex":"1","city_id":"2","city_name":"广州市","location":{"lat":23.265706,"lon":113.261805},"create_time":"2020-04-04 16:03:12","address":"广东省广州市天河客运站"}
{"create":{"_index":"student"}}
{"id":"4","tel":"13533592804","name":"李四四","sex":"1","city_id":"4","city_name":"中山市","location":{"lat":22.522077,"lon":113.408984},"create_time":"2020-04-04 16:23:22","address":"广东省中山市客运站"}
{"create":{"_index":"student"}}
{"id":"5","tel":"13533592805","name":"李诗四","sex":"2","city_id":"3","city_name":"东莞市","location":{"lat":23.025384,"lon":113.747034},"create_time":"2020-04-04 16:35:38","address":"广东省东莞市棠涌客运站"}
{"create":{"_index":"student"}}
{"id":"6","tel":"","name":"空数据","sex":"0","city_id":"0","city_name":"","location":{"lat":0,"lon":0},"create_time":"2020-03-04","address":""}


-----------------------------------------------------------------------以上数据格式不要改-------------------------------------------

批量添加数据：

https://es地址/student/_bulk