ES多字段求和,生成一个新字段
上代码:
想要liked_count和share_count字段求和
GET post_douyin/_search
{
“script_fields”: {
“sum_count”: {
“script”: {
“source”: “if(doc[‘liked_count’].value >0 && doc[‘share_count’].value >0 ){doc[‘liked_count’].value + doc[‘share_count’].value }”,
“lang”: “painless”
}
}
}
}
注意:必须这两个字段的值不为空,所以加了if判断。不然会报错
上面是初级版的,下面更新一个终极版的
{
“script_fields”: {
“interaction”: {
“script”: {
“lang”: “painless”,
“source”: “”"
long l = 0;
long c = 0;
if (doc[‘liked_count’].size()!=0) {
l = doc[‘liked_count’].value
}
if (doc[‘comment_count’].size()!=0) {
c = doc[‘comment_count’].value
}
return l + c;
“”"
}
}
}
}