1.前提
启动hiveserver2服务
url,username,password、
2.官网
3.程序
4.结果
emp的第一列与第二列
5.源程序
1 package com.cj.it.hiveUdf; 2 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.ResultSet; 6 import java.sql.Statement; 7 8 9 public class JdbcClient { 10 private static String driverName="org.apache.hive.jdbc.HiveDriver"; 11 public static void main(String[] args) throws Exception{ 12 try { 13 Class.forName(driverName); 14 } catch (ClassNotFoundException e) { 15 e.printStackTrace(); 16 System.exit(1); 17 } 18 Connection connection=DriverManager.getConnection("jdbc:hive2://linux-hadoop01.ibeifeng.com:10000/hadoop09", 19 "beifeng", "beifeng"); 20 Statement statement=connection.createStatement(); 21 String sqlStr="select * from student"; 22 System.out.println("sql: "+sqlStr); 23 ResultSet resultSet=statement.executeQuery(sqlStr); 24 while(resultSet.next()) { 25 System.out.println(resultSet.getString(1)+"-------"+resultSet.getString(2)); 26 } 27 } 28 }
6.效果
在windows下执行的效果。