I'm trying to access kafka topic using presto, one of the fields in my kafka message is a timestamp. The timestamp is stored as a long and I want it be recognised by presto as a timestamp.
What dataformat should I use for presto to recognise it as a timestamp in the default.test.json
file while structuring the message data?
....
{
"name": "timestamp",
"mapping": "time",
"type": "TIMESTAMP",
"dataFormat": "?????"
}
....