You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by Jarek Jarcec Cecho <ja...@apache.org> on 2013/12/25 15:45:42 UTC

Re: your mail

Hi Jack,
since the data type is a number (double in this case), values 10 and 10.0 are equivalent. Just it happens that both Hive and Orale has chosen to represent them to you differently.

Jarcec

On Wed, Dec 25, 2013 at 04:09:50PM +0800, Meng QingPing wrote:
> 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