Sqoop导入--password-file功能在sqoop 1.4.4中无法正常工作 [英] Sqoop Import --password-file function not working properly in sqoop 1.4.4

问题描述

我试图运行以下查询。

  sqoop import --connect jdbc：mysql：// IP：3306 / database_name --table clients --target-dir / data / clients --username root --password-file /sqoop.password -m 1 
  

sqoop.password 是一个文件，保存在HDFS路径 /sqoop.password 中，权限为400.

它给我一个错误

 访问拒绝用户'root'@'IP'（使用password：YES） 
  

任何人都可以为此提供解决方案吗？

解决方案

<\\>当文件写入密码时，\ n正在写入文件中。
更好地使用下面的方法来避免问题

echo -nYour_sqoop_password> sqoop.password

I am using hadoop-1.2.1 and sqoop version is 1.4.4.

I am trying to run the following query.

sqoop import --connect jdbc:mysql://IP:3306/database_name --table clients --target-dir /data/clients --username root --password-file /sqoop.password -m 1

sqoop.password is a file which is kept on HDFS in path /sqoop.password with permission 400.

It is giving me an error

Access denied for user 'root'@'IP' (using password: YES)

Can anyone provide solution for this? Thanks in advance.

解决方案

"\n" is being written in file when you vi the file and write the password. Better use the below approach to avoid problems

echo -n "Your_sqoop_password" > sqoop.password

这篇关于Sqoop导入--password-file功能在sqoop 1.4.4中无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！