sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kate Ting <k...@cloudera.com>
Subject Re: Sqoop Netezza connection
Date Fri, 26 Aug 2011 18:37:26 GMT
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.Black@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.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