Member since
07-04-2017
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2426 | 07-05-2017 03:33 AM |
07-05-2017
03:33 AM
Issue resolved. Instead of sun.jdbc.rowset.CachedRowSet I have used javax.sql.rowset.CachedRowSet;
... View more
07-04-2017
05:03 AM
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.
... View more
Labels:
- Labels:
-
Apache Impala