Value in Date Column is NULL in HIVE

[#1]

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

[#2 · Accepted solution]

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

[#3]

Congratulations on finding the solution. Thank you for sharing it in case others run across the same issue. 🙂