question Re: Load data to external table using date field as partitioned in Archives of Support Questions (Read Only)

Load data to external table using date field as partitioned

das_dineshk — Fri, 09 Jun 2017 17:41:33 GMT

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.

ssahi — Sat, 10 Jun 2017 05:29:29 GMT

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.

sagar_girish — Sat, 10 Jun 2017 16:48:05 GMT

Perfect answer!