Converting JSON timestamp in Drill.
I have a Hive table which was created as a JSON file.
In the JSON file I have a column called "collection_time" which has bellow values:
How do I read these values as TIMESTAMP in Drill?
I want to create Drill views on top of this JSON files with appropriate data type.