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

Switch to Threaded View
Sqoop, mail # user - ERROR orm.ClassWriter: No db getter method for Java type


Copy link to this message
-
Re: ERROR orm.ClassWriter: No db getter method for Java type
Jarek Jarcec Cecho 2013-07-24, 15:02
Hi Fatih,
would be helpful if you could rerun the Sqoop command with parameter --verbose and share the output with us.

Jarcec

On Wed, Jul 24, 2013 at 03:32:07PM +0400, Fatih Haltas wrote:
> Hi everyone,
>
> I am trying to import postgre data to hadoop, for other all tables there is
> no problem. But for one table, I am getting the error below.
>
> What is the reason for it? What should i do?
>
> Thanks.
>
> [hadoop@ADUAE042-LAP-V ~]$ sqoop import-all-tables --map-column-java
> ip=Long,names=String,steppingStoneScore=Long,muleContactScore==Long,infectedContactScore=Long,evasiveTrafficScore=Long,darkSpaceSourceScore=Long,darkSpaceTargetScore=Long,nonDNSTrafficScore=Long,rebootScore=Long,malwareSourceScore=Long,malwareTargetScore=Long,rank=Long
> --warehouse-dir /IndDB/InterestingIPs --direct --connect
> jdbc:postgresql://IP-Adress:5432/Database --username it --password XXX  --
> --schema InterestingIPs
>
>
> Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> Please set $HBASE_HOME to the root of your HBase installation.
> Warning: $HADOOP_HOME is deprecated.
>
> 13/07/24 14:43:53 WARN tool.BaseSqoopTool: Setting your password on the
> command-line is insecure. Consider using -P instead.
> 13/07/24 14:43:53 INFO manager.SqlManager: Using default fetchSize of 1000
> 13/07/24 14:43:53 INFO manager.PostgresqlManager: We will use schema
> InterestingIPs
> 13/07/24 14:43:55 INFO tool.CodeGenTool: Beginning code generation
> 13/07/24 14:43:55 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM "InterestingIPs"."2013-07-18" AS t LIMIT 1
> 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge
> getter for Java type
> 13/07/24 14:43:58 ERROR orm.ClassWriter: No db getter method for Java type
> 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge
> getter for Java type
> 13/07/24 14:43:58 ERROR orm.ClassWriter: Could not infer PreparedStatement
> setter for Java type
> 13/07/24 14:43:58 ERROR orm.ClassWriter: No db setter method for Java type
> 13/07/24 14:43:58 ERROR orm.ClassWriter: No ResultSet method for Java type
> 13/07/24 14:43:58 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.IllegalArgumentException: No ResultSet method for Java type
> java.lang.IllegalArgumentException: No ResultSet method for Java type
> at org.apache.sqoop.orm.ClassWriter.rpcSetterForType(ClassWriter.java:457)
> at
> org.apache.sqoop.orm.ClassWriter.rpcSetterForMaybeNull(ClassWriter.java:472)
> at
> org.apache.sqoop.orm.ClassWriter.generateHadoopWrite(ClassWriter.java:1037)
> at
> org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1340)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1153)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
> at
> org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:64)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)