Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - Sqoop netezza import error - "SQLException in nextKeyValue"


Copy link to this message
-
Sqoop netezza import error - "SQLException in nextKeyValue"
Nitin kak 2012-09-25, 20:42
Hi Guys,

    I am using sqoop command to import data from Netezza. Whenever I use
the "sqoop import" command without "--direct" it gives me the
error "SQLException in nextKeyValue".

Here is command(without direct):  *sqoop import --table table1 --connect
jdbc:netezza://<ip>/schema --driver org.netezza.Driver --hive-table
hive_table1 --username '<username>' --password '<password>' --hive-import *
*Works fine if "--direct" is included*

Stacktrace:
java.io.IOException: SQLException in nextKeyValue
        at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:265)
        at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
        at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
        at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
        at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:183)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
        at org.apache.hadoop.mapred.Child.main(Child.java:264)

Thanks in advance,
Nitin Kak
+
Jarek Jarcec Cecho 2012-09-26, 06:44