Skip to content

Error in Discover when searching using a rollup data view #213629

@lukasolson

Description

@lukasolson

Kibana version: 8.11.4+

Elasticsearch version: 8.11.4+

Describe the bug:

Attempting to load Discover with a rollup data view selected results in an error.

Steps to reproduce:

  1. Create a rollup job (see [Data View Editor] Add rollup deprecation warning #187505 for instructions)
  2. Create a rollup data view for the rollup index
  3. Load Discover

Expected behavior:

In 8.10 and below, the search results are displayed.

In 8.11+, the following error message is shown:

Field [__anonymous_] of type [boolean] does not support custom formats

Screenshots (if relevant):

Image

Any additional context:

Here's the request:

{
  "sort": [
    {
      "timestamp": {
        "order": "desc",
        "format": "strict_date_optional_time",
        "unmapped_type": "boolean"
      }
    },
    {
      "_doc": {
        "order": "desc",
        "unmapped_type": "boolean"
      }
    }
  ],
  "track_total_hits": false,
  "fields": [
    {
      "field": "*",
      "include_unmapped": "true"
    },
    {
      "field": "timestamp",
      "format": "strict_date_optional_time"
    }
  ],
  "size": 500,
  "version": true,
  "script_fields": {},
  "stored_fields": [
    "*"
  ],
  "runtime_mappings": {},
  "_source": false,
  "query": {
    "bool": {
      "must": [],
      "filter": [],
      "should": [],
      "must_not": []
    }
  },
  "highlight": {
    "pre_tags": [
      "@kibana-highlighted-field@"
    ],
    "post_tags": [
      "@/kibana-highlighted-field@"
    ],
    "fields": {
      "*": {}
    },
    "fragment_size": 2147483647
  }
}

And the response:

{
  "attributes": {
    "type": "status_exception",
    "reason": "error while executing search",
    "caused_by": {
      "type": "search_phase_execution_exception",
      "reason": "all shards failed",
      "phase": "query",
      "grouped": true,
      "failed_shards": [
        {
          "shard": 0,
          "index": "rollup-monitoring",
          "node": "co2slnP7SgOyV-6Z-513MQ",
          "reason": {
            "type": "illegal_argument_exception",
            "reason": "Field [__anonymous_] of type [boolean] does not support custom formats"
          }
        }
      ],
      "caused_by": {
        "type": "illegal_argument_exception",
        "reason": "Field [__anonymous_] of type [boolean] does not support custom formats",
        "caused_by": {
          "type": "illegal_argument_exception",
          "reason": "Field [__anonymous_] of type [boolean] does not support custom formats"
        }
      }
    }
  },
  "err": {
    "message": "status_exception\n\tCaused by:\n\t\tsearch_phase_execution_exception: all shards failed",
    "statusCode": 400,
    "attributes": {
      "type": "status_exception",
      "reason": "error while executing search",
      "caused_by": {
        "type": "search_phase_execution_exception",
        "reason": "all shards failed",
        "phase": "query",
        "grouped": true,
        "failed_shards": [
          {
            "shard": 0,
            "index": "rollup-monitoring",
            "node": "co2slnP7SgOyV-6Z-513MQ",
            "reason": {
              "type": "illegal_argument_exception",
              "reason": "Field [__anonymous_] of type [boolean] does not support custom formats"
            }
          }
        ],
        "caused_by": {
          "type": "illegal_argument_exception",
          "reason": "Field [__anonymous_] of type [boolean] does not support custom formats",
          "caused_by": {
            "type": "illegal_argument_exception",
            "reason": "Field [__anonymous_] of type [boolean] does not support custom formats"
          }
        }
      }
    }
  }
}

Metadata

Metadata

Assignees

Labels

Feature:Data ViewsData Views code and UI - index patterns before 8.0Feature:RollupsFeature:SearchQuerying infrastructure in KibanaTeam:DataDiscoveryDiscover, search (data plugin and KQL), data views, saved searches. For ES|QL, use Team:ES|QL. t//bugFixes for quality problems that affect the customer experienceimpact:mediumAddressing this issue will have a medium level of impact on the quality/strength of our product.loe:needs-researchThis issue requires some research before it can be worked on or estimated

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions