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}')