JDBC操作hive

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));
		}
		
	}
}