Spring Boot里面引入hive-jdbc包出错怎么办

# Spring Boot里面引入hive-jdbc包出错怎么办

## 前言

在Spring Boot项目中集成Hive JDBC进行大数据分析时，开发者常会遇到各种依赖冲突、版本不兼容或配置错误问题。本文将系统性地分析7类典型错误场景，提供可落地的解决方案，并深入讲解背后的技术原理。

## 一、基础环境准备

### 1.1 推荐环境配置
```java
// pom.xml基础配置示例
<properties>
    <java.version>1.8</java.version>
    <hadoop.version>3.3.4</hadoop.version>
    <hive.version>3.1.3</hive.version>
</properties>

<dependencies>
    <!-- Hive JDBC核心依赖 -->
    <dependency>
        <groupId>org.apache.hive</groupId>
        <artifactId>hive-jdbc</artifactId>
        <version>${hive.version}</version>
        <exclusions>
            <exclusion>
                <groupId>org.eclipse.jetty.aggregate</groupId>
                <artifactId>*</artifactId>
            </exclusion>
        </exclusions>
    </dependency>
    
    <!-- Hadoop通用依赖 -->
    <dependency>
        <groupId>org.apache.hadoop</groupId>
        <artifactId>hadoop-common</artifactId>
        <version>${hadoop.version}</version>
    </dependency>
</dependencies>

java.lang.NoSuchMethodError: org.apache.hadoop.conf.Configuration.addDeprecation

<!-- 使用dependencyManagement统一版本 -->
<dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-client</artifactId>
            <version>${hadoop.version}</version>
        </dependency>
    </dependencies>
</dependencyManagement>

SLF4J: Class path contains multiple SLF4J bindings

<!-- 排除冲突的日志实现 -->
<exclusions>
    <exclusion>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
    </exclusion>
    <exclusion>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
    </exclusion>
</exclusions>

GSS initiate failed: No valid credentials provided

// 在application.properties中配置
hive.auth=kberos
hive.kerberos.principal=your_principal@REALM
hive.kerberos.keytab=/path/to/keytab

// Java代码设置
System.setProperty("java.security.krb5.conf", "/etc/krb5.conf");

@Configuration
public class HiveConfig {
    
    @Value("${hive.url}") 
    private String url;

    @Bean
    public DataSource hiveDataSource() {
        HikariConfig config = new HikariConfig();
        config.setJdbcUrl(url);
        config.setMaximumPoolSize(20);
        config.setConnectionTimeout(30000);
        return new HikariDataSource(config);
    }
}

public class CustomHiveTypeSystem extends DefaultTypeSystem {
    @Override
    public TypeInfo getTypeInfoFromTypeString(String typeString) {
        // 处理Hive特殊类型
        if(typeString.startsWith("decimal")) {
            return new DecimalTypeInfo(38, 18);
        }
        return super.getTypeInfoFromTypeString(typeString);
    }
}

stmt.setFetchSize(5000);

logging.level.org.apache.hive=DEBUG

DriverManager.setLogWriter(new PrintWriter(System.out));