MAPREDUCE服务 MRS-Hive应用开发规则:执行HQL

时间：2024-05-28 14:22:57

MAPREDUCE服务 MRS

执行HQL

执行HQL，注意HQL不能以";"结尾。

正确示例：

String sql = "SELECT COUNT(*) FROM employees_info";
Connection connection = DriverManager.getConnection(url, "", "");
PreparedStatement statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();

错误示例：

String sql = "SELECT COUNT(*) FROM employees_info;";
Connection connection = DriverManager.getConnection(url, "", "");
PreparedStatement statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();

上一篇：MAPREDUCE服务 MRS-Hive应用开发规则:Hive JDBC驱动的加载

下一篇：MAPREDUCE服务 MRS-Hive应用开发规则:Hive JDBC驱动的加载