求解:虚拟机运行win上面的mysql数据导入到hive,使用sqoop导入报错
报错:
运行代码
sqoop import \
--connect jdbc:mysql://192.168.87.1:3306/teach \
--username root \
--password 12345 \
--query 'select id, school_id, subject_id, class_id, ifnull(studying_student_count,0) studying_student_count, studying_date, FROM_UNIXTIME(unix_timestamp(),"%Y-%m-%d") as dt from class_studying_student_count where $CONDITIONS' \
--hcatalog-database itcast_dimen \
--hcatalog-table class_studying_student_count_dimen \
-m 100 \
--split-by id