Impala JDBC : Issue while caching resultset when query has LIMIT constraint

BVRaju — Fri, 16 Sep 2022 11:53:00 GMT

Hi,

Please help me in below issue..Same Issue exist with both Impala and HIVE jdbc

If I add LIMIT constarint in the query then I am unable to populate cached rowset with resultset.

Example :

Select .. from .. where .. group by ..order by ..desc ( working fine).

Select .. from .. where .. group by ..order by .. desc limit 10 ( giving error).

Below is the the stacktrace using impala :

java.lang.NullPointerException
at java.lang.String.<init>(String.java:154) ~[?:1.7.0_10]
at sun.jdbc.rowset.RowSetMetaDataImpl.setSchemaName(RowSetMetaDataImpl.java:269) ~[rowset.jar:?]
at sun.jdbc.rowset.CachedRowSet.initMetaData(CachedRowSet.java:680) ~[rowset.jar:?]
at sun.jdbc.rowset.CachedRowSet.populate(CachedRowSet.java:647) ~[rowset.jar:?]

Actual code snippet :

statement = dbConnection.createStatement();
resultSet = statement.executeQuery(query);
rowSet.populate(resultSet);

rowset is sun.jdbc.rowset.CachedRowSet

Impala JDBC vsersion is - 2.5.38.1058 GA

Thanks in advance.

Re: Impala JDBC : Issue while caching resultset when query has LIMIT constraint

BVRaju — Wed, 05 Jul 2017 10:33:08 GMT

Issue resolved.

Instead of sun.jdbc.rowset.CachedRowSet I have used javax.sql.rowset.CachedRowSet;

question Re: Impala JDBC : Issue while caching resultset when query has LIMIT constraint in Archives of Support Questions (Read Only)

Impala JDBC : Issue while caching resultset when query has LIMIT constraint

Re: Impala JDBC : Issue while caching resultset when query has LIMIT constraint