Unable to create ES mapping date field

Question

I have a table, one column is a UDT

CREATE TYPE baseinfo (
    head_commission_nr text,
    internal_source text,
    internal_changed date,
);

ES mapping for that part of the table:

    "internal_changed": {
      "type": "date",
      "cql_collection": "singleton"
    }

Indexing fails with:

"type": "mapper_parsing_exception", "reason": "Failed to execute query:null : Field "internal_changed" with type date does not match type timestamp", "caused_by": { "type": "invalid_request_exception", "reason": "Field "internal_changed" with type date does not match type timestamp" }

What am I doing wrong?

Answer 1

delete the indices have been created and change the mapping like this:

 "internal_changed": {
      "type": "date",
      "format": "yyyy-MM-dd ",
      "cql_collection": "singleton"
    }