如何将此字段从字符串转换为Double

Question

我需要将我的Elasticsearch集群中的此字段从字符串手动转换为double。我想把字段保持为字符串，我不能注入任何新字段。我的代码得到这个错误:[Unknown key for a START_OBJECT in [sum].]。我正在Kibana的dev_tools中测试我的查询。有人能帮忙吗?

GET /csv_metrics_index/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"object_key": "example.csv"
}
},
{
"match": {
"event_path":  "path/to/example.csv"
}
}
]
}
},
"sum": {
"script": "Double.parseDouble(doc['stat_value'].value)"
}
}

Answer 1

我想你忘了添加aggs

GET /csv_metrics_index/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"object_key": "example.csv"
}
},
{
"match": {
"event_path":  "path/to/example.csv"
}
}
]
}
},
"aggs": {
"statCount": {
"sum": {
"script": "Double.parseDouble(doc['stat_value'].value)"
}
}
}
}