question Re: Value in Date Column is NULL in HIVE in Archives of Support Questions (Read Only)

Value in Date Column is NULL in HIVE

Neeraj — Fri, 16 Sep 2022 09:39:59 GMT

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

Neeraj — Sat, 05 Sep 2015 15:44:41 GMT

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

cjervis — Sun, 06 Sep 2015 13:12:15 GMT

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