web | Java

sqoop的数据一致性如何解决?

千锋教育

我们可以使用–staging-table创建临时表的方法来解决:


sqoop export –connect jdbc:mysql://192.168.10.99:3306/user –username root –password 123456 –table app_cource_study_report –columns 


watch_video_cnt,complete_video_cnt,dt –fields-terminated-by “\t” –export-dir “/user/hive/warehouse/tmp.db/app_cource_study_analysis_${day}” –staging-table app_cource_study_report_tmp –clear-staging-table –input-null-string ‘\N’