Hi Brent, Sqoop currently does not map the NVARCHAR datatype via the generic JDBC connector. I've filed https://issues.apache.org/jira/browse/SQOOP-323 for Sqoop to support NVARCHAR.
In the meantime, you can use the Netezza connector (https://ccp.cloudera.com/display/con/Cloudera+Connector+for+Netezza), which does support NVARCHAR. Regards, Kate On Fri, Aug 26, 2011 at 8:36 AM, Black, Brent <brent.bl...@disney.com> wrote: > 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.bl...@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 > >
