ES索引结构升级-笔记

朴灿烈づ我的快乐病毒、 2024-03-22 13:14 38阅读 0赞

## ES中索引的字段类型是不可修改的，只能是重新创建一个索引并设置好mapping，然后再将老索引的数据复制过去 ##

1.  查看老索引mapping

GET /twitter/_mappings

![在这里插入图片描述][1ce81a29c4634f75b4d0ccb0d059ab35.png_pic_center]

1.  创建new索引，并指定mapping

PUT /twitter410

{
        
    	"mappings": {
        
    		"properties": {
        
    			"author_id": {
        
    				"type": "long"
    			},
    			"author_name": {
        
    				"type": "text",
    				"fields": {
        
    					"keyword": {
        
    						"type": "keyword",
    						"ignore_above": 256
    					}
    				}
    			},
    			"created_at": {
        
    				"type": "keyword"
    			},
    			"message": {
        
    				"type": "text",
    				"fields": {
        
    					"keyword": {
        
    						"type": "keyword",
    						"ignore_above": 256
    					}
    				}
    			}
    		}
    	}
    }

![在这里插入图片描述][286173affb9a46e289af2268acbee505.png_pic_center]

1.  将老的索引中的数据复制到新的索引中

POST _reindex

{
        
        "source":{
        
            "index":"twitter" //老索引名
        },
        "dest":{
        
            "index":"twitter410"  //新索引名
        }
    }

![在这里插入图片描述][f6a75fe9a51940c2a846acb35c05acad.png_pic_center]

1.  删除老索引twitter

# curl -XDELETE -u elastic:elasticpasswd http://localhost:9200/index_name
    {"acknowledged":true}

![在这里插入图片描述][9a0ce1e13e74410faa00b8781ff63126.png_pic_center]

1.  修改new索引名 为老索引名

法1，通过起别名方式 (建议使用这种方式，不需要多次reindex)

POST _aliases

{
        
        "actions": [
        {
        
          "add": {
        
            "index": "twitter410",
            "alias": "twitter"
          }
        }
      ]
    }

![在这里插入图片描述][1f7ef94bda454d2a8d1e80d939498603.png_pic_center]

法2，再建一个索引叫twitter，然后把twitter410 进行 reindex到twitter；

即执行PUT创建后，再执行POST-reindex

PUT /twitter
    {
        
    	"mappings": {
        
    		"properties": {
        
    			"author_id": {
        
    				"type": "long"
    			},
    			"author_name": {
        
    				"type": "text",
    				"fields": {
        
    					"keyword": {
        
    						"type": "keyword",
    						"ignore_above": 256
    					}
    				}
    			},
    			"created_at": {
        
    				"type": "keyword"
    			},
    			"message": {
        
    				"type": "text",
    				"fields": {
        
    					"keyword": {
        
    						"type": "keyword",
    						"ignore_above": 256
    					}
    				}
    			}
    		}
    	}
    }
    
    POST _reindex
    {
        
      "source": {
        
        "index": "twitter410"
      },
      "dest": {
        
        "index": "twitter"
      }
    }

## 当新索引结构里字段名 和老索引结构里的不一样时，改怎么迁移数据 ##

场景：twitter2023140这个新索引的信息内容字段是msg\_content ,而老索引里是message ，执行数据迁移时需要特殊指定reindex的迁移字段转换逻辑。

POST _reindex
    {
        
      "source": {
        
        "index": "twitter"
      },
      "dest": {
        
        "index": "twitter2023140"
      },
      "script":{
        
        "source":"ctx._source.msg_content=ctx._source.remove(\"message\")"
      }
    }

![在这里插入图片描述][b518a0b6347a448aaa0458b6909bb20f.png_pic_center]

[1ce81a29c4634f75b4d0ccb0d059ab35.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/617ca05aab6e462d9e6e57a0c03dad79.png
[286173affb9a46e289af2268acbee505.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/d2449dbf98db43e881c5f853b5ddac8f.png
[f6a75fe9a51940c2a846acb35c05acad.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/61c2b9a2e8944b1ea7f9459593fab72a.png
[9a0ce1e13e74410faa00b8781ff63126.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/e575f8bc738043eab65e92eb1b893ef8.png
[1f7ef94bda454d2a8d1e80d939498603.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/e2eb1327459a4bf48c9b15045bd139a3.png
[b518a0b6347a448aaa0458b6909bb20f.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/22/9895d7f26a8e4b79a944ca9dad4b9e1a.png