Thank you Abe for taking time to look into this.. My ORACLE table with four columns FIRST_NAME, LAST_NAME, SALARY, JOIN_DATE. This is the source table info I feed to the sqoop for importing.
[cid:[email protected]] After the import when I do a –cat command on the location where sqoop dumped the file…here is what I see 'prasanth','chagarlamudi',1,2014-10-30 15:48:11.0 'Srivenu','null',2,2014-10-30 00:00:00.0 'Viay','Ganta',4,'null' It is replacing the nulls from the ORACLE to a string null(‘null’). I am expecting a non-string NULL or blank/empty string. Please let me know if you have any questions. Appreciate your help Prasanth Chagarlamudi From: Abraham Elmahrek [mailto:[email protected]] Sent: Tuesday, November 04, 2014 1:56 PM To: [email protected] Subject: Re: Sqoop2 null conversions Hey there, Could you provide an example of your output? It looks like Sqoop is in fact passing the string "null" no matter what right now. Things have changed a bit since 1.99.3, but I've created https://issues.apache.org/jira/browse/SQOOP-1661 to track this. -Abe On Mon, Nov 3, 2014 at 1:57 PM, Chagarlamudi, Prasanth <[email protected]<mailto:[email protected]>> wrote: Hello all, I am using sqoop2 to import data from Oracle DB to HDFS(as TEXT_FORMAT). I = =3D noticed that sqoop is inserting null string('null') for empty value in = Orac=3D le. I am expecting a non-string NULL value here. Is there any alternative where= =3D I can convert empty values from ORACLE DB to non-string null values? Any help would be appretiated. Thanks in advance 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. ________________________________ 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.
