Details
Description
File "sqoop/src/java/org/apache/sqoop/manager/OracleManager.java"
Line #93 contains the following definition:
public static final String QUERY_COLUMNS_FOR_TABLE =
"SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE "
+ "OWNER = ? AND TABLE_NAME = ?";
This query is used to retrieve a set of columns for performing of data
export to an Oracle database. Unfortunately, result of this query is
unpredictable as the database does not guarantee ordering of query's
output rows unless "ORDER BY" was specified. With older versions of
Oracle DB (I remember seeing somewhere that Sqoop was tested with
Oracle 9g) it was magically working, but with the latest 12g dev it
does not. The query returns columns in inverse order and Sqoop
generates bogus java code which crashes and burns trying to insert
data into the database .