Elastic Search修改映射和数据迁移操作------Elastic Search

于 2024-07-14 10:14:03 发布
阅读量901 收藏 14
点赞数 21
分类专栏： # Elastic Search 数据库 文章标签： 搜索引擎 数据库 后端 mybatis 微服务 分布式 spring cloud
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/140413020
版权 
POST _reindex
{
  "source": {
    "index": "bank",
    "type": "account"
  },
  "dest": {
    "index": "newbank"
  }
}

GET /bank/_search

GET /newbank

POST _reindex
{
  "source": {
    "index": "bank",
    "type": "account"
  },
  "dest": {
    "index": "newbank"
  }
}

GET /bank/_search

GET /newbank

#! Deprecation: [types removal] Specifying types in reindex requests is deprecated.
{
  "took" : 2078,
  "timed_out" : false,
  "total" : 1000,
  "updated" : 0,
  "created" : 1000,
  "deleted" : 0,
  "batches" : 1,
  "version_conflicts" : 0,
  "noops" : 0,
  "retries" : {
    "bulk" : 0,
    "search" : 0
  },
  "throttled_millis" : 0,
  "requests_per_second" : -1.0,
  "throttled_until_millis" : 0,
  "failures" : [ ]
}

 #! Deprecation: [types removal] Specifying types in reindex requests is deprecated.
{
  "took" : 2078,
  "timed_out" : false,
  "total" : 1000,
  "updated" : 0,
  "created" : 1000,
  "deleted" : 0,
  "batches" : 1,
  "version_conflicts" : 0,
  "noops" : 0,
  "retries" : {
    "bulk" : 0,
    "search" : 0
  },
  "throttled_millis" : 0,
  "requests_per_second" : -1.0,
  "throttled_until_millis" : 0,
  "failures" : [ ]
}

POST _reindex
{
  "source": {
    "index": "bank",
    "type": "account"
  },
  "dest": {
    "index": "newbank"
  }
}

GET /bank/_search

GET /newbank/_search
## 不用type,老的数据可以通过_reindex迁移

POST _reindex
{
  "source": {
    "index": "bank",
    "type": "account"
  },
  "dest": {
    "index": "newbank"
  }
}

GET /bank/_search

GET /newbank/_search
## 不用type,老的数据可以通过_reindex迁移

{
  "took" : 10,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1000,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 1,
          "balance" : 39225,
          "firstname" : "Amber",
          "lastname" : "Duke",
          "age" : 32,
          "gender" : "M",
          "address" : "880 Holmes Lane",
          "employer" : "Pyrami",
          "email" : "amberduke@pyrami.com",
          "city" : "Brogan",
          "state" : "IL"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "6",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 6,
          "balance" : 5686,
          "firstname" : "Hattie",
          "lastname" : "Bond",
          "age" : 36,
          "gender" : "M",
          "address" : "671 Bristol Street",
          "employer" : "Netagy",
          "email" : "hattiebond@netagy.com",
          "city" : "Dante",
          "state" : "TN"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "13",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "18",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "20",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 20,
          "balance" : 16418,
          "firstname" : "Elinor",
          "lastname" : "Ratliff",
          "age" : 36,
          "gender" : "M",
          "address" : "282 Kings Place",
          "employer" : "Scentric",
          "email" : "elinorratliff@scentric.com",
          "city" : "Ribera",
          "state" : "WA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "25",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 25,
          "balance" : 40540,
          "firstname" : "Virginia",
          "lastname" : "Ayala",
          "age" : 39,
          "gender" : "F",
          "address" : "171 Putnam Avenue",
          "employer" : "Filodyne",
          "email" : "virginiaayala@filodyne.com",
          "city" : "Nicholson",
          "state" : "PA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "32",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 32,
          "balance" : 48086,
          "firstname" : "Dillard",
          "lastname" : "Mcpherson",
          "age" : 34,
          "gender" : "F",
          "address" : "702 Quentin Street",
          "employer" : "Quailcom",
          "email" : "dillardmcpherson@quailcom.com",
          "city" : "Veguita",
          "state" : "IN"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "37",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 37,
          "balance" : 18612,
          "firstname" : "Mcgee",
          "lastname" : "Mooney",
          "age" : 39,
          "gender" : "M",
          "address" : "826 Fillmore Place",
          "employer" : "Reversus",
          "email" : "mcgeemooney@reversus.com",
          "city" : "Tooleville",
          "state" : "OK"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "44",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 44,
          "balance" : 34487,
          "firstname" : "Aurelia",
          "lastname" : "Harding",
          "age" : 37,
          "gender" : "M",
          "address" : "502 Baycliff Terrace",
          "employer" : "Orbalix",
          "email" : "aureliaharding@orbalix.com",
          "city" : "Yardville",
          "state" : "DE"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "49",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 49,
          "balance" : 29104,
          "firstname" : "Fulton",
          "lastname" : "Holt",
          "age" : 23,
          "gender" : "F",
          "address" : "451 Humboldt Street",
          "employer" : "Anocha",
          "email" : "fultonholt@anocha.com",
          "city" : "Sunriver",
          "state" : "RI"
        }
      }
    ]
  }
}

 {
  "took" : 10,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1000,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 1,
          "balance" : 39225,
          "firstname" : "Amber",
          "lastname" : "Duke",
          "age" : 32,
          "gender" : "M",
          "address" : "880 Holmes Lane",
          "employer" : "Pyrami",
          "email" : "amberduke@pyrami.com",
          "city" : "Brogan",
          "state" : "IL"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "6",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 6,
          "balance" : 5686,
          "firstname" : "Hattie",
          "lastname" : "Bond",
          "age" : 36,
          "gender" : "M",
          "address" : "671 Bristol Street",
          "employer" : "Netagy",
          "email" : "hattiebond@netagy.com",
          "city" : "Dante",
          "state" : "TN"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "13",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "18",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "20",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 20,
          "balance" : 16418,
          "firstname" : "Elinor",
          "lastname" : "Ratliff",
          "age" : 36,
          "gender" : "M",
          "address" : "282 Kings Place",
          "employer" : "Scentric",
          "email" : "elinorratliff@scentric.com",
          "city" : "Ribera",
          "state" : "WA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "25",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 25,
          "balance" : 40540,
          "firstname" : "Virginia",
          "lastname" : "Ayala",
          "age" : 39,
          "gender" : "F",
          "address" : "171 Putnam Avenue",
          "employer" : "Filodyne",
          "email" : "virginiaayala@filodyne.com",
          "city" : "Nicholson",
          "state" : "PA"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "32",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 32,
          "balance" : 48086,
          "firstname" : "Dillard",
          "lastname" : "Mcpherson",
          "age" : 34,
          "gender" : "F",
          "address" : "702 Quentin Street",
          "employer" : "Quailcom",
          "email" : "dillardmcpherson@quailcom.com",
          "city" : "Veguita",
          "state" : "IN"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "37",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 37,
          "balance" : 18612,
          "firstname" : "Mcgee",
          "lastname" : "Mooney",
          "age" : 39,
          "gender" : "M",
          "address" : "826 Fillmore Place",
          "employer" : "Reversus",
          "email" : "mcgeemooney@reversus.com",
          "city" : "Tooleville",
          "state" : "OK"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "44",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 44,
          "balance" : 34487,
          "firstname" : "Aurelia",
          "lastname" : "Harding",
          "age" : 37,
          "gender" : "M",
          "address" : "502 Baycliff Terrace",
          "employer" : "Orbalix",
          "email" : "aureliaharding@orbalix.com",
          "city" : "Yardville",
          "state" : "DE"
        }
      },
      {
        "_index" : "newbank",
        "_type" : "_doc",
        "_id" : "49",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 49,
          "balance" : 29104,
          "firstname" : "Fulton",
          "lastname" : "Holt",
          "age" : 23,
          "gender" : "F",
          "address" : "451 Humboldt Street",
          "employer" : "Anocha",
          "email" : "fultonholt@anocha.com",
          "city" : "Sunriver",
          "state" : "RI"
        }
      }
    ]
  }
}

旧约Alatus
关注
专栏目录
Elasticsearch(ES) 添加/更新映射
java_xxxx的博客
09-21 4248
原文地址：https://www.exception.site/elasticsearch/elasticsearch-add-mappings 通过 Elasticsearch API 可以向索引(Index) 添加文档类型(Type), 或者向文档类型(Type) 中添加/更新字段(Field)。 PUT http://127.0.0.1:9200/commodity { "mappings": { "_doc": { "properties": { "commodity_id":
ES系列--修改字段映射类型
soso的博客
12-28 3277
前言 之前在没有创建索引模板的时候，直接通过logstash往es里塞数据，其中一些字段的类型并不符合我们需要，这个时候就需要去修改字段的映射类型了。 正文 es不支持直接修改字段类型，解决思路： 新建临时索引，执行字段类型，复制数据 删除旧索引，重建同名索引，从临时索引复制数据 #获取旧索引的字段映射 GET /users/_mapping #创建临时索引带映射 PUT /users_temp { "mappings": { "user": { "properties": {
Elasticsearch基础3--聚合函数
Kdurantyw1的博客
05-13 634
"size": 1000 #展示多少种情况。#获取各年龄段男女的平均薪资。
es修改mapping映射
five小点心的博客
12-29 1771
在Elasticsearch中，一旦一个字段被创建，它的数据类型通常是固定的，不能直接修改。这是因为Elasticsearch是基于倒排索引的，字段的数据类型在创建索引时确定，并且与索引的结构相关联。5、新建同名新索引及映射（同上）6、从中间索引中还原数据（同上）3、向中间索引备份源索引数据。2、创建mapping映射。确认是否copy过去。
Elasticsearch之映射
weixin_53172154的博客
07-19 914
如果你想在运动时增加新的字段，你可能会启用动态映射，然而有时候动态映射规则可能不太智能，幸运的是，我们可以通过设置去自定义这些规则，以便更好的适用于你的数据当 Elasticsearch 遇到一个新的字符串字段时，它会检测这个字段是否包含一个可识别的日期，比如 2014-01-01 如果它像日期，这个字段就会被作为 date 类型添加。否则，它会被作为 string 类型添加。有些时候这个行为可能导致一些问题。想象下，你有如下这样的一个文档：
最新版windows elasticsearch-8.10.0-windows-x86-64.zip
09-16
Windows 版本的 Elasticsearch 为 Windows 操作系统的用户提供了在本地运行和管理 Elasticsearch 的便利。该版本特别为64位（x86_64）架构优化，确保在Windows平台上高效执行。 安装与配置： 1. **下载与解压**：...
elasticsearch-bulk-insert-plugin-8.2.0.0-342.zip
07-14
3. **字段映射**：在升级后，可能需要检查和更新数据源的字段映射，确保它们与Elasticsearch 7.x的映射规则相匹配。 4. **版本兼容性**：确保Kettle的Elasticsearch插件版本与Elasticsearch服务器版本兼容，避免因...
elastic-schema:为Elasticsearch文档定义模式的简便方法，因此您可以轻松地将当前结构数据更新迁移到其他内容
05-21
一种声明性的方式来处理Elasticsearch文档映射和数据迁移/重新索引。 该想法是提供一种简单且可版本控制的方式来注册您的Elasticsearch索引和类型的映射。 一旦开发人员对任何映射和/或设置进行了更改，此工具包将...
Elasticsearch--高级-映射_修改映射 & 数据迁移---全文检索引擎ElasticSearch工作笔记019
添柴程序猿的专栏
02-10 307
然后我们之前都添加映射,那么如果我们修改,映射,怎么修改呢? 我们可以直接修改嘛,比如,直接在mappings中修改,对应的类型,可以看到一执行报错对吧.不能直接修改. 可以看到,如果我们这里把这个employee-id,的type类型改成long的 话,执行,报错了.还是. 然后我们可以获取一下my_index索引的_mapping去看看 可以看到右边,现在my_index有这些索引. 然后我们可以去看看文档,如果我们想去更新映射的话,那么. 可以看到上面写了,不能进行直接..
elasticsearch-dump-6.78.0.tar.gz
11-28
数据备份和迁移在 Elasticsearch 的运维过程中至关重要，因为它们能保护数据免受意外丢失，并支持在升级、故障恢复或扩展集群时平滑过渡。 Elasticsearch-dump 工具主要功能包括： 1. **数据导入（Import）**：它...
Elasticsearch(四）--一文弄懂ES的映射操作
学习不止境的博客
01-18 3795
如商品是否售罄，房屋是否已租，酒店房间是否满房等。
POST修改es的索引映射关系
weixin_40857858的博客
09-11 603
POST 索引名称/_mapping/文档名称 { "文档名称":{ "dynamic":"false", "properties":{ "financeApprovalTime":{ "type":"date", "null_value":"-62167420800000" "format":"yyyy-MM-dd HH:mm:ss" }
Elasticsearch学习-索引操作及Mapping映射
nsa65223的专栏
07-12 3334
在7.X版本前类似于关系型数据库中的数据库概念，8.X版本后删除了type概念，索引类似于关系型数据库中的表。
【ES从入门到实战】二十、全文检索-ElasticSearch-映射-修改映射&数据迁移
runewbie的博客
05-28 496
接第19节 4、数据迁移 先创建出 twitter 的正确映射。然后使用如下方式进行数据迁移 # 7.x 之后的写法 POST _reindex //固定写法 { "source": { //老索引 "index": "twitter" }, "dest": { //目标索引 "index": "new_twitter" } } # 7.x之前的带 type 的写法 将旧索引的 type 下的数据进行迁移 POST _reindex //固定写法 { "sourc.
Elasticsearch优化索引映射和设置
最新发布
Dxy1239310216的博客
06-28 608
通过选择合适的字段类型、避免动态映射、优化字段属性和调整索引设置等措施，您可以构建更高效、更可靠的搜索系统。在Elasticsearch的世界中，优化索引的映射（mapping）和设置（settings）对于提高搜索性能、存储效率和系统稳定性至关重要。使用Elasticsearch的监控工具（如Elasticsearch Monitoring）和日志分析工具（如ELK Stack）来监控索引的性能和健康状况，并根据分析结果进行相应的优化。随着时间的推移，索引中可能会积累大量不再需要的数据或旧的段文件。
ES的索引文档映射操作(二)
两个蝴蝶飞
04-06 828
1. 索引操作 2. 文档操作 3. 映射处理
九.全文检索ElasticSearch经典入门-ElasticSearch映射修改
墨家巨子@俏如来
04-30 4196
这篇文章的内容是ElasticSearch映射修改，写这篇文章是有水友公司里面遇到了映射修改问题，我这里做了一个整理，希望对你有所帮助。
elasticsearch 不停机进行数据迁移
06-09
1. 在新的 Elasticsearch 集群中创建相同的索引和映射，使用 `_reindex` API 将数据从旧集群迁移到新集群中： ```bash POST _reindex { "source": { "remote": { "host": "http://old-elasticsearch:9200" }, ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值