前言 hive表中对应appid字段有数据重复导致sqoop导入到对应mysql数据库中appid字段不唯一 select appid from expt_before_object where date_added >= '2018-10-07' group by appid having count(*)>1;