Reply
Highlighted
Explorer
Posts: 10
Registered: ‎06-25-2018

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