Column with date datatype and format specification in Elasticsearch get skipped

Trino
1

Hello Team,
We are trying to read few columns from ELK index and we are able to read columns with datatype int, bigint, long, varchar, date (default ELK format) properly, but while selecting column with datatype date and format specified in ELK mapping information index like below, it returns error like. Column ‘createdon’ cannot be resolved.

“createdOn” : {
“type” : “date”,
“format” : “dd-MM-yyyy HH:mm:ss”
},

While we tried to perform desc on the respective index via trino using cataloges.schema.indexname, it shows all columns except the column with timestamp specified format. Let me know possible way to read this column via Trino

2

This is not supported - see Elasticsearch connector — Trino 422 Documentation and Elasticsearch connector — Trino 422 Documentation

You could potentially read the data as string and parse it in your SQL statements.