请教一个计算平均差值的问题

试试可以采取其他形式？比如 先算平均值再减
假设recQuery在一个文档中唯一， docCreateTime 和 timeInstances.time的总数应该是一样的 。分别计算docCreateTime 和timeInstances.time的平均值效率更高
 

{

  "query": {

    "nested": {

      "path": "timeInstances",

      "query": {

        "term": {

          "timeInstances.tag": {

            "value": "recQuery"

          }

        }

      }

    }

  },

  "aggs": {

    "docCreateTime_avg":{

      "avg": {

        "field": "docCreateTime"

      }

    },

    "timeInstance_nested": {

      "nested": {

        "path": "timeInstances"

      },

      "aggs": {

        "recQuery_filter": {

          "filter": {

              "term": {

                "timeInstances.tag": {

                  "value": "recQuery"

                }

              }

          },

          "aggs": {

            "time_avg": {

              "avg": {

                "field": "timeInstances.time"

              }

            }

          }

        }

      }

    }

  }

}

 

我用下面的语句，报错A document doesn't have a value for a field! Use doc[<field>].size()==0 to check if a document is missing a field!，是在nested的上下文里面拿不到docCreateTime的值

{

    "aggs": { 

        "nested_time_instances": { 

            "nested": { "path": "timeInstances" }, 

            "aggs": { 

                "avg_time_difference": { 

                "avg": { 

                    "script": {

                        "source": "doc['timeInstances.time'].getValue().getMillis()-doc['docCreateTime'].getValue().getMillis()"

                    }

                } 

            } 

        } 

    } 

}

印象里ES 的取值方式不支持访问nested的，可以试试object或者直接把几个时间冗余在第一层