Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB