04-11-2019 07:13 AM
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