How to transfer data from Netezza to HDFS using Apache Sqoop?

0 votes

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?

Apr 23, 2018 in Big Data Hadoop by Shubham
• 13,310 points
341 views

1 answer to this question.

0 votes
Remove the --direct option. It gives issue in case of special characters (such as ‘,’) with Netezza.
answered Apr 23, 2018 by kurt_cobain
• 9,260 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to securely transfer data from rdms to hdfs using sqoop?

Sqoop stores metadata in a repository and ...READ MORE

answered Dec 18, 2018 in Big Data Hadoop by Omkar
• 67,660 points
114 views
0 votes
1 answer
0 votes
1 answer

How can you transfer data from hive to HDFS ?

Hey, Data in Hive tables reside on HDFS, ...READ MORE

answered May 16 in Big Data Hadoop by Gitika
• 25,360 points
124 views
0 votes
1 answer

How to extract only few lines of data from HDFS?

Here also in case of Hadoop, it is ...READ MORE

answered May 2, 2018 in Big Data Hadoop by nitinrawat895
• 10,730 points
1,499 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,730 points
3,374 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,807 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,227 views
0 votes
1 answer
0 votes
1 answer

How to import data to HBase from SQL server?

You can easily import the data from ...READ MORE

answered Apr 20, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
377 views
0 votes
1 answer

How to learn Big Data and Ecosystem ?

First understand Big Data and challenges associated ...READ MORE

answered Mar 27, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
42 views