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:

2017-04-26T11:13:15.000Z 

2017-04-29T15:08:07.000Z

 

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. 

Outcomes