You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ankit Jain <an...@gmail.com> on 2012/01/31 11:42:00 UTC
Jasper-Hive integration
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.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)
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.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.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 by: 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
Re: Jasper-Hive integration
Posted by Rohit Bakhshi <ro...@hortonworks.com>.
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