8springboot 调用hive 操作数据库的bug

最新推荐文章于 2022-04-08 17:39:42 发布

原创

最新推荐文章于 2022-04-08 17:39:42 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

博客讲述了在SpringBoot项目中调用Hive操作数据库时遇到的类加载错误。问题由mysql连接器驱动版本不匹配引起。解决方案包括：检查服务器上的mysql驱动版本，修改pom.xml文件中hive-jdbc的版本为1.1.0，避免不同版本冲突，以及统一hive-service相关依赖的版本。

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

1 java.lang.NoClassDefFoundError: org/apache/hive/service/cli/thrift/TCLIService$Iface

解决加载类加载不进去的方法：

https://blog.youkuaiyun.com/u010429286/article/details/78780145

特此：粘出最终板的pom文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.pengjunlee</groupId>
	<artifactId>spring-boot-hive</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.4.RELEASE</version>
		<relativePath />
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>

		</dependency>
		<dependency>
			<groupId>org.springframework.data</groupId>
			<artifactId>spring-data-hadoop</artifactId>
			<version>2.5.0.RELEASE</version>
		</dependency>
		 <!--<dependency>-->
		    <!--<groupId>org.apache.hive</groupId>-->
		    <!--<artifactId>hive-service</artifactId>-->
		    <!--<version>1.1.0-cdh5.11.0</version>-->
		<!--</dependency>-->
		<dependency>
		    <groupId>org.apache.thrift</groupId>
		    <artifactId>libthrift</artifactId>
		    <version>0.11.0</version>
		    <type>pom</type>
		</dependency>
		<dependency>
			<groupId>org.apache.hive</groupId>
			<artifactId>hive-jdbc</artifactId>
			<exclusions>
				<exclusion>
					<groupId>org.apache.hive</groupId>
					<artifactId>hive-service-rpc</artifactId>
				</exclusion>
				<exclusion>
					<groupId>org.apache.hive</groupId>
					<artifactId>hive-service</artifactId>
				</exclusion>
			</exclusions>
			<version>1.1.0</version>
		</dependency>
		<dependency>
			<groupId>org.apache.hive</groupId>
			<artifactId>hive-service</artifactId>
			<version>1.1.0</version>
		</dependency>

		<dependency>
			<groupId>org.apache.tomcat</groupId>