elasticsearch更新、删除api(带条件)

更新语句
1、通过restful api工具
a、app01_gtulog_eoi_20190101_20190101/log/_update_by_query 选择POST
b、批量设置ORDER_NUM为1
{
“script”: {
“lang”: “painless”,
“inline”: “ctx._source.ORDER_NUM=1”
}
}

2、通过curl，常用
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_update_by_query’ -d ‘{
“script”: {
“lang”: “painless”,
“inline”: “ctx._source.ORDER_NUM=1”
}
}’
如果需要带上查询条件的话，在url中带上条件如下：
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_update_by_query?q=CUST_CODE:180002285’ -d ‘{
“script”: {
“lang”: “painless”,
“inline”: “ctx._source.ORDER_NUM=1”
}
}’

多条件更新语句
updateBody = {
“query”: {
“bool”: {
“must”: [
{“term”: {“status”: “404”}},
{“term”: {“ip”: “10.2.1.63”}}

        ],
    }
},
"script": {
    "inline": "ctx._source.status = 200",
    "lang": "painless"
}

}
单条件删除语句
1、通过restful api工具
a、app01_gtulog_eoi_20190101_20190101/log/_delete_by_query 选择POST
b、{
“query”: {
“match”: {
“CUST_CODE”: “180002283”
}
}
}

2、通过curl，常用，建议使用url带参数形式更快
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_delete_by_query’ -d ‘{
“query”: {
“match”: {
“CUST_CODE”: “180002283”
}
}
}’

也可以直接在url的参数用使用q
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_delete_by_query?q=CUST_CODE:180002281’ -d ‘{}’

多条件删除语句
1、通过restful工具
a、app01_gtulog_eoi_20190101_20190101/log/_delete_by_query? 选择POST
b、{
“query”: {

    "bool": {

        "must": [

            {"wildcard": {"CUST_CODE": "180002289"}},

            {"wildcard": {"AREA": "广州"}}

        ]

    }

}

}

2、通过curl，常用
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_delete_by_query?’ -d ‘{
“query”: {
“bool”: {
“must”: [
{
“wildcard”: {
“CUST_CODE”: “180002289”
}
},
{
“wildcard”: {
“AREA”: “广州”
}
}
]
}
}
}’

3、通过update_by_query
curl -XPOST ‘http://192.168.21.120:9200/app01_gtulog_eoi_20190101_20190101/log/_update_by_query’ -d ‘{
“script”: {
“lang”: “painless”,
“inline”: “ctx._source.op=“delete””
}
}’

4、通过_update
kibana
GET /lib/user/4/_update
{
“script”:{
“source”:"ctx.op=ctx._source.age==params.count?‘delete’:‘none’ ",
“params”:{“count”:22
}
}
}
5、如果文档不存在执行初始化，如果存在执行XXX操作
GET /lib/user/4/_update
{
“script”:“ctx._source.age+=1”,
“upsert”:{
“a”:“xxxx”,
“b”:“xxxx”,
“c”:“xxxx”
}
}