David Robson created SQOOP-1486:
-----------------------------------
Summary: Oracle direct connector should use Sqoop merge syntax
Key: SQOOP-1486
URL: https://issues.apache.org/jira/browse/SQOOP-1486
Project: Sqoop
Issue Type: Bug
Components: connectors/oracle
Affects Versions: 1.4.5
Reporter: David Robson
>From [~gwenshap]
when running the following sqoop command with OraOop installed:
sqoop export --table mytable --update-key COL1, COL2, COL3 --export-dir
/user/hive/warehouse/mytable --connect "jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521)))(SDU
= 5844)(CONNECT_DATA = (ORACLE_SID = oracle)))" --username scott --password
tiger
The job runs succesfully and reports:
INFO mapreduce.ExportJobBase: Exported 54 records.
However not rows actually appears in the table. It appears that Oraoop loads
the data into staging tables, but not into the user table.
When using the Oraoop specific syntax, the export succeeds and we see data in
the user table:
sqoop export -Doraoop.export.merge=true
-Doraoop.update.key.extra.columns="COL2" --table mytable --export-dir
/user/hive/warehouse/mytable --connect "jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521)))(SDU
= 5844)(CONNECT_DATA = (ORACLE_SID = oracle)))" --username scott --password
tiger --input-fields-terminated-by ',' --update-key COL1
Expected behavior:
Either make sure the usual Sqoop syntax works with Oraoop, or issue a suitable
error message
--
This message was sent by Atlassian JIRA
(v6.2#6252)
