进入下面目录

cd /root/soft/hive-1.2.1/bin
[root@zjj101 bin]# hiveserver2

运行完了就卡在这里了, 因为hiveserver2是一个前台进程.

jdbc客户端连接

pom 依赖

<dependencies><dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-core</artifactId><version>2.8.2</version></dependency><dependency><groupId>org.apache.hadoop</groupId><artifactId>hadoop-common</artifactId><version>2.7.2</version></dependency><dependency><groupId>org.apache.hadoop</groupId><artifactId>hadoop-client</artifactId><version>2.7.2</version></dependency><dependency><groupId>org.apache.hadoop</groupId><artifactId>hadoop-hdfs</artifactId><version>2.7.2</version></dependency><!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc --><dependency><groupId>org.apache.hive</groupId><artifactId>hive-jdbc</artifactId><version>1.2.1</version></dependency><!-- <dependency> <groupId>jdk.tools</groupId> <artifactId>jdk.tools</artifactId> <version>1.8</version> <scope>system</scope> <systemPath>C:\Program Files\Java\jdk1.8.0_121\lib\tools.jar</systemPath> </dependency> --></dependencies>

Java代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;/*** hive  的 jdbc驱动*/
public class HiveJdbc {public static void main(String[] args) throws Exception {//①加载驱动//Class.forName("org.apache.hive.jdbc.HiveDriver");//②创建连接  ,端口号固定是10000//用户名 密码Connection connection = DriverManager.getConnection("jdbc:hive2://ip:10000", "root", "root");// ③准备SQLString sql = "select * from default.student";// ④预编译sqlPreparedStatement ps = connection.prepareStatement(sql);// ⑤执行sqlResultSet resultSet = ps.executeQuery();while (resultSet.next()) {System.out.println("name:" + resultSet.getString("name") + "---->age:" +resultSet.getInt("age"));}}}

控制台结果

你代码每连接一次,控制台就会出现这个东西.