[
https://issues.apache.org/jira/browse/SQOOP-3114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Antonio Villar updated SQOOP-3114:
----------------------------------
Description: (was: I'm using Oracle Data Connector for Oracle and
Hadoop to export data from Hive to Oracle, when i use the append_values hint i
get a Exception and mappers don't end.
This only happens when i export more than 18 columns of the original table.
The command that i'm using is:
{code}
sqoop export \
-D oraoop.partitioned=true -D
oraoop.template.table=ECI_ORA.CARTERA_XPAN_PROD_EXT_15 \
-D oraoop.oracle.append.values.hint.usage=ON \
-connect
jdbc:oracle:thin:ECI_ORA/xxx...@dpexr02-scan.lacaixa.es:1522/s_dpedwr_datapool.lacaixa.es
\
--num-mappers 4 \
--table ECI_ORA.AAA_1GIGA \
--columns
"TIINDI,CODINDI,EMPIMP,OFIIMP,EMPEMI,TICOGE,CONCSIG,CDCREP,EMPDIV,CODDIV,CODCARTE,EMPGEST,CDSEGCLI,TIPCAR,NUESTCE,TIDADCE,EQUIPO,CDSEGBAN,CODPROD,INDVALO101,INDVALO102,INDVALO103,INDVALO104,INDVALO105,INDVALO106,INDVALO107,INDVALO108,INDVALO109,INDVALO110,INDVALO111,INDVALO112,INDVALO113,INDVALO114,INDVALO115,INDVALO116,INDVALO117,INDVALO118,INDVALO119,INDVALO201,INDVALO202,INDVALO203,INDVALO204,INDVALO205,INDVALO206,INDVALO207,INDVALO208,INDVALO209,INDVALO210,INDVALO211,INDVALO212,INDVALO213,INDVALO214,INDVALO215,INDVALO216,INDVALO217,INDVALO218,INDVALO219,NIVEL"
\
--export-dir /apps/eciora/hive/l04_eciora.db/cartera_xpan_prod_ext_1 \
--input-fields-terminated-by '\01' \
--input-lines-terminated-by '\n' \
--input-null-non-string '\\\\N' \
--input-null-string '\\\\N' \
--direct
{code}
)
> Error exporting large table to Oracle and Append Values Hint
> -------------------------------------------------------------
>
> Key: SQOOP-3114
> URL: https://issues.apache.org/jira/browse/SQOOP-3114
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/oracle
> Affects Versions: 1.4.5
> Reporter: Antonio Villar
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
