Java连接Hive踩坑血泪

Java连接Hive踩坑血泪 java.sql.SQLException: Method not supported

 

今天突然接到一个需求：为部署在医院内部系统增加Hive连接方式，在一顿操作之后加上JDBC驱动以及hadoop-common依赖

<!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->
<dependency>
    <groupId>org.apache.hive</groupId>
    <artifactId>hive-jdbc</artifactId>
    <version>1.1.1</version>
    <exclusions>
    <exclusion>
         <groupId>org.eclipse.jetty.aggregate</groupId>
         <artifactId>jetty-all</artifactId>
         </exclusion>
             <exclusion>
             <groupId>org.apache.hive</groupId>
             <artifactId>hive-shims</artifactId>
             </exclusion>
         </exclusions>
</dependency>
     <dependency>
     <groupId>org.apache.hadoop</groupId>
     <artifactId>hadoop-common</artifactId>
     <