Error connecting to hive from ireport

My hadoop version is 1.1.1  and so i am using hadoop-0.9.0.I am not able to establish the connection to hive through ireport.

iam getting this error.CCan anyone help me out?

 

 

shankarpanda003's picture
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago

4 Answers:

Is your host name really HOST? The error states that JasperReports is unable to connect. So please verify host name, port, network connection and proxy to verify that you can access the machine running hive.

mrcaffeine's picture
2888
Joined: Nov 10 2008 - 3:38am
Last seen: 5 years 12 months ago

When I am giving localhost also,,it is saying connection refused.Dont know what to do.

shankarpanda003's picture
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago

Can you check the host address and also the database name, even if you change that to localhost the database name I will assume is not 'default'. Also see if localhost is pointing to 127.0.0.1 and Hive is accepting requests at that IP

 

marianol's picture
16388
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 8 months ago

Thanks Marianol. It is solved.Actually before connecting to hive from ireport,first i had to set the hive port=10000 and i should have to start the hiveserver.Thats why that error was coming.And yes it should be localhost instead of HOST 

shankarpanda003's picture
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago
Feedback
randomness