Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");
Connection con = DriverManager.getConnection("jdbc:hive://192.168.191.17:10000/default", "", "");
Statement stmt = con.createStatement();
String sql = "LOAD DATA LOCAL INPATH '/data/mf/hzip/tmp/gamecoins' INTO TABLE gamecoins_stream";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
System.out.println(rs.getInt(0));
}
rs.close();
stmt.close();
con.close();
注意:这个文件的路径是要在开启以下命令的机器上
[hadoop@Hadoop-10-1 hive]$ bin/hive --service hiveserver &
否则,执行时会出现文件路径不存在的情况:
HiveServerException(message:Query returned non-zero code: 40000, cause:
FAILED: SemanticException Line 1:23 Invalid path ''/data/mf/hzip/tmp/gamecoins'':
No files matching path file:/data/mf/hzip/tmp/gamecoins, errorCode:40000, SQLState:42000)