hive 同步到mysql_043 hive数据同步到mysql

107 阅读 0 评论 71 点赞

我是靠谱客的博主玩命黄豆，这篇文章主要介绍hive 同步到mysql_043 hive数据同步到mysql，现在分享给大家，希望可以做个参考。

1 Exception in thread "main" java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required2 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:550)3 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)4 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)5 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:512)6 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:480)7 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:498)8 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:494)9 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:72)10 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1634)11 at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:637)12 at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:351)13 at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:224)14 at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$2.apply(JdbcUtils.scala:61)15 at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$createConnectionFactory$2.apply(JdbcUtils.scala:52)16 at org.apache.spark.sql.DataFrameWriter.jdbc(DataFrameWriter.scala:278)17 at com.scala.it.HiveToMysql$.main(HiveToMysql.scala:28)18 at com.scala.it.HiveToMysql.main(HiveToMysql.scala)19 Caused by: com.mysql.cj.core.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required20 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)21 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)22 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)23 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)24 at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)25 at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)26 at com.mysql.cj.mysqla.io.MysqlaProtocol.rejectConnection(MysqlaProtocol.java:319)27 at com.mysql.cj.mysqla.authentication.MysqlaAuthenticationProvider.connect(MysqlaAuthenticationProvider.java:207)28 at com.mysql.cj.mysqla.io.MysqlaProtocol.connect(MysqlaProtocol.java:1361)29 at com.mysql.cj.mysqla.MysqlaSession.connect(MysqlaSession.java:132)30 at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1754)31 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1624)32 ... 8 more