sqoop导入hive

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各组件目录所在: