Cloudera Community
Neeraj
user rank
Explorer
My Accepted Solutions
Show All

Re: Value in Date Column is NULL in HIVE

by Explorer in Support Questions
‎09-05-2015 08:44 AM
‎09-05-2015 08:44 AM
I Have found the solution.   I have converted the string in desired format (which hive requires (yyyy-MM-dd HH:mm:ss)) and then imported that formatted string into HIVE and it works pretty well.   Regards, Neeraj   ... View more

Value in Date Column is NULL in HIVE

by Explorer in Support Questions
‎09-04-2015 05:51 AM
‎09-04-2015 05:51 AM
Hi,         I have date column in PIG. I have converted the date column from string to Date using "ToDate" function in PIG. However, when I am trying to import that data in HIVE, I am getting NULL values. I have checked the date format in PIG and HIVE they are different.   So is their any way to make the date format same in PIG and HIVE. Or what could be the other way to store the Date into HIVE.   My date format in text file is : 2014 10 15 17:10:13.728   Let me know if any further information is required from my side.   Regards, Neeraj ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎10-30-2015 02:28 PM
Community Statistics
Member Since ‎09-04-2015 05:46 AM
Last Visited ‎10-30-2015 02:28 PM
Posts 4
Kudos received 2