Support Questions
Find answers, ask questions, and share your expertise

How to import Netezza table with blob/clob columns?


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