python 操作 Elasticsearch(三)
from elasticsearch import Elasticsearch
from elasticsearch import helpers
es = Elasticsearch(['你的elasticsearch的外网连接'], http_auth=('数据库的用户名', '密码'),timeout=60,max_retries=10,retry_on_timeout=True)
1、删除demo索引中的tags列的所有数据
# 删除整个tags列
from elasticsearch import Elasticsearch
es = Elasticsearch(['http://172.16.129.128:29200'],
http_auth=('elastic', 'aihub@2020'),
timeout=600,
max_retries=10,
retry_on_timeout=True)
delete_BODY = {
"script": "ctx._source.remove(\"tags\")",
"query": {
"exists": {
"field": "tags"
}
}
}
es.update_by_query(index='demo',body=delete_BODY)
2、删除demo索引的全部数据
# 删除demo索引中的所有数据
delete_all = {
"query": {
"match_all": {}
}
}
es.delete_by_query(index='demo',doc_type = '_doc',body=delete_all)
3、删除索引的行数据
删除demo索引中Id列含有:1 的那一行数据
id = 1
delete_row = {
"query": {
"match": {
"Id": id
}
}
}
es.delete_by_query(index='demo',doc_type = '_doc',body=delete_row)