arpanbaruah Posted July 18, 2011 Share Posted July 18, 2011 Hi thereI have created a report using ireport and hive jdbc connection.I followed the steps mentioned with jasperserver installation . I published the same ireport to server. It seems the server is giving a JDBC error. The server is installed on the same hive server.I am not sure whats going onAttached is the error description Link to comment Share on other sites More sharing options...
mdahlman Posted July 19, 2011 Share Posted July 19, 2011 What version of the Hive connector are you using? What version of Hive? What version of JasperReports Server?Did the report work correctly in iReport?The most common mistake I have seen is that users accidentally use the query language "SQL" when what's needed is "HiveSQL". Any chance that you're doing this?Regards,Matt Link to comment Share on other sites More sharing options...
mdahlman Posted July 19, 2011 Share Posted July 19, 2011 arpanbaruah,I see that you posted a different thread first. In that thread it looks like you hadn't deployed the Hive connector to JasperReports Server. Please list out the steps that you've done so for so that we can make a better guess at where the problem is coming from.Regards,Matt Link to comment Share on other sites More sharing options...
arpanbaruah Posted July 19, 2011 Author Share Posted July 19, 2011 Hi Matt, Jasper Server Version - cp-4.1.0ireport - Using the same with the bundle (IReport Designer 4.0.2)Yes , earlier posting was my mistake. I forgot to update the WEB-INF folder with the Hive JDBC WEB-INF folder Steps to configure JasperServer Installed JasperServer 4.10 with MySQL, Tomcat and ireportUpdated the WEB-INF folder with http://jasperforge.org/plugins/esp_frs/file.php?id=117&group_id=428&relid=86 WEB-INFAdded the ireport Hive JDBC plugin. Created a report using ireport. The report runs fine on ireportAdded the server repository and published the ireport to the jasper server.Created a JDBC Datasource. The JDBC passes Connection test.Login to Jasperserver, Edit the published report , add datasource - > Hive Data source Run the reports.It gives the error as mentioned on my previous email Let me know if i am missing out any step. Thanks AB Link to comment Share on other sites More sharing options...
arpanbaruah Posted July 19, 2011 Author Share Posted July 19, 2011 I am desperatly trying to make it work.Did it ever worked with Hive connection for any body.If yes , please let me know. I demo design is in the end stage and seems like this solution just wont crack Thanks -AB Link to comment Share on other sites More sharing options...
mdahlman Posted July 20, 2011 Share Posted July 20, 2011 "Created a JDBC Datasource. The JDBC passes Connection test."You should not create a JDBC Data Source. This is probably the problem. You need to create a data source of type "Hadoop-Hive Data Source".Let us know if that fixes it.Regards,Matt Link to comment Share on other sites More sharing options...
arpanbaruah Posted July 26, 2011 Author Share Posted July 26, 2011 Thanks Matt, It is working now. I am back on my jasper eval. Thanks again It seems though there is no test Connection button to check whether the connection is working or not. Also when i tried running the hive connection report on jasperserver , it didnt show the prompt.(parameter) which i included.The report didnt pull any data. When i remove the parameter the report runs just fine. It seems Hive JDBC with jasperserver cannot handle parameters Thanks AB Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now