ES创建索引并备份

ES创建索引并备份

ES创建索引并备份

创建索引

PUT jsxd_weixiudcb_20221019
{"settings" : {"index" : {"number_of_shards" : 3,"number_of_replicas" : 2},"analysis": {"analyzer": {"common": {"type": "pattern","pattern":";"}}}}
}

指定字段

PUT /jsxd_weixiudcb_20221019/_mapping
{"properties": {"WEXI_ID": {"type": "keyword"},"WEXI_COMPID_FK": {"type": "keyword"},"WEXI_CREATE_USERID_FK": {"type": "keyword"},"WEXI_CREATE_USERID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_MODIFY_USERID_FK": {"type": "keyword"},"WEXI_MODIFY_USERID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_CREATETIME": {"type": "long"},"WEXI_MODIFYTIME": {"type": "long"},"WEXI_ISDELETED": {"type": "long"},"WEXI_IMPTTASK_DRRWID_FK": {"type": "keyword"},"WEXI_IMPTTASK_DRRWID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_IMPTTASKDETAIL_DRRWID_FK": {"type": "keyword"},"WEXI_IMPTTASKDETAIL_DRRWID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_RENWUBIANHAO": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_GONGCHANG_GOCHID_FK": {"type": "keyword"},"WEXI_GONGCHANG_GOCHID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_CHEJIAN_CHJIID_FK": {"type": "keyword"},"WEXI_CHEJIAN_CHJIID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_CHUANGHAO_PIQUID_FK": {"type": "keyword"},"WEXI_CHUANGHAO_PIQUID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_SHEBEI_SBTZID_FK": {"type": "keyword"},"WEXI_SHEBEI_SBTZID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_JIXING_JIXIID_FK": {"type": "keyword"},"WEXI_JIXING_JIXIID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_GONGXU_PIPAID_FK": {"type": "keyword"},"WEXI_GONGXU_PIPAID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_WEIHUGONG_USERID_FK": {"type": "keyword"},"WEXI_WEIHUGONG_USERID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_ZHIXINGBUMEN_DEMEID_FK": {"type": "keyword"},"WEXI_ZHIXINGBUMEN_DEMEID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_DATEWH": {"type": "long"},"WEXI_ZHUANYE_ZHYEID_FK": {"type": "keyword"},"WEXI_ZHUANYE_ZHYEID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_WEIHUZHUANGTAI": {"type": "keyword"},"WEXI_ZISHEBEI_SBTZID_FK": {"type": "keyword"},"WEXI_ZISHEBEI_SBTZID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_SHEBEILEIBIEZI_SBFLID_FK": {"type": "keyword"},"WEXI_SHEBEILEIBIEZI_SBFLID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BAOYANGBUWEI": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BAOYANGXIANGMU": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_XIANGMUDAIMA": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BAOYANGBIAOZHUN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BAOYANGFANGSHI_WEBAID_FK": {"type": "keyword"},"WEXI_BAOYANGFANGSHI_WEBAID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BAOYANGJIEGUO": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BEIJIANBIANMA": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_BEIJIANMINGCHEN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_GUIGE": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_DANWEI": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_SHULIANG": {"type": "double"},"WEXI_SSWBRW_WBRWID_FK": {"type": "keyword"},"WEXI_SSWBRW_WBRWID_FN": {"type": "text","analyzer": "ik_max_word","fields": {"keyword": {"type": "keyword"}}},"WEXI_DATETIMEKS": {"type": "long"},"WEXI_DATETIMEWC": {"type": "long"}}
}

将索引赋值到新的索引（导数据）

POST /_reindex?wait_for_completion=false
{"source": {"index": "jsxd_weixiudcb"},"dest": {"index": "jsxd_weixiudcb_20221019"}
}

等数据导完

给索引新增/删除别名

POST /_aliases
{"actions": [{"add": {"index": "jsxd_weixiudcb_new","alias": "jsxd_weixiudcb_20220920"}},{"remove": {"index": "jsxd_weixiudcb","alias": "jsxd_weixiudcb_20220920"}}]
}

删除旧索引（要等数据导完）

DELETE /jsxd_weixiudcb