maven项目jdbc访问hive失败。


public static void main(String[] args) throws Exception {
        //①加载驱动 可省略
//        Class.forName("org.apache.hive.jdbc.HiveDriver");
        //②创建连接
        Connection connection = DriverManager.getConnection("jdbc://hive2://hadoop102:10000","swh233", "swh233");
        //③准备SQL
        String sql = "select * from default.person";
        //④预编译SQL
        PreparedStatement ps = connection.prepareStatement(sql);
        //执行sql
        ResultSet resultSet = ps.executeQuery();
        while(resultSet.next()) {
            System.out.println("name: " + resultSet.getString("name") + "\tage: " + resultSet.getString("age"));
        }
    }

报错信息:

img
第14行是

Connection connection = DriverManager.getConnection("jdbc://hive2://hadoop102:10000","swh233", "swh233");

hdfs-site.xml
hive-site.xml
放到resource里试下

jdbc://hive2://hadoop102:10000/default

格式:jdbc:hive2://hadoop102:10000