sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: Number format conversion
Date Tue, 26 Jan 2016 16:41:06 GMT
[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 <radhakrishnan.iyer@citiustech.com>
wrote:
> 
> Hi Jarec,
>  
> Any tips.We are using oracle DB.
>  
> Best Regards,
> RK
>  
> From: Radhakrishnan Iyer [mailto:radhakrishnan.iyer@citiustech.com] 
> Sent: 18 January 2016 19:10
> To: user@sqoop.apache.org
> 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. ====================================================================================================================================================================


Mime
View raw message