es 父子文档操作

最新推荐文章于 2023-02-02 09:13:10 发布

bug-007

最新推荐文章于 2023-02-02 09:13:10 发布

阅读量142

点赞数

分类专栏：后端文章标签： elasticsearch sql 大数据

本文链接：https://blog.csdn.net/weixin_43326384/article/details/127268624

版权

后端专栏收录该内容

23 篇文章 1 订阅

订阅专栏

GET /user_login_log2/_mapping

GET /user_login_log2/_search

PUT user_login_log2
{
  "mappings": {
    "properties": {
      "my_join_field": { 
        "type": "join",
        "relations": {
          "question": "answer" 
        }
      }
    }
  }
}

# 添加父文档
PUT user_login_log2/_doc/1?refresh
{
  "createDate":"2020-09-09",
  "userid":"10000",
  "my_join_field": {
    "name": "question" 
  }
}

# 添加子文档
PUT user_login_log2/_doc/10?routing=1&refresh 
{
  "platform_type":10,
  "my_join_field": {
    "name": "answer", 
    "parent": "1" 
  }
}

PUT user_login_log2/_doc/11?routing=1&refresh 
{
  "platform_type":11,
  "my_join_field": {
    "name": "answer", 
    "parent": "1" 
  }
}


GET /user_login_log2/_search
{
  "query": {
    "has_parent": {
      "parent_type": "question",
      "query": {
        "term": {
          "userid.keyword": {
            "value": "10000"
          }
        }
      }
    }
  }
}


GET _sql
{
  "query": "select * from user_login_log2  "
}