Hi,
     I have installed hadoop-0.19.2  on my system in a pseudo-distributed
mode and I am using hive to access data. When I am trying to access data by
executing a query (i. g.  select * from *"table_name*" ) on hive , it is
giving me a following error.
*FAILED: Unknown exception : java.net.ConnectException: Call to localhost/ 127.0.0.1:54310 failed on connection exception: java.net.ConnectException: Connection refused*
Please help me to sovle this problem.
Thanking You Mohan Agarwal
Mohan Agarwal's gravatar image asked Dec 21 2009 at 04:57 in Hive-User by Mohan Agarwal

4 Answers

Check, your NN and JT are running and you can ssh to the localhost without password.
On Mon, Dec 21, 2009 at 10:34 AM, Mohan Agarwal Hi, > I have installed hadoop-0.19.2 on my system in a pseudo-distributed > mode and I am using hive to access data. When I am trying to access data by > executing a query (i. g. select * from *"table_name*" ) on hive , it is > giving me a following error. > > *FAILED: Unknown exception : java.net.ConnectException: Call to localhost/ > 127.0.0.1:54310 failed on connection exception: java.net.ConnectException: > Connection refused* > > Please help me to sovle this problem. > > Thanking You > Mohan Agarwal >
-- Thanks & Regards, Chandra Prakash Bhagtani, Impetus Infotech (india) Pvt Ltd.
Chandraprakash Bhagtani's gravatar image answered Dec 21 2009 at 06:16 by Chandraprakash Bhagtani
Mohan,
Please take a look at /tmp/<username>/hive.log. It contains the full stack trace of the problem. It seems like a configuration problem.
Zheng
Zheng Shao's gravatar image answered Dec 21 2009 at 08:27 by Zheng Shao
*After starting hadoop , hadoop-hadoop-jobtracker-blueberry.log file is showing the following error*
*2009-12-21 14:59:58,065 INFO org.apache.hadoop.mapred.JobTracker: problem cleaning system directory: null java.net.ConnectException: Call to localhost/127.0.0.1:54310 failed on connection exception: java.net.ConnectException: Connection refused* at org.apache.hadoop.ipc.Client.wrapException(Client.java:724) at org.apache.hadoop.ipc.Client.call(Client.java:700) at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:216) at $Proxy4.getProtocolVersion(Unknown Source) at org.apache.hadoop.ipc.RPC.getProxy(RPC.java:348) at org.apache.hadoop.hdfs.DFSClient.createRPCNamenode(DFSClient.java:104) at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:176) at org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:75) at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:1367) at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:56) at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1379) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:215) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:120) at org.apache.hadoop.mapred.JobTracker.<init>(JobTracker.java:1191) at org.apache.hadoop.mapred.JobTracker.startTracker(JobTracker.java:143) at org.apache.hadoop.mapred.JobTracker.main(JobTracker.java:2910) *Caused by: java.net.ConnectException: Connection refused* at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:574) at sun.nio.ch.SocketAdaptor.connect(SocketAdaptor.java:100) at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:300) at org.apache.hadoop.ipc.Client$Connection.access$1700(Client.java:177) at org.apache.hadoop.ipc.Client.getConnection(Client.java:801) at org.apache.hadoop.ipc.Client.call(Client.java:686) ... 14 more
*And hadoop-hadoop-namenode-blueberry.log is showing *
*2009-12-21 14:59:44,358 ERROR org.apache.hadoop.hdfs.server.namenode.FSNamesystem: FSNamesystem initialization failed. java.io.IOException: Incorrect data format. logVersion is -18 but writables.length is 0. * at org.apache.hadoop.hdfs.server.namenode.FSEditLog.loadFSEdits(FSEditLog.java:542) at org.apache.hadoop.hdfs.server.namenode.FSImage.loadFSEdits(FSImage.java:973) at org.apache.hadoop.hdfs.server.namenode.FSImage.loadFSImage(FSImage.java:793) at org.apache.hadoop.hdfs.server.namenode.FSImage.recoverTransitionRead(FSImage.java:352) at org.apache.hadoop.hdfs.server.namenode.FSDirectory.loadFSImage(FSDirectory.java:87) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.initialize(FSNamesystem.java:309) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.<init>(FSNamesystem.java:288) at org.apache.hadoop.hdfs.server.namenode.NameNode.initialize(NameNode.java:163) at org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:208) at org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:194) at org.apache.hadoop.hdfs.server.namenode.NameNode.createNameNode(NameNode.java:859) at org.apache.hadoop.hdfs.server.namenode.NameNode.main(NameNode.java:868) 2009-12-21 14:59:44,359 INFO org.apache.hadoop.ipc.Server: Stopping server on 54310
Mohan Agarwal's gravatar image answered Dec 21 2009 at 09:52 by Mohan Agarwal
hi Mohan, From the namenode start log, I think your namenode and hdfs start failed. When namenode start ,it will load two editlog file named edits and edits.new, and it seems like these files are broken or the version is not match.I think your problem is not from hive,but from hadoop.
2009/12/21 Mohan Agarwal *After starting hadoop , hadoop-hadoop-jobtracker-blueberry.log file is > showing the following error* > > *2009-12-21 14:59:58,065 INFO org.apache.hadoop.mapred.JobTracker: problem > cleaning system directory: null > > java.net.ConnectException: Call to localhost/127.0.0.1:54310 failed on > connection exception: java.net.ConnectException: Connection refused > * > at org.apache.hadoop.ipc.Client.wrapException(Client.java:724) > at org.apache.hadoop.ipc.Client.call(Client.java:700) > at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:216) > at $Proxy4.getProtocolVersion(Unknown Source) > at org.apache.hadoop.ipc.RPC.getProxy(RPC.java:348) > at > org.apache.hadoop.hdfs.DFSClient.createRPCNamenode(DFSClient.java:104) > at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:176) > at > org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:75) > at > org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:1367) > at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:56) > at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1379) > at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:215) > at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:120) > at org.apache.hadoop.mapred.JobTracker.<init>(JobTracker.java:1191) > at > org.apache.hadoop.mapred.JobTracker.startTracker(JobTracker.java:143) > at org.apache.hadoop.mapred.JobTracker.main(JobTracker.java:2910) > *Caused by: java.net.ConnectException: Connection refused* > at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) > at > sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:574) > at sun.nio.ch.SocketAdaptor.connect(SocketAdaptor.java:100) > at > org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:300) > at org.apache.hadoop.ipc.Client$Connection.access$1700(Client.java:177) > at org.apache.hadoop.ipc.Client.getConnection(Client.java:801) > at org.apache.hadoop.ipc.Client.call(Client.java:686) > ... 14 more > > *And hadoop-hadoop-namenode-blueberry.log is showing * > > *2009-12-21 14:59:44,358 ERROR > org.apache.hadoop.hdfs.server.namenode.FSNamesystem: FSNamesystem > initialization failed. > java.io.IOException: Incorrect data format. logVersion is -18 but > writables.length is 0. * > at > org.apache.hadoop.hdfs.server.namenode.FSEditLog.loadFSEdits(FSEditLog.java:542) > at > org.apache.hadoop.hdfs.server.namenode.FSImage.loadFSEdits(FSImage.java:973) > at > org.apache.hadoop.hdfs.server.namenode.FSImage.loadFSImage(FSImage.java:793) > at > org.apache.hadoop.hdfs.server.namenode.FSImage.recoverTransitionRead(FSImage.java:352) > at > org.apache.hadoop.hdfs.server.namenode.FSDirectory.loadFSImage(FSDirectory.java:87) > at > org.apache.hadoop.hdfs.server.namenode.FSNamesystem.initialize(FSNamesystem.java:309) > at > org.apache.hadoop.hdfs.server.namenode.FSNamesystem.<init>(FSNamesystem.java:288) > at > org.apache.hadoop.hdfs.server.namenode.NameNode.initialize(NameNode.java:163) > at > org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:208) > at > org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:194) > at > org.apache.hadoop.hdfs.server.namenode.NameNode.createNameNode(NameNode.java:859) > at > org.apache.hadoop.hdfs.server.namenode.NameNode.main(NameNode.java:868) > 2009-12-21 14:59:44,359 INFO org.apache.hadoop.ipc.Server: Stopping server > on 54310 > > >
li luo's gravatar image answered Dec 22 2009 at 01:50 by li luo