I tried to use run a query and get a resultset by using CachedRowSet.execute(). The reason I do this is I want to close the connection after doing the query. However, hive doesn't support this operation. I'm wondering how do you guys deal with such a problem? -- Thank you, Keven Chen