Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Load data to external table using date field as partitioned

avatar
Expert Contributor

I have data having date fields "yyyymmddhhmmss".

I would like to load this data to extrnal table but with a formatted date field "yyyymmdd" using hive.

can someone help please.

1 ACCEPTED SOLUTION

avatar
Guru

hi @Dinesh Das

If you load your data as a String initially into a staging table, you can use the unix_timestamp() function to get easy date formatting:

select from_unixtime(unix_timestamp(origDateColumn ,'yyyyMMddhhmmss'), 'yyyyMMdd') from StagingTable

Alternatively, you can create a custom UDF to handle it for you.

As always, if you find this post useful, please "Accept" the answer.

View solution in original post

2 REPLIES 2

avatar
Guru

hi @Dinesh Das

If you load your data as a String initially into a staging table, you can use the unix_timestamp() function to get easy date formatting:

select from_unixtime(unix_timestamp(origDateColumn ,'yyyyMMddhhmmss'), 'yyyyMMdd') from StagingTable

Alternatively, you can create a custom UDF to handle it for you.

As always, if you find this post useful, please "Accept" the answer.

avatar
Rising Star

Perfect answer!