mysql - SQOOP Mysql导入Hive报错 用户不属于hive

Question

当我使用此命令将表导入 Hive 时

sqoop import \
--connect jdbc:mysql://192.168.200.33:3306/db_socmed_gp \
--username=fanta \
--password=fanta \
--table=tb_gp_account \
--hive-import \
--hive-database=db_socmed_gp \
--target-dir=home/fanta/db_socmed_gp2 \
--driver com.mysql.jdbc.Driver \
--direct

当 sqoop 将数据导入 Hive 时出现错误:

Loading data to table db_socmed_gp.tb_gp_account
chgrp: changing ownership of 'hdfs://lobah:8021/user/hive/warehouse/db_socmed_gp.db/tb_gp_account/part-m-00000': User does not belong to hive
chgrp: changing ownership of 'hdfs://lobah:8021/user/hive/warehouse/db_socmed_gp.db/tb_gp_account/part-m-00001': User does not belong to hive
chgrp: changing ownership of 'hdfs://lobah:8021/user/hive/warehouse/db_socmed_gp.db/tb_gp_account/part-m-00002': User does not belong to hive
chgrp: changing ownership of 'hdfs://lobah:8021/user/hive/warehouse/db_socmed_gp.db/tb_gp_account/part-m-00003': User does not belong to hive
Table db_socmed_gp.tb_gp_account stats: [numFiles=4, totalSize=21254586]

Answer 1

您尝试不属于hadoop/Hive组的用户修改仓库目录的内容。为用户组授予必要的权限，然后重试。