Shyam created SQOOP-1342:
----------------------------
Summary: Sqoop Import Job Hangs when the Netezza direct option is
used !
Key: SQOOP-1342
URL: https://issues.apache.org/jira/browse/SQOOP-1342
Project: Sqoop
Issue Type: Test
Components: sqoop2-test
Affects Versions: 1.4.4
Environment: sqoop-1.4.4.2.0.6.1-102.jar, nzjdbc3.jar
Reporter: Shyam
Hi, The SQOOP Import job hangs when used with the Netezza --direct option. It
runs fine without the "--direct" option.
Here is the SQOOP Job:
--------------------------------------------------------------------------------------------
/sqoop import --direct --connect
"jdbc:netezza://netezza-1v:5480/DTSTTAPPL;schema=ADMIN;" --table PROCEDURE
--username nzuser --P --target-dir /user/DTSTTAPPL/ --verbose -m 4
--------------------------------------------------------------------------------------------
The job hangs after saying that map 100% reduce 0%. I had to do a mapred job
-kill.
In looking at the Ambari, it looks like it read only 4 records. Basically 1 per
mapper.
In Looking at the YARN logs, I found the below error.
2014-06-24 22:31:26,064 ERROR [Thread-15]
org.apache.sqoop.mapreduce.db.netezza.NetezzaJDBCStatementRunner: Unable to
execute external table export
org.netezza.error.NzSQLException: ERROR: found delim ',' in a data field,
specify escapeChar '\' option in the external table definition
There is only 1 Date Timestamp field in the table I'm trying to import and I
did not see a ','. Am i supposed to create an external table in Netezza before
hand. My assumption was using the "--direct" option will take care of creating
the external table in Netezza and dropping it later.
Any help with this is appreciated.
- Venkat.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
