Reply
New Contributor
Posts: 2
Registered: ‎07-04-2017
Accepted Solution

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

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.

 

 

 

New Contributor
Posts: 2
Registered: ‎07-04-2017

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

Issue resolved. 

 

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

Announcements