[
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)
