Es之java各种查询操作

Es之java各种查询操作

matchAllQuery	匹配所有文档
queryStringQuery	基于Lucene的字段检索
wildcardQuery	通配符查询匹配多个字符，?匹配1个字符*
termQuery	词条查询
matchQuery	字段查询
idsQuery	标识符查询
fuzzyQuery	文档相似度查询
includeLower includeUpper	范围查询
boolQuery	组合查询（复杂查询）
SortOrder	排序查询

插入样例数据：

curl -XPOST http://hadoop01:9200/sanguo/dahan/_bulk -d '
{ "index": {}}    
{ "studentNo" : 1, "name" : "刘备", "male" : "男", "age" : 24 , "birthday" : "1985-02-03" , "classNo" : 1 , "address" : "湖南省长沙市" , "isLeader" : true}
{ "index": {}}            
{ "studentNo" : 2, "name" : "关羽", "male" : "男", "age" : 22 , "birthday" : "1987-08-23" , "classNo" : 2, "address" : "四川省成都市" , "isLeader" : false}
{ "index": {}}                                 
{ "studentNo" : 3, "name" : "糜夫人", "male" : "女", "age" : 19 , "birthday" : "1990-06-12" , "classNo" : 1 , "address" : "上海市" , "isLeader" : false}
{ "index": {}}
{ "studentNo" : 4, "name" : "张飞", "male" : "男", "age" : 20 , "birthday" : "1989-07-30" , "classNo" : 3 , "address" : "北京市" , "isLeader" : false}
{ "index": {}}
{ "studentNo" : 5, "name" : "诸葛亮", "male" : "男", "age" : 18 , "birthday" : "1992-04-27" , "classNo" : 2 , "address" : "江苏省南京市" , "isLeader" : true}
{ "index": {}}     
{ "studentNo" : 6, "name" : "孙尚香", "male" : "女", "age" : 16 , "birthday" : "1994-05-21" , "classNo" : 3 , "address" : "广东省深圳市" , "isLeader" : false}
{ "index": {}}              
{ "studentNo" : 7, "name" : "马超", "male" : "男", "age" : 19 , "birthday" : "1991-10-20" , "classNo" : 1 , "address" : "黑龙江省哈尔滨市" , "isLeader" : false}
{ "index": {}}                        
{ "studentNo" : 8, "name" : "赵云", "male" : "男", "age" : 23 , "birthday" : "1986-10-26" , "classNo" : 2 , "address" : "浙江省杭州市" , "isLeader" : false}
'

---

基础查询操作

1：查询所有

matchAllQuery()匹配所有文件

match_all查询是Elasticsearch中最简单的查询之一。它使我们能够匹配索引中的所有文件。

/**
 *matchAllQuery()匹配所有文件
 match_all查询是Elasticsearch中最简单的查询之一。它使我们能够匹配索引中的所有文件
 * */
@Test
public void searchAll(){
    SearchResponse searchResponse = client.prepareSearch("sanguo")
            .setTypes("dahan").setQuery(QueryBuilders.matchAllQuery())
            .get();

    SearchHits hits = searchResponse.getHits(); // 获取命中次数，查询结果有多少对象
    System.out.println("查询结果有：" + hits.getTotalHits() + "条");
    Iterator<SearchHit> iterator = hits.iterator();
    while (iterator.hasNext()) {
        SearchHit next = iterator.next();
        System.out.println("name : "+ next.getSource().get("name"));
        System.out.println("studentNo : "+ next.getSource().get("studentNo"));
        System.out.println("male : "+ next.getSource().get("male"));
        System.out.println("birthday : "+ next.getSource().get("birthday"));
        System.out.println("classNo : "+ next.getSource().get("classNo"));
        System.out.println("address : "+ next.getSource().get("address"));
        System.out.println("===============================================");
    }
}

2：解析查询字符串

相比其他可用的查询，query_string查询支持全部的Apache Lucene查询语法

针对多字段的query_string查询

/**
 * 相比其他可用的查询，query_string查询支持全部的Apache Lucene查询语法
 针对多字段的query_string查询
 * */
@Test
public void query_String(){
    SearchResponse searchResponse = client.prepareSearch("sanguo").setTypes("dahan")
            .setQuery(QueryBuilders.queryStringQuery("孙尚香")).get();
    SearchHits hits = searchResponse.getHits(); // 获取命中次数，查询结果有多少对象
    System.out.println("查询结果有：" + hits.getTotalHits() + "条");
    Iterator<SearchHit> iterator = hits.iterator();
    while (iterator.hasNext()) {
        SearchHit next = iterator.next();
        System.out.println("name : "+ next.getSource().get("name"));
        System.out.println("studentNo : "+ next.getSource().get("studentNo"));
        System.out.println("male : "+ next.getSource().get("male"));
        System.out.println("birthday : "+ next.getSource().get("birthday"));
        System.out.println("classNo : "+ next.getSource().get("classNo"));
        System.out.println("address : "+ next.getSource().get("address"));
        System.out.println("===============================================");
    }
}

3：通配符查询（wildcardQuery）

*匹配多个字符，?匹配1个字符

注意：避免* 开始, 会检索大量内容造成效率缓慢

/**
 * *匹配多个字符，?匹配1个字符
 注意：避免* 开始, 会检索大量内容造成效率缓慢
 * */
@Test
public void wildcardQuery(){
    SearchResponse searchResponse = client.prepareSearch("sanguo").setTypes("dahan")
            .setQuery(QueryBuilders.wildcardQuery("address", "广东*")).get();
    SearchHits hits = searchResponse.getHits(); // 获取命中次数，查询结果有多少对象
    System.out.println("查询结果有：" + hits.getTotalHits() + "条");
    Iterator<SearchHit> iterator = hits.iterator();
    while (iterator.hasNext()) {
        SearchHit next = iterator.next();
        System.out.println("name : "+ next.getSource().get("name"));
        System.out.println("studentNo : "+ next.getSource().get("studentNo"));
        System.out.println("male : "+ next.getSource().get("male"));
        System.out.println("birthday : "+ next.getSource().get("birthday"));
        System.out.println("classNo : "+ next.getSource().get("classNo"));
        System.out.println("address : "+ next.getSource().get("address"));
        System.out.println("===============================================");
    }
}

4：词条查询（termQuery）

词条查询是Elasticsearch中的一个简单查询。它仅匹配在给定字段中含有该词条的文档，而且是确切的、未经分析的词条

termQuery(“key”, obj) 完全匹配

termsQuery(“key”, obj1, obj2…)

一次匹配多个值，有一个值是正确的，就可以查询出数据

/**
 * 词条查询是Elasticsearch中的一个简单查询。它仅匹配在给定字段中含有该词条的文档，而
 且是确切的、未经分析的词条
 termQuery("key", obj) 完全匹配
 termsQuery("key", obj1, obj2..)   一次匹配多个值，只有有一个值是正确的，就可以查询出数据
 * */
@Test
public void termQuery(){
    SearchResponse searchResponse = client.prepareSearch("sanguo").setTypes("dahan")
            .setQuery(QueryBuilders.termsQuery("name", "张飞","刘备","关羽")).get();
    SearchHits hits = searchResponse.getHits(); // 获取命中次数，查询结果有多少对象
    System.out.println("查询结果有：" + hits.