sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Meng QingPing <mqingp...@gmail.com>
Subject Re: number in oracle appended .0 in hive
Date Wed, 25 Dec 2013 08:15:02 GMT
2013/12/25 Meng QingPing <mqingping@gmail.com>

> Sorry, forget title "number in oracle appended .0 in hive"
>
>
> 2013/12/25 Meng QingPing <mqingping@gmail.com>
>
>> Hi,
>>
>> I use sqoop1.4.4 import oracle 11g data to hive 0.13-snapshot.
>> sqoop import --connect jdbc:oracle:thin:@//ip/test --username un
>> -password pwd --table TB1 --hive-import --direct --hive-table tb1
>> --hive-overwrite --split-by id
>>
>> The id and user_id type in oracle is number, after importing, id and
>> user_id type in hive is double, that's fine. A problem is the value in hive
>> appended ".0".
>> in oracle
>> id user_id
>>  1   10
>> 2   20
>>
>> in hive
>> id user_id
>> 1.0   10.0
>> 2.0   20.0
>>
>> Even append --map-column-hive ID=bigint in import command, the is the
>> value in hive also appended ".0".
>>
>> How to make sure value is same with oracle? Thanks.
>>
>> Jack
>>
>
>
>
> --
> Thanks,
> Qingping
>



-- 
Thanks,
Qingping

Mime
View raw message