HIVE-java api

Hive JDBC 连接与数据检索

最新推荐文章于 2024-10-30 22:34:09 发布

原创最新推荐文章于 2024-10-30 22:34:09 发布 · 203 阅读

0 ·

CC 4.0 BY-SA版权

大数据专栏收录该内容

19 篇文章

订阅专栏

本文介绍如何使用Java JDBC连接Hive Server2并执行SQL查询，演示了从Hive表中检索数据的过程。文章包含配置参数、依赖项及代码实现。

pom

 <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>

	<dependency>  
	    <groupId>jdk.tools</groupId>  
	    <artifactId>jdk.tools</artifactId>  
	    <version>1.7</version>  
	    <scope>system</scope>  
	    <systemPath>C:/Program Files/Java/jdk1.8.0_74/lib/tools.jar</systemPath>  
	</dependency>
 
	<dependency>
	    <groupId>org.slf4j</groupId>
	    <artifactId>jcl-over-slf4j</artifactId>
	    <version>1.7.5</version>
	</dependency>
	
	
	<dependency>
	    <groupId>org.slf4j</groupId>
	    <artifactId>slf4j-api</artifactId>
	    <version>1.7.5</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-common -->
	<dependency>
	    <groupId>org.apache.hadoop</groupId>
	    <artifactId>hadoop-common</artifactId>
	    <version>2.6.0</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-hdfs -->
	<dependency>
	    <groupId>org.apache.hadoop</groupId>
	    <artifactId>hadoop-hdfs</artifactId>
	    <version>2.6.0</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-client -->
	<dependency>
	    <groupId>org.apache.hadoop</groupId>
	    <artifactId>hadoop-client</artifactId>
	    <version>2.6.0</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-common -->
	<dependency>
	    <groupId>org.apache.hbase</groupId>
	    <artifactId>hbase-common</artifactId>
	    <version>1.1.2</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-client -->
	<dependency>
	    <groupId>org.apache.hbase</groupId>
	    <artifactId>hbase-client</artifactId>
	    <version>1.1.2</version>
	</dependency>
	<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-server -->
	<dependency>
	    <groupId>org.apache.hbase</groupId>
	    <artifactId>hbase-server</artifactId>
	    <version>1.1.2</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->
	<dependency>
	    <groupId>org.apache.hive</groupId>
	    <artifactId>hive-jdbc</artifactId>
	    <version>1.1.0</version>
	</dependency>

HiveConfigurationConstants

public class HiveConfigurationConstants {
	public static final String CONFIG_DRIVERNAME = "org.apache.hive.jdbc.HiveDriver";
	public static final String CONFIG_URL = "jdbc:hive2://cdh1:10000/default";
	public static final String CONFIG_USER = "root";
	public static final String CONFIG_PASSWORD = "123";
}

JDBCToHiveServer2


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCToHiveServer2 {

	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		// 通过反射机制获取驱动程序
		try {
			Class.forName(HiveConfigurationConstants.CONFIG_DRIVERNAME);
			// 建立连接
			Connection conn = DriverManager.getConnection(HiveConfigurationConstants.CONFIG_URL,	HiveConfigurationConstants.CONFIG_USER,HiveConfigurationConstants.CONFIG_PASSWORD);
			// 创建statement
			Statement stmt = conn.createStatement();
			// 准备SQL脚本
			String sql = "select * from stu1";
			// statement执行脚本
			ResultSet res = stmt.executeQuery(sql);
			// 处理结果集
			while (res.next()) {
				System.out.println(res.getString(1)+"@"+res.getString(2));
				}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		

	}

}