CM Add hive Service after installing CDH, error message appears
When adding a service, hive is configured as follows: Error message: Error log:
Xec/opt/cloudera/parcels/cdh-5.4.7-1.cdh5.4.7.p0.3/lib/hadoop/bin/hadoop jar/opt/cloudera/parcels/ Cdh-5.4.7-1.cdh5.4.7.p0.3/lib/hive/lib/hive-cli-1.1.0-cdh5.4.7.jar Org.apache.hive.beeline.HiveSchemaTool- Verbose-dbtype MySQL-initSchemaorg.apache.hadoop.hive.metastore.HiveMetaException:Failed to get schema Version.org.apache.hadoop.hive.metastore.HiveMetaException:Failed to get schema version. At Org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore (Hiveschemahelper.java:77) at Org.apache.hive.beeline.HiveSchemaTool.getConnectionToMetastore (Hiveschematool.java:113) at Org.apache.hive.beeline.HiveSchemaTool.testConnectionToMetastore (Hiveschematool.java:159) at Org.apache.hive.beeline.HiveSchemaTool.doInit (Hiveschematool.java:257) at Org.apache.hive.beeline.HiveSchemaTool.doInit (Hiveschematool.java:243) at Org.apache.hive.beeline.HiveSchemaTool.main (Hiveschematool.java:473) at Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at Sun.reflect.NativeMethodAccessorImpl.invoke (Nativemethodaccessorimpl.java:57) at Sun.reflect.DelegatingMethodAccessorImpl.invoke (Delegatingmethodaccessorimpl.java:43) at Java.lang.reflect.Method.invoke (Method.java:606) at Org.apache.hadoop.util.RunJar.run (Runjar.java:221) at Org.apache.hadoop.util.RunJar.main (Runjar.java:136) caused By:java.sql.SQLException:Access denied forUser ' root ' @ ' node3 '(using Password:yes) at Com.mysql.jdbc.SQLError.createSQLException (Sqlerror.java:957) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:3878) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:3814) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:871) at com.mysql.jdbc.MysqlIO.secureAuth411 (Mysqlio.java:4323) at Com.mysql.jdbc.MysqlIO.doHandshake (Mysqlio.java:1267) at Com.mysql.jdbc.ConnectionImpl.coreConnect (Connectionimpl.java:2255) at Com.mysql.jdbc.ConnectionImpl.connectOneTryOnly (Connectionimpl.java:2286) at Com.mysql.jdbc.ConnectionImpl.createNewIO (Connectionimpl.java:2085) at Com.mysql.jdbc.ConnectionImpl.<init> (connectionimpl.java:795) at com.mysql.jdbc.JDBC4Connection.<init> (jdbc4connection.java:44) at Sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at Sun.reflect.NativeConstructorAcce Ssorimpl.newinstance (Nativeconstructoraccessorimpl.java:57) at Sun.reflect.DelegatingConstructorAccessorImpl.newInstance (Delegatingconstructoraccessorimpl.java:45) at Java.lang.reflect.Constructor.newInstance (Constructor.java:526) at Com.mysql.jdbc.Util.handleNewInstance (Util.java:404) at Com.mysql.jdbc.ConnectionImpl.getInstance (Connectionimpl.java:400) at Com.mysql.jdbc.NonRegisteringDriver.connect (Nonregisteringdriver.java:327) at Java.sql.DriverManager.getConnection (Drivermanager.java:571) at Java.sql.DriverManager.getConnection (Drivermanager.java:215) at Org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore (Hiveschemahelper.java:73) ... 11 MoreSchematool Failed * * *
Cause of the problem:
Workaround:
CM Add hive service after installing CDH