1.jdbc连接Hive
public class testJdbConnect {
private static String dirvername = "org.apache.hive.jdbc.HiveDriver";
private static String Url = "jdbc:hive2://10.0.11.90:10000/dde";
private static Connection connection;
public static Connection getConnection(){
try {
Class.forName(dirvername);
connection = DriverManager.getConnection(Url,"","");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static PreparedStatement preparedStatement(Connection connection,String sql){
PreparedStatement ps = null;
try {
ps = connection.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return ps;
}
}
2.将查询到的数据保存进对象中并返回
public class JdbcConnectHive {
private static Connection connection = testJdbConnect.getConnection();
private static PreparedStatement ps;
private static ResultSet resultSet;
public static List<javabean> getDataSouece(String tables) {
String sql = "select app_id,member_id,app_name,advertiser_id,insertion_orders_id,line_item_id,profile_id,parent_interval_id,publisher_id,site_id,app_official_name,create_date,last_modified from " +tables;
System.out.println(sql);
List<String> data=new ArrayList<String>();
List<