hive常见的问题

最新推荐文章于 2025-02-24 15:41:08 发布

zhangjunli

最新推荐文章于 2025-02-24 15:41:08 发布

阅读量369

点赞数

CC 4.0 BY-SA版权

分类专栏： Hadoop 文章标签： hive

本文链接：https://blog.csdn.net/zhangjunli/article/details/110479032

Hadoop 专栏收录该内容

23 篇文章

订阅专栏

博客主要围绕Hive使用展开，介绍了启动Hive、执行show databases、格式化数据库、beeline连接等操作时出现的报错及解决办法，还提及通过httpfs协议访问rest接口，以root用户包装自己用户的方式操作HDFS，并说明了开启rest接口需在相关配置文件中添加内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

启动 hive 时

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

解决办法

jdbc:mysql://mini3:3306/hive?characterEncoding=utf8&amp;createDatabaseIfNotExist=true&amp;useSSL=false

进入hive 执行show databases时报错

FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

解决办法

schematool -dbType mysql -initSchema

格式化数据库错误

org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
SQL Error code: 0
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

解决办法

确认连接的数据库是否正确

beeline 拒绝连接

Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root (state=08S01,code=0)

解决办法

通过httpfs协议访问rest接口，以root用户包装自己用户的方式操作HDFS
首先需要开启rest接口，在hdfs-site.xml文件中加入：

<property>  
	<name>dfs.webhdfs.enabled</name>  
	<value>true</value>  
</property>

然后在core-site.xml文件中加入：

<property>
	<name>hadoop.proxyuser.root.hosts</name>
	<value>*</value>
</property>
<property>
	<name>hadoop.proxyuser.root.groups</name>
	<value>*</value>
</property>