Home | About | Sematext search-lucene.com search-hadoop.com
 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
Fatih Haltas 2013-07-25, 10:58
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