Sqoop export inaccurate data

["Chagarlamudi, Prasanth" <pr...@epsilon.com>]

Hello,
I am trying to export data from HDFS to Oracle.
Copying a small snippet of the code..

MLinkConfig mLinkConfig = mLink_jdbc.getConnectorLinkConfig();
        mLinkConfig.getStringInput("linkConfig.connectionString").setValue("jdbc:oracle:thin:@//test.server.com:1521/test.myserver.com");
        mLinkConfig.getStringInput("linkConfig.jdbcDriver").setValue("oracle.jdbc.driver.OracleDriver");
        mLinkConfig.getStringInput("linkConfig.username").setValue("USERNAME");
        mLinkConfig.getStringInput("linkConfig.password").setValue("PASSWORD");

MFromConfig mFromConfig = job.getFromJobConfig();
        mFromConfig.getStringInput("fromJobConfig.inputDirectory").setValue("/data/prasanth/data_contractors");

MToConfig toJobConfig = job.getToJobConfig();
        toJobConfig.getStringInput("toJobConfig.schemaName").setValue("SCHEMA NAME");
        toJobConfig.getStringInput("toJobConfig.tableName").setValue("TABLE NAME");

MDriverConfig driverConfig = job.getDriverConfig();
        driverConfig.getIntegerInput("throttlingConfig.numExtractors").setValue(4);

Export job ran fine, but I see the data was not accurate. I have a table with three columns first_name, last_name, salary.

Data in HDFS file:
Steve,Jobs,1234
Bill,Gates,5678

Data exported to my Oracle table:
teve,ob,23
il,ate,67

Characters highlighter in red are missing. Any suggestions?



Thanks as always

Prasanth Chagarlamudi


________________________________

This e-mail and files transmitted with it are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you are not one of the named recipient(s) or otherwise have reason to believe that you received this message in error, please immediately notify sender by e-mail, and destroy the original message. Thank You.