elasticsearch - 如何在elasticsearch脚本中添加2个值？

Question

我正在尝试通过添加2个字段rows_processed和src_s_rows来创建tgt_s_rows字段，但是有些方法不起作用，它总是给我0。即使当我使用"script": "(doc['src_s_rows'].value)"而不是"script": "(doc['src_s_rows'].value+doc['tgt_s_rows'].value)"时，它仍然给我0。

我想念的是什么，请帮忙。

GET run_hist/task_hist/_search
{
   "fields": [
      "THROUGHPUT_ROWS_PER_SEC",
      "start_time",
      "end_time",
      "src_s_rows",
      "tgt_s_rows"
   ],
   "query": {
      "filtered": {
         "filter": {
            "bool": {
               "must": [
                  {
                     "term": {
                        "_id": "249885850"
                     }
                  }
               ]
            }
         }
      }
   },
   "filter": {
      "script": {
         "script": "(doc['end_time'].value-doc['start_time'].value)>minutes*1",
         "params": {
            "minutes": 60000
         }
      }
   },
   "script_fields": {
      "total_time_taken": {
         "script": "(doc['end_time'].value-doc['start_time'].value)/1000"
      },
      "rows_processed": {
         "script": "(doc['src_s_rows'].value+doc['tgt_s_rows'].value)"
      }
   },
   "size": 10000
}

屏幕截图如下

Answer 1

使用_source.src_s_rows.value代替doc['src_s_rows'].value
试试这个

"script": "(_source.src_s_rows.value+_source.tgt_s_rows.value)"