sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Meng QingPing <mqingp...@gmail.com>
Subject Re:
Date Wed, 25 Dec 2013 08:11:42 GMT
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

Mime
View raw message