Elastic search transform not working on nested fields

Elastic Stack Elasticsearch
1

Hi,
I have an index which looks like below

"properties": {
  "employee_id": {
    "type": "long"
  },
  "employee_details": {
    "type": "nested",
    "dynamic": "false",
    "properties": {
      "city": {
        "type": "keyword"
      },
      "employee_type": {
        "type": "keyword"
      }
    }
  }
}

I want to summarize the data from source index, summarize it and then create a new index. I understand that I can create transforms and below is how I am trying to create it.

{
  "source": {
    "index": "employee_index"
  },
  "pivot": {
    "group_by": {
      "id": {
        "nested": {
          "path": "employee_details"
        },
        "terms": {
          "field": "employee_details.city"
        }
      }
    },
    "aggregations": {
      "count_id": {
        "nested": {
          "path": "employee_details"
        },
        "value_count": {
          "field": "employee_details.employee_type"
        }
      }
    }
  },
  "dest": {
    "index": "employee_summary"
  },
  "frequency": "1d"
}

When I try to create a transform, I am getting following error

No enum constant org.elasticsearch.xpack.core.transform.transforms.pivot.SingleGroupSource.Type.NESTED

What does this mean?
Is transform not supported for the nested fields?

2

Transform does not support a group_by of type nested. This:

"pivot": {
    "group_by": {
      "id": {
        "nested": {
          "path": "employee_details"
        },

is not possible. Neither it is possible to use a nested aggregation as part of aggregations. You can find the list of supported aggregations in the docs.

3

Thank you for the info !

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.