sqoop数据校验
sqoop数据校验
#4 check data oracle_cnt=$(sqoop eval \ -Dmapred.job.queue.name=${queue} \ --connect ${connect} \ --username ${username} \ --password ${password} \ -e " select 'check_data '||count(1) as cnt from all_tables "|grep "check_data"|awk '{print $3}') hive_cnt=$(hive -S -e " select concat('check_data ',count(1)) as cnt from test1; "|grep "check_data"|awk '{print $2}')