김준식
unread,Oct 21, 2022, 4:22:23 AM10/21/22Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Hue-Users
sqoop import --connect jdbc:mysql://mysqlhost:3306/demo --username demo --password 'ai2110!' --table calendar --target-dir /user/hue/tbl_elest_review2211112 -m 1 --as-textfile
If the above command is executed in the shell, it works normally.
But when I run it in apache hue => editor => sqoop
An error occurs.
>>> Invoking Sqoop command line now >>>
2022-10-21 08:09:12,719 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2022-10-21 08:09:12,758 [main] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.7
2022-10-21 08:09:12,771 [main] WARN org.apache.sqoop.tool.BaseSqoopTool - Setting your password on the command-line is insecure. Consider using -P instead.
2022-10-21 08:09:12,781 [main] WARN org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2022-10-21 08:09:12,826 [main] INFO org.apache.sqoop.manager.MySQLManager - Preparing to use a MySQL streaming resultset.
2022-10-21 08:09:12,826 [main] INFO org.apache.sqoop.tool.CodeGenTool - Beginning code generation
2022-10-21 08:09:13,084 [main] ERROR org.apache.sqoop.manager.SqlManager - Error executing statement: java.sql.SQLException: Access denied for user 'demo'@'152.30.119.754' (using password: YES)
java.sql.SQLException: Access denied for user 'demo'@'152.30.119.754' (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)