Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3103

sqoop2 export data from hdfs to rmdbs oracle

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      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 ????

        Activity

        Hide
        heshan04 heshan added a comment -

        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 ";

        Show
        heshan04 heshan added a comment - 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 ";

          People

          • Assignee:
            Unassigned
            Reporter:
            fish881225 sjfeng
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Time Tracking

              Estimated:
              Original Estimate - 48h
              48h
              Remaining:
              Remaining Estimate - 48h
              48h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development