hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Jain <ankitjainc...@gmail.com>
Subject Jasper-Hive integration
Date Tue, 31 Jan 2012 10:42:00 GMT
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

Mime
View raw message