Java 使用 JDBC 调用 Hive 出现 The query did not generate a result set!

使用Java通过jdbc调用Hive，执行hive sql时出现如下异常：

Caused by: org.iq80.leveldb.DBException: java.sql.SQLException: The query did not generate a result set!    
    at cn.wanghy.util.HiveTools.listTables(HiveTools.java:96)    
    at cn.why.gd.FileSize.main(FileSize.java:44)    
    ... 5 more    
Caused by: java.sql.SQLException: The query did not generate a result set!    
    at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:393)    
    at cn.wanghy.util.HiveTools.listTables(HiveTools.java:89)    
    ... 6 more   

错误代码如下：

stmt.executeQuery("use database") 

引起异常原因：executeQuery()方法支持的是增删改查等DML语句，对于DDL 需要调用execute()来执行.

正确代码如下：

stmt.execute("use database")  

---

1、java使用jdbc调用hive出现The query did not generate a result set!
http://m635674608.iteye.com/blog/2373896

---