Support Questions

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

converting mainframe packed decimal Amount fields for Hive

avatar
Super Collaborator

Hi,

We have mainframe files being FTP'ed to HDFS and needs to be loaded into Hive.

The FTP'ed files have many columns in packed decimal (comp-3)

Is there any build in function to convert the gibberish values to Hive float or string?

1 ACCEPTED SOLUTION
3 REPLIES 3

avatar
Master Mentor

avatar
Super Collaborator

avatar