public class HiveJdbcClient {
private static String driverName = "org.apache.hive.jdbc.HiveDriver";
private static String url = "jdbc:hive2://192.168.1.182:10000/my";
private static String user = "root";//Linux用户名密码
private static String password = "1q2w3e";
private static String sql = "";
private static ResultSet res;
public static void main(String[] args) throws Exception {
System.out.println("start");
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
String tableName = "test";
sql = "create table "//创建表
+ tableName
+ " (key int, value string) row format delimited fields terminated by '\t'";
stmt.execute(sql);
sql="select count(1) from "+tableName;//查询表
res = stmt.executeQuery(sql);
while(res.next()){
System.out.println(res.getInt(1));
}
}
}
JDBC操作hive
最新推荐文章于 2021-11-19 13:06:34 发布