Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.4.0
-
Fix Version/s: None
-
Component/s: export
-
Labels:None
Description
When exporting data from hadoop to oracle i have:
011-07-06 16:17:22,385 WARN org.apache.hadoop.mapred.Child: Error
running child
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(BigDecimal.java:459)
at java.math.BigDecimal.<init>(BigDecimal.java:728)
I solved this problem changing source code:
File: java/com/cloudera/sqoop/manager/OracleManager.java,
Line: 83
Replace SQL QUERY from:
public static final String QUERY_COLUMNS_FOR_TABLE =
"SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ?";
to:
public static final String QUERY_COLUMNS_FOR_TABLE =
"SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER
ORDER BY COLUMN_ID";