2013/12/25 Meng QingPing <[email protected]> > 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 >
-- Thanks, Qingping
