AnsweredAssumed Answered

Converting JSON timestamp in Drill.

Question asked by kamal on Apr 30, 2018
Latest reply on May 2, 2018 by maprcommunity

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.