[Adding user@sqoop back] I believe that this is expected behavior because “Number” is a fix-point number and thus we can't use “int” to represent it. If you’re using Number only to store “whole” numbers, then you should be able to use —map-column-java and —map-column-hive to cast it to Integer.
Jarcec > On Jan 19, 2016, at 5:51 AM, Radhakrishnan Iyer > <[email protected]> wrote: > > Hi Jarec, > > Any tips.We are using oracle DB. > > Best Regards, > RK > > From: Radhakrishnan Iyer [mailto:[email protected]] > Sent: 18 January 2016 19:10 > To: [email protected] > Subject: Number format conversion > > A Number is source table is getting converted to Double in Hive while > performing sqoop import > Eg: 123456 in source is 123456.0 in Hive. > > If the number’s length is increased > 6, then it is saved in different format > in Hive. > Eg: 12345678 in Source table is populated as 1.2345678E7 in Hive. > > > Is there any provision in sqoop to avoid this conversion? > > > Best Regards, > Radhakrishnan > > =========================================================================================================================================================================================== > DISCLAIMER: The information contained in this message (including any > attachments) is confidential and may be privileged. If you have received it > by mistake please notify the sender by return e-mail and permanently delete > this message and any attachments from your system. Any dissemination, use, > review, distribution, printing or copying of this message in whole or in part > is strictly prohibited. Please note that e-mails are susceptible to change. > CitiusTech shall not be liable for the improper or incomplete transmission of > the information contained in this communication nor for any delay in its > receipt or damage to your system. CitiusTech does not guarantee that the > integrity of this communication has been maintained or that this > communication is free of viruses, interceptions or interferences. > ====================================================================================================================================================================
