sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Black, Brent" <Brent.Bl...@disney.com>
Subject Sqoop Netezza connection
Date Fri, 26 Aug 2011 15:36:00 GMT
Has anybody seen the error below in Sqoop when importing data from a Netezza database?   The
column it gave the error for has an NVARCHAR data type and it seems to happen for any table
with an NVARCHAR data type.

sqoop import --driver org.netezza.Driver --connect 'jdbc:netezza://server/db' --username user
-P --table table1 --target-dir /data/table1

11/08/26 08:29:32 ERROR orm.ClassWriter: No Java type for SQL type -9 for column COLUMN_NAME
11/08/26 08:29:32 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
        at com.cloudera.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:867)
        at com.cloudera.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:892)
        at com.cloudera.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:966)
        at com.cloudera.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1275)
        at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1085)
        at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)




Brent Black, CISA, CSFA
Staff Data Warehouse Engineer, Data Services
Disney Technology Solutions and Services (DTSS)
925 Fourth Avenue, Suite 1600 | Seattle, WA 98104
*: 206.664.4472 | È:  206.618.0720
*: brent.black@disney.com<mailto:brent.black@disney.com>

"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch
of genius -- and a lot of courage -- to move in the opposite direction."
Albert Einstein


Mime
View raw message