Hive connection - Data Preview/Read error


Although my connection to hive succeeds including reading of field names but when I try to query/preview the data - we get the following error:


    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(
    at net.sf.jasperreports.engine.fill.JRFiller.fill(
    at net.sf.jasperreports.engine.JasperFillManager.fill(
    at Source)
    at$ Source)


saigalr's picture
Joined: Jan 24 2013 - 12:02am
Last seen: 8 years 9 months ago
Which version are you on? I just successfully made a Hive report in studio 1.3.3
ernestoo - 9 years 5 months ago
1.3.3 the connection is successful but the retrieving/preview the data returns the above mentioned error
saigalr - 9 years 5 months ago

2 Answers:

I'm pretty sure that the reason you are getting this exception is because in the "Language" combo box there is the SQL one selected.
Please choose "HiveQL". This should solve your problem.

Let me know.
Best regards,

mrabbi's picture
Joined: Oct 31 2011 - 9:20am
Last seen: 1 day 20 hours ago

Solution - Works !!

Will the same work if I connect to impala over port 21000 ?

saigalr - 9 years 5 months ago

I think it should work.
However I'll point to this topic someone who works everyday with BigData stuff.
Maybe he had the chance to test it in the past and can for sure give you a more detailed answer.

Best regards,

P.S: just in case, did you give it a try?

mrabbi - 9 years 5 months ago


I did give it a try. Although the connection was successful but the connection over port 21000 or rather impala does not return any data.

saigalr - 9 years 4 months ago
show 3 more...

Impala is not tested with the Jaspersoft Hive Connector. Impala "works like Hive". So in principle it should just work. Your test was reasonable. But it's easy to imagine the possibility of version conflicts with these technologies. Jaspersoft will certainly test with Impala, but an exact timeline is not established yet.

mdahlman - 9 years 4 months ago

Thanks! Will look out for an update once the same has been tested with Impala

saigalr - 9 years 4 months ago

Any news since ? I have tried to connect with Impala, it still doesn't work. I've got some issues too with CDH Hive 0.10.x. It won't connect to Hiveserver2 i think. Has anyone tried with a CDH 4.2.X distribution ?

nphung - 9 years 1 month ago


I am facing the same issue of null pointer exception.

and even I make the Language HiveQL the error is same, do we need to configure jasper in some other aspects like driver and all?

also there is somethingh like hive -e ' query goes here'. I tried doing this to, but did'nt worked for me.

Please help.


Rishabh Shah

rishabh.shah2659's picture
Joined: Jan 24 2013 - 2:18am
Last seen: 8 years 8 months ago