Hive cannot read @timestamp from ES which format is unix time

[stongline]

hive require timestamp format must be yyyy-mm-dd hh:mm:ss,how to read unix time ,please help me ,thanks

[duke8249]

ES @timestamp format is yyyy-mm-dd hh=mm:ss which matches hive perfectly. I have tried to read from ES and it works fine.

[costin]

@stongline @duke8249 Can you please provide more information. Potentially opening up a thread on the forum?

Thanks,