sqoop命令:
sqoop import --connect “jdbc:mysql://mysqlIP:开放的端口/QualityControl?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull” --username 导出方账户–password 导出方密码–query “select * from HL7Logwhere ParType=‘QC001’ AND $CONDITIONS limit 10” (要导出的数据) --hive-delims-replacement " " --fields-terminated-by ‘$’ --delete-target-dir --num-mappers 1 --target-dir /tmp/HL7Log(导出方的hdfs目录) --hive-import --hive-partition-key day_id --hive-partition-value 20201104 --hive-database sgl_zc_analysis(导入方的数据库) --hive-table HL7Log1(导入方的表)
cdh各组件目录所在: