Error connecting to hive from ireport
Posted on January 15, 2013 at 10:20pm
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?
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago
Posted on January 16, 2013 at 1:59am
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.
Joined: Nov 10 2008 - 3:38am
Last seen: 5 years 12 months ago
Posted on January 16, 2013 at 2:10am
When I am giving localhost also,,it is saying connection refused.Dont know what to do.
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago
Posted on January 16, 2013 at 8:10am
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
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 8 months ago
Posted on January 16, 2013 at 9:18am
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
Joined: Sep 4 2012 - 9:54pm
Last seen: 9 years 3 months ago