Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

New Contributor

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.

 

 

 

1 ACCEPTED SOLUTION

New Contributor

Issue resolved. 

 

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

View solution in original post

1 REPLY 1

New Contributor

Issue resolved. 

 

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