有关Java连接Hive数据库,
首先要在Maven项目的pom.xml文件中加载依赖:
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<version>0.13.1</version>
</dependency>
在虚拟机上把Hive启动起来,
启动Hive之前先把Zookeeper和Hadoop启动起来:
zkServer.sh start; //启动Zookeeper
sbin/start-all.sh start; //启动Hadoop
//可通过jps指令查看是否都已经启动
bin/hive; //启动Hive
然后,连接部分的代码为:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class HiveConnec {
public static void main(String [] args) throws Exception{
Class.forName("org.apache.hive.jdbc.HiveDriver");
Connection connection = DriverManager.getConnection("jdbc:hive2://192.168.199.3:10000/test_db", "hadoop000", "123456");
Statem