Hi Ankit,
While I've never used Jasper to connect to Hive, I have come across this
problem when connecting other BI applications like Pentaho with Hive.
The error is usually caused by a mismatch of JAR libraries used - often the JAR
packaged with the BI application is for a different version of Hive than what
is being connected to.
Hope that helps pinpoint the cause.
--
Rohit Bakhshi
Solution Architect | Hortonworks
On Tuesday, January 31, 2012 at 2:42 AM, Ankit Jain wrote:
> Hi all,
>
> I am trying to generate report using Jasper (Hive as datasource) but got the
> below error.
>
> Error filling print... Unable to get next record.
> Hive history file=/tmp/ankit/hive_job_log_ankit_201201311554_1714305748.txt
> HiveServerException(message:OK, errorCode:0, SQLState:) at
> org.apache.hadoop.hive.service.ThriftHive$fetchOne_result.read(ThriftHive.java:2031)
> at
> org.apache.hadoop.hive.service.ThriftHive$Client.recv_fetchOne(ThriftHive.java:155)
> at
> org.apache.hadoop.hive.service.ThriftHive$Client.fetchOne(ThriftHive.java:131)
> at
> org.apache.hadoop.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:132)
> at
> net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:944)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:857)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:837)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1434)
> at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillR
eport(JR
VerticalFiller.java:130) at
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
at
com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:879)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
net.sf.jasperreports.engine.JRException: Unable to get next record. at
net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:103)
at
net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:944)
at net.sf.jasperreports.en
gine.fil
l.JRFillDataset.next(JRFillDataset.java:857) at
net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:837)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1434)
at
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:130)
at
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
at
com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:879)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Caused b
y: java.
sql.SQLException: Error retrieving next row at
org.apache.hadoop.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:158)
at
net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99)
... 13 more
> Print not filled. Try to use an EmptyDataSource...
>
> need your help...
>
> Thanks,
> Ankit Jain
