安装hive后打开DLI输入show databases;查看数据库,却发现出现了
Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
从网上找到的解决方法是:
输入
hive --service metastore
输入命令后出现了超长的错误
hadoop,hbase之类的在Ubuntu上都装好了,但是hive安装之后进入DLI界面操作时一直出现错误,周末弄了两天,差点把hadoop弄坏了,隔了一个星期再看,还是不行,真的好烦
后来将jdbc驱动包换为8.0以上的版本,
却出现:
Caused by: java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
原来是jdk和mysql驱动包版本发生冲突
将jdk1.7换成jdk1.8
见教程:
https://blog.csdn.net/weixin_45468845/article/details/105875665
换了之后还是不行。
出现了:
MetaException(message:Error creating transactional connection factory)
Caused by: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "HikariCP" plugin to create a ConnectionPool gave an error : Failed to initialize pool: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=false'.
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=false'.
Caused by: java.sql.SQLNonTransientConnectionException: Cannot load connec