hive 也是支持jdbc 连接的这样操作起来就会方便很多 毕竟可以在客户端直接些sql 不多说
首先 需要启动hive server 的server2 服务
bin/hive --service hiveserver2 &
下面就是编写客户端了
提供pom 依赖
<hive.version>2.2.0</hive.version>
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<version>${hive.version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.35</version>
</dependency>
就是普通的java 连接数据库的代码
Class.forName ( "org.apache.hive.jdbc.HiveDriver" );
Connection connection = DriverManager.getConnection ( "jdbc:hive2://hadoop:10000/default", "root", "root" );
Statement stmt = connection.createStatement ();
String querySQL = "select * from default.student_scores";
ResultSet resut = stmt.executeQuery ( querySQL );
while (resut.next ()) {
System.out.println ( resut.getObject ( 1 ) );
}