Sorry, forget title "number in oracle appended .0 in hive"
2013/12/25 Meng QingPing <[email protected]> > 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
