https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146528#M19966 <P>Hi, </P><P>We have mainframe files being FTP'ed to HDFS and needs to be loaded into Hive. </P><P>The FTP'ed files have many columns in packed decimal (comp-3)</P><P>Is there any build in function to convert the gibberish values to Hive float or string?</P> Thu, 18 Feb 2016 03:55:16 GMT PranayV 2016-02-18T03:55:16Z https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146528#M19966 <P>Hi, </P><P>We have mainframe files being FTP'ed to HDFS and needs to be loaded into Hive. </P><P>The FTP'ed files have many columns in packed decimal (comp-3)</P><P>Is there any build in function to convert the gibberish values to Hive float or string?</P> Thu, 18 Feb 2016 03:55:16 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146528#M19966 PranayV 2016-02-18T03:55:16Z https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146529#M19967 <A rel="user" href="https://community.cloudera.com/users/768/pvyas.html" nodeid="768">@Pranay Vyas</A><P> See if this helps <A href="http://stackoverflow.com/questions/15132071/how-to-pull-data-from-mainframe-to-hadoop" target="_blank">http://stackoverflow.com/questions/15132071/how-to-pull-data-from-mainframe-to-hadoop</A></P> Thu, 18 Feb 2016 04:18:33 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146529#M19967 nsabharwal 2016-02-18T04:18:33Z https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146530#M19968 <P>Thanks Neeraj. </P><P>Additional reference that I got from <A rel="user" href="https://community.cloudera.com/users/157/rgelhausen.html" nodeid="157">@Randy Gelhausen</A> - </P><P>see <A href="http://rbheemana.github.io/reality-of-sqoop-mainframe/">http://rbheemana.github.io/reality-of-sqoop-mainframe/</A> and <A href="http://rbheemana.github.io/Cobol-to-Hive/">http://rbheemana.github.io/Cobol-to-Hive/</A></P> Thu, 18 Feb 2016 08:34:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146530#M19968 PranayV 2016-02-18T08:34:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146531#M19969 <P>Use SyncSort </P><P><A href="http://www.syncsort.com/getattachment/989f1bac-4cda-4e70-bd97-41b4ff72fffc/Syncsort-Mainframe-to-Hadoop.aspx" target="_blank">http://www.syncsort.com/getattachment/989f1bac-4cda-4e70-bd97-41b4ff72fffc/Syncsort-Mainframe-to-Hadoop.aspx</A></P> Thu, 18 Feb 2016 13:42:00 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/converting-mainframe-packed-decimal-Amount-fields-for-Hive/m-p/146531#M19969 amcbarnett 2016-02-18T13:42:00Z