sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "heshan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3103) sqoop2 export data from hdfs to rmdbs oracle
Date Thu, 07 Sep 2017 05:39:00 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-3103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16156504#comment-16156504
] 

heshan commented on SQOOP-3103:
-------------------------------

I also meet this problem. In my case, the target table has 9 columns, but i only want to export
7 columns; but the jdbc's schema will add all columns, because the sql is "select * from table
where 1 = 0 ";  

> sqoop2 export data from hdfs to rmdbs oracle
> --------------------------------------------
>
>                 Key: SQOOP-3103
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3103
>             Project: Sqoop
>          Issue Type: Bug
>         Environment: client version:
>   Sqoop 1.99.5-cdh5.5.1 source revision 822300689867f48fad83dbd6ee668a1310a7ea0f 
>   Compiled by jenkins on Wed Dec  2 10:22:47 PST 2015
> server version:
>   Sqoop 1.99.5-cdh5.5.1 source revision 822300689867f48fad83dbd6ee668a1310a7ea0f 
>   Compiled by jenkins on Wed Dec  2 10:22:47 PST 2015
> API versions:
>   [v1]
>            Reporter: sjfeng
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> i use sqoop2 to export data from hdfs to oracle 
> the link has been created , and the target table has been created
> the table i want to export has 2 columns 
> one's name is "PACKAGEID" and type is STRING
> another's name is "PACKAGENAME" and also STRING 
> and after i start the job 
> the job throw some exception and says:
> org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot write to the data writer
> .........
> org.apache.sqoop.common.SqoopException: INTERMEDIATE_DATA_FORMAT_0001:Wrong number of
columns. - The data [Ljava.lang.String;@3bc5578b has the wrong number of fields. 
> so can anyone help me to solve the problem ????



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message