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 Plain View
Sqoop >> mail # user >> ERROR orm.ClassWriter: No db getter method for Java type


+
Fatih Haltas 2013-07-24, 11:32
+
Jarek Jarcec Cecho 2013-07-24, 15:02
Copy link to this message
-
Re: ERROR orm.ClassWriter: No db getter method for Java type
Hi Jarek,

Here is the output with --verbose option.

[hadoop@ADUAE042-LAP-V ~]$ sqoop import-all-tables --verbose
--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 /IndiaMachine_InferDB/InterestingIPs --direct --connect
jdbc:postgresql://ipAddress:5432/IITNYUDB --username itnyu --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/25 14:15:09 DEBUG tool.BaseSqoopTool: Enabled debug logging.
13/07/25 14:15:09 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
13/07/25 14:15:09 DEBUG manager.DefaultManagerFactory: Trying with scheme:
jdbc:postgresql:
13/07/25 14:15:09 INFO manager.SqlManager: Using default fetchSize of 1000
13/07/25 14:15:09 INFO manager.PostgresqlManager: We will use schema
InterestingIPs
13/07/25 14:15:09 DEBUG sqoop.ConnFactory: Instantiated ConnManager
org.apache.sqoop.manager.DirectPostgresqlManager@676bd8ea
13/07/25 14:15:09 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
13/07/25 14:15:11 INFO tool.CodeGenTool: Beginning code generation
13/07/25 14:15:11 DEBUG manager.SqlManager: Using fetchSize for next query:
1000
13/07/25 14:15:11 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM "InterestingIPs"."2013-07-18" AS t LIMIT 1
13/07/25 14:15:14 DEBUG orm.ClassWriter: selected columns:
13/07/25 14:15:14 DEBUG orm.ClassWriter:   ip
13/07/25 14:15:14 DEBUG orm.ClassWriter:   names
13/07/25 14:15:14 DEBUG orm.ClassWriter:   steppingStoneScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   muleContactScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   infectedContactScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   evasiveTrafficScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   darkSpaceSourceScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   darkSpaceTargetScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   nonDNSTrafficScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   rebootScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   malwareSourceScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   malwareTargetScore
13/07/25 14:15:14 DEBUG orm.ClassWriter:   minVirulence
13/07/25 14:15:14 DEBUG orm.ClassWriter:   maxVirulence
13/07/25 14:15:14 DEBUG orm.ClassWriter:   currentVirulence
13/07/25 14:15:14 DEBUG orm.ClassWriter:   rank
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to
String
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
steppingStoneScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
muleContactScore to
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
infectedContactScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
evasiveTrafficScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
darkSpaceSourceScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
darkSpaceTargetScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
nonDNSTrafficScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
rebootScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
malwareSourceScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
malwareTargetScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to
Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to
String
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
steppingStoneScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
muleContactScore to
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
infectedContactScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
evasiveTrafficScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
darkSpaceSourceScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
darkSpaceTargetScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
nonDNSTrafficScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
rebootScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
malwareSourceScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
malwareTargetScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column rank to
Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column ip to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column names to
String
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
steppingStoneScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
muleContactScore to
13/07/25 14:15:14 ERROR orm.ClassWriter: Could not infer JdbcWritableBridge
getter for Java type
13/07/25 14:15:14 ERROR orm.ClassWriter: No db getter method for Java type
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
infectedContactScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overriding type of column
evasiveTrafficScore to Long
13/07/25 14:15:14 INFO orm.ClassWriter: Overr
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