sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Villar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-3114) Error exporting large table to Oracle and Append Values Hint
Date Wed, 06 Sep 2017 09:05:00 GMT

     [ 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/XXXXXX@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)

Mime
View raw message