How to transfer data from Netezza to HDFS using Apache Sqoop

Question

I am using Sqoop and to transfer the data from Netezza to HDFS. I have created a job with below configuration

--direct --connect jdbc:netezza://url/database_name --username uname --password pass –table t_name --split-by primary_key --target-dir hdfs_dir -m 8

When I am executing the job, the map task is getting 100% executed and reduce job is not getting executed. I am job is not completing and I am also not getting any error.

What can be the issue?

Answer 1

Remove the --direct option. It gives issue in case of special characters (such as ‘,’) with Netezza.