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
