使用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.0.0.1: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.0.0.34: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();
    }