Elasticsearch6.3.1存储JSON文档 -- object和NESTED

我会带着你远行 2022-03-26 11:06 2122阅读 0赞

#### 简述 ####

--------------------

JSON格式毋庸置疑是使用比较广泛的数据格式。如今，我们使用ES怎么存储JSON格式的数据呢？又怎么查询呢？

#### Object类型 ####

--------------------

ES使用object数据类型来存储json格式的数据。下面我们来试验一下：

*  我们使用ES存储下面的json字符串

{
      "dynasty":"Qing",
      "emperor":"Qianlong",
      "woman":[
        {
        "name":"YanXi",
        "age":"27",
        "address":"YanXiGong"
        },
           {
        "name":"XianFei",
        "age":"37",
        "address":"ChengQianGong"
        }, 
        {
        "name":"HuangHou",
        "age":"35",
        "address":"ChangQingGong"
        }
      ]
    }

*  创建mapping

{
      "mappings": {
        "_doc": { 
          "properties": {
            "dynasty": {
              "type": "keyword"
            },
           "emperor": {
              "type": "text"
            },
            "woman": { 
              "properties": {
                "age":  { "type": "integer" },
                "name": {"type": "text"},
                "address": {"type": "text"}
              }
            }
          }
        }
      }
    }

*  插入数据

{
    "dynasty": "Qing",
    "emperor": "Qianlong",
    "woman": [
    {
    "name": "YanXi",
    "age": "27",
    "address": "YanXiGong"
    }
    ,
    {
    "name": "XianFei",
    "age": "37",
    "address": "ChengQianGong"
    }
    ,
    {
    "name": "HuangHou",
    "age": "35",
    "address": "ChangQingGong"
    }
    ]
    }

*  查看数据  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70]
 *  查询  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 1]

> 纳尼？？为啥查出来了呢？？我用的是must的呀，并且YanXi没有37岁呀

*  解释  
    这是因为我们上面传入的json文档都存为了一条文档中了，上面的插入其实被转化为：

{
      "dynasty": "Qing",
      "emperor": "Qianlong",
      "woman.name":["YanXi", "XianFei", "HuangHou"],
      "woman.age":["27", "37", "35"],
      "woman.address":["YanXiGong", "ChengQianGong", "ChangQingGong"]
    
    }

> 怎么办呢？！！那就是Nested类型的用武之地了

#### Nested ####

--------------------

*  mapping

{
      "mappings": {
        "_doc": {
          "properties": {
            "dynasty": {
              "type": "keyword"
            },
            "emperor": {
              "type": "text"
            },
            "woman": {
              "type": "nested",
              "properties": {
                "age": {
                  "type": "integer"
                },
                "name": {
                  "type": "text"
                },
                "address": {
                  "type": "text"
                }
              }
            }
          }
        }
      }
    }

*  插入数据

{
    "dynasty": "Qing",
    "emperor": "Qianlong",
    "woman": [
    {
    "name": "YanXi",
    "age": "27",
    "address": "YanXiGong"
    }
    ,
    {
    "name": "XianFei",
    "age": "37",
    "address": "ChengQianGong"
    }
    ,
    {
    "name": "HuangHou",
    "age": "35",
    "address": "ChangQingGong"
    }
    ]
    }

*  查询

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 2]

*  查询  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 3]  
    `不过NESTED类型有限制的，嵌套数量不能多于50个`

--------------------

> 先写到这里了，有问题进QQ群630300475 聊一聊

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70]: /images/20220326/a154e92651a54e54afc78394bd66260c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 1]: /images/20220326/298225b7c8a14e4f8256fd9d88db5b2f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 2]: /images/20220326/5059bc41629a48fbaaec9f5cab60f1b0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQ2ODYzOTk_size_16_color_FFFFFF_t_70 3]: /images/20220326/53fb06e594f145ef9c5fae05ae669e58.png