一.環境搭建(Hadoop+Hive)

window7: eclipse4.5.1

linux: hadoop-01 192.168.33.01

hadoop-01 要有 Hdfs namenode(active),Yarn resourcemanager(active),Hive metastore 和hiveserver2程式.

二.啟動hive metastore和hiveserver2服務命令

[root@hadoop-01 bin]# hive --service metastore &

[root@hadoop-01 bin]# hive --service hiveserver2 &

到window7的D:\Hadoop\hadoop-2.7.2

 到window7的D:\Hadooop\apache-hive-2.0.0-bin

a.匯入hive的lib資料夾下所有的包

b.匯入hadoop的D:\Hadoop\hadoop-2.7.2\share\hadoop\common\hadoop-common-2.7.2.jar

點選(此處)摺疊或開啟

package com.hadoop.hive;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class hiveserver2Test {
public boolean run() {
Connection con=null;
Statement stmt =null;
ResultSet rs=null;
String tableName="studentinfo";//表名
try {
String driver="org.apache.hive.jdbc.HiveDriver";//Hive的驅動字串
Class.forName(driver); //載入Hive驅動
con = DriverManager.getConnection("jdbc:hive2://192.168.33.01:10000", "root", "");//獲取hive2的jdbc連線，注意預設的資料庫是default
stmt = con.createStatement();
rs=stmt.executeQuery("select * from "+tableName+" ");//查詢所有,直接執行
while(rs.next()){
System.out.println("id:"+rs.getString(1)+" "+"name:"+rs.getString(2)+" "+"age:"+rs.getString(3)+" "+"tel:"+rs.getString(4)+" ");
}
System.out.println("查詢成功!");
stmt.close();
con.close();
return true;
} catch (Exception e) {
e.printStackTrace();
System.out.println("error");
return false;
}
}
public static void main(String[] args) throws SQLException {
hiveserver2Test hiveJdbcClient = new hiveserver2Test();
hiveJdbcClient.run();
}
}

這句意思就是沒有找到log4j2的配置檔案

log4j2.xml檔案

點選(此處)摺疊或開啟