Sqoop文件模式提供数据库密码运行报错java.sql.SQLException: Access denied for user ‘hive‘@‘IP‘

wufabao

已于 2022-03-01 22:21:33 修改

阅读量8.6k

点赞数 2

分类专栏： Debug心得 # Sqoop 文章标签： java sqoop hive hadoop

于 2021-11-17 23:59:13 首次发布

本文链接：https://blog.csdn.net/qq_41413743/article/details/121390791

版权

Debug心得同时被 2 个专栏收录

66 篇文章 2 订阅

订阅专栏

Sqoop

1 篇文章 0 订阅

订阅专栏

通过文件模式为Sqoop在Job执行数据同步的过程中报错


21/11/17 23:24:08 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user 'hive'@'IP' (using password: YES)
java.sql.SQLException: Access denied for user 'hive'@'IP' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
        at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
        at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
        at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
        at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
        at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
        at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
        at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:243)
        at org.apache.sqoop.tool.JobTool.run(JobTool.java:298)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
21/11/17 23:24:08 ERROR tool.ImportTool: Import failed: java.io.IOException: No columns to generate for ClassWriter
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1677)
        at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
        at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:243)
        at org.apache.sqoop.tool.JobTool.run(JobTool.java:298)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

在这里插入图片描述

原因

查错查了一个多小时。。。
最后发现是VIM的锅，创建密码文件千万不要用VIM创建，或者创建好之后使用VIM保存退出（!wq）,因为VIM会自动在文件的最后加上一个换行符，Sqoop在读取密码文件的时候会连换行符一块读取，这样就会报Access denied for user 'hive'@'IP' (using password: YES)的错误.

解决方案

使用echo -n "你的数据库密码" > 密码文件名称创建文件
想要查看是否有特殊字符，使用cat -a 密码文件名称来查看是否有特殊字符
在这里插入图片描述
上图是使用VIM创建或者用VIM打开后保存退出（!wq）的，可以看到后面有多余的符号
下图是使用echo -n创建的文件，没有特殊符号

wufabao

关注

2
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Sqoop文件模式提供数据库密码运行报错java.sql.SQLException: Access denied for user ‘hive‘@‘IP‘

通过文件模式为Sqoop在Job执行数据同步的过程中报错21/11/17 23:24:08 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user 'hive'@'IP' (using password: YES)java.sql.SQLException: Access denied for user 'hive'@'IP' (using password:
复制链接

扫一扫