hive jdbc权限不够_hive权限控制介绍

packagecom.hive.jdbc;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.sql.Statement;

importorg.apache.log4j.Logger;

publicclass HiveJdbcClient {

private static String driverName ="org.apache.hadoop.hive.jdbc.HiveDriver";

private static String url ="jdbc:hive://192.168.153.100:10000/default";

private static String user ="hive";

private static String password = "hive";

private static String sql ="";

private static ResultSet res;

private static final Logger log =Logger.getLogger(HiveJdbcClient.class);

public static void main(String[] args){

try {

Class.forName(driverName);

Connection conn =DriverManager.getConnection(url, user, password);

Statement stmt =conn.createStatement();

// 创建的表名

String tableName ="testHiveJDBC";

/** 第一步:存在就先删除**/

sql = "drop table" + tableName;

stmt.executeQuery(sql);

/** 第二步:不存在就创建**/

sql = "createtable " + tableName + " (key int, value string)

row formatdelimited fields terminated by '\t'";

stmt.executeQuery(sql);

// 执行“show tables”操作

sql = "show tables'" + tableName + "'";

System.out.println("Running:" + sql);

res = stmt.executeQuery(sql);

System.out.println("执行“show tables”运行结果:");

if (res.next()) {

System.out.println(res.getString(1));

}

// 执行“describe table”操作

sql = "describe" + tableName;

System.out.println("Running:" + sql);

res =stmt.executeQuery(sql);

System.out.println("执行“describe table”运行结果:");

while (res.next()){

System.out.println(res.getString(1) + "\t" +res.getString(2));

}

// 执行“load data intotable”操作

String filepath ="/home/hadoop/ziliao/userinfo.txt";

sql = "load datalocal inpath '" + filepath + "' into table " + tableName;

System.out.println("Running:" + sql);

res =stmt.executeQuery(sql);

// 执行“select * query”操作

sql = "select *from " + tableName;

System.out.println("Running:" + sql);

res =stmt.executeQuery(sql);

System.out.println("执行“select * query”运行结果:");

while (res.next()) {

System.out.println(res.getInt(1) + "\t" + res.getString(2));

}

// 执行“regular hive query”操作

sql = "selectcount(1) from " + tableName;

System.out.println("Running:" + sql);

res =stmt.executeQuery(sql);

System.out.println("执行“regular hive query”运行结果:");

while (res.next()) {

System.out.println(res.getString(1));

}

conn.close();

conn = null;

} catch (ClassNotFoundExceptione) {

e.printStackTrace();

log.error(driverName +" not found!", e);

System.exit(1);

} catch (SQLException e) {

e.printStackTrace();

log.error("Connection error!", e);

System.exit(1);

}

}

}