使用jdbc连接 hive 、presto

最新推荐文章于 2024-09-10 15:18:33 发布

printsky

最新推荐文章于 2024-09-10 15:18:33 发布

阅读量7.3k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/printsky/article/details/83501824

版权

java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

连接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();
    }