Load data to external table using date field as partitioned

[#1]

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.

[#2 · Accepted solution]

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.

[#3]

Perfect answer!