es父子条件查询语句

es父子条件查询语句

DELETE my_blogs

# 设定 Parent/Child Mapping
PUT my_blogs
{
  "settings": {
    "number_of_shards": 2
  },
  "mappings": {
    "properties": {
      "blog_comments_relation": {
        "type": "join",
        "relations": {
          "blog": "comment"
        }
      },
      "content": {
        "type": "text"
      },
      "title": {
        "type": "keyword"
      }
    }
  }
}

#索引父文档
PUT my_blogs/_doc/blog1
{
  "title":"Learning Elasticsearch",
  "content":"learning ELK @ geektime",
  "blog_comments_relation":{
    "name":"blog"
  }
}

#索引父文档
PUT my_blogs/_doc/blog2
{
  "title":"Learning Hadoop",
  "content":"learning Hadoop",
    "blog_comments_relation":{
    "name":"blog"
  }
}

#索引子文档
PUT my_blogs/_doc/comment1?routing=blog1
{
  "comment":"I am learning ELK",
  "username":"Jack",
  "blog_comments_relation":{
    "name":"comment",
    "parent":"blog1"
  }
}

#索引子文档
PUT my_blogs/_doc/comment2?routing=blog2
{
  "comment":"I like Hadoop!!!!!",
  "username":"Jack",
  "blog_comments_relation":{
    "name":"comment",
    "parent":"blog2"
  }
}

#索引子文档
PUT my_blogs/_doc/comment3?routing=blog2
{
  "comment":"Hello Hadoop",
  "username":"Bob",
  "blog_comments_relation":{
    "name":"comment",
    "parent":"blog2"
  }
}

POST my_blogs/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "username":"Jack"
          }
        },{
          "has_parent": {
          "parent_type": "blog",
          "query" : {
              "match": {
                "title" : "Learning Hadoop"
              }
            },"inner_hits":{}
          }
        }
      ]
    }
  }
}

POST my_blogs/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "username":"Jack"
          }
        },{
          "has_parent": {
          "parent_type": "blog",
          "query" : {
              "match": {
                "title" : "Learning Hadoop"
              }
            },"inner_hits":{}
          }
        }
      ]
    }
  }
}

POST my_blogs/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "match_all": {
            
          }
        },{
          "has_parent": {
          "parent_type": "blog",
          "query" : {
              "match": {
                "title" : "Learning Hadoop"
              }
            },"inner_hits":{}
          }
        }
      ]
    }
  }
}

POST my_blogs/_search
{
  "query": {
   
          "has_parent": {
          "parent_type": "blog",
          "query" : {
              "match": {
                "title" : "Learning Hadoop"
              }
            },"inner_hits":{}
          }
        }
      
}

POST my_blogs/_search
{
  "query": {
    "has_child": {
      "type": "comment",
      "query" : {
                "match": {
                    "username" : "Jack"
                }
            },"inner_hits":{}
    }
  }
}

POST family_tree/_search
{
  "query": {
    "has_child": {
      "type": "child",
      "query" : {
                "match": {
                    "name" : "SUV"
                }
            }
    }
  }
}