使用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