java连接presto,使用jdbc连接 hive 、presto

连接presto

public void test(String sql) throws SQLException, ClassNotFoundException {

Class.forName("com.facebook.presto.jdbc.PrestoDriver");

Connection connection = DriverManager.getConnection("jdbc:presto://172.18.99.48:8080/kudu/default", "root", null);

Statement stmt = connection.createStatement();

ResultSet rs = stmt.executeQuery("show tables");

while (rs.next()) {

System.out.println("rs.getString(1) = " + rs.getString(1));

}

rs.close();

connection.close();

}

连接 hive

@RequestMapping("/impala")

public void testImpala(String sql) throws SQLException, ClassNotFoundException {

Class.forName("org.apache.hive.jdbc.HiveDriver");

Connection connection = DriverManager.getConnection("jdbc:hive2://10.100.49.69:21050/;auth=noSasl");

PreparedStatement stmt = connection.prepareStatement("select * from flight_test_key3_range limit 1");

ResultSet rs = stmt.executeQuery();

while (rs.next()) {

System.out.println("rs.getString(1) = " + rs.getString(1));

}

rs.close();

connection.close();

}