exists hive中如何使用_hive配置及使用说明

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class HiveTest {

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

// 填写hive的IP，之前在配置文件中配置的IP

private static String Url = "jdbc:hive2://192.168.1.216:10000/default";

private static Connection conn;

private static PreparedStatement ps;

private static ResultSet rs;

// 创建连接

public static Connection getConnnection() {

try {

Class.forName(driverName);

conn = DriverManager.getConnection(Url, "root", "root");

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return conn;

}

public static PreparedStatement prepare(Connection conn, String sql) {

PreparedStatement ps = null;

try {

ps = conn.prepareStatement(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return ps;

}

public static void getDatas(String tablename) {

conn = getConnnection();

String sql = "select * from " + tablename;

System.out.println(sql);

try {

ps = prepare(conn, sql);

rs = ps.executeQuery();

int columns = rs.getMetaData().getColumnCount();

System.out.println("col_count=" + columns);

while (rs.next()) {

for (int i = 1; i <= columns; i++) {

System.out.println(rs.getString(i));

System.out.print("\t\t");

}

System.out.println();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

String tablename = "tb1";//你在hive里建的表

getDatas(tablename);

}

}