we're using the below import command to import table's data from Oracle 9i database using "ojdbc6.jar". We get empty result although the original table contains data of the type VARCHAR2(10).
sqoop import --driver oracle.jdbc.driver.OracleDriver --connect \
"jdbc:oracle:thin:@IP_ADDRESS:PORT:SERVICE" --username "USER_NAME" \
--password "PASSWORD" --target-dir "/sqoop_import/DATA/" --query \
'select SUBNO from SCHEMA.TABLE where $CONDITIONS' --split-by\
"TYPE_ID" --boundary-query 'select min(TYPE_ID),max(TYPE_ID) from\
SCHEMA.TABLE' --map-column-java SUBNO=String
we have tried [with no use]:
hive import with and without --map-column-hive --columns instead of specifying the query using different ojdbc version
... View more
