Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to import Netezza table with blob/clob columns?

How to import Netezza table with blob/clob columns?

Explorer

Hi.  Is there a best practices or good methodology for importing Netezza table with blob/clob fields?  I read about lob files and such but in our use case, we are doing a data migration and trying to import the entire table so no efficiency there.  I have also read about mapping the columns using map-column-java and map-column-hive (is string and BINARY the best formats?).

 

We are forced to use only 1 mapper by the client and it took 3 hours to import 2.5 GB.  This will not work for their bigger tables.

 

Thanks in advance

Don't have an account?
Coming from Hortonworks? Activate your account here