Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 85987D55C for ; Sat, 27 Oct 2012 10:01:38 +0000 (UTC) Received: (qmail 96675 invoked by uid 500); 27 Oct 2012 10:01:37 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 95931 invoked by uid 500); 27 Oct 2012 10:01:36 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 95711 invoked by uid 99); 27 Oct 2012 10:01:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Oct 2012 10:01:35 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=NORMAL_HTTP_TO_IP,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [203.91.198.79] (HELO wipro-blr-mx03.wipro.com) (203.91.198.79) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Oct 2012 10:01:29 +0000 X-AuditID: 0ac9321f-b7f8c6d000005a3a-2e-508bb0e0515e Received: from BLR-OUT-EDG01.wipro.com ( [203.91.193.31]) (using TLS with cipher AES128-SHA (128/128 bits)) (Client did not present a certificate) by wipro-blr-mx03.wipro.com (Symantec Messaging Gateway) with SMTP id ED.15.23098.0E0BB805; Sat, 27 Oct 2012 15:31:05 +0530 (IST) Received: from BLR-EC-MBX3.wipro.com (10.208.51.113) by BLR-OUT-EDG01.wipro.com (203.91.193.31) with Microsoft SMTP Server (TLS) id 14.2.318.1; Sat, 27 Oct 2012 15:33:03 +0530 Received: from BLR-SJP-MBX-4.wipro.com (10.102.50.144) by BLR-EC-MBX3.wipro.com (10.208.51.113) with Microsoft SMTP Server (TLS) id 14.2.318.1; Sat, 27 Oct 2012 15:31:04 +0530 Received: from BLR-SJP-MBX-6.wipro.com ([169.254.5.41]) by BLR-SJP-MBX-4.wipro.com ([169.254.3.202]) with mapi id 14.02.0318.001; Sat, 27 Oct 2012 15:30:42 +0530 From: To: , Subject: RE: FAILED: Hive Internal Error Thread-Topic: FAILED: Hive Internal Error Thread-Index: AQHNtCftrGkIPyDADE2fBwSS3pdj+JfM61Ec Date: Sat, 27 Oct 2012 10:00:42 +0000 Message-ID: <765C20A3B9276145875E35CED1AED0472AD960D3@BLR-SJP-MBX-6.wipro.com> References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.201.45.89] Content-Type: text/plain; charset="us-ascii" content-transfer-encoding: quoted-printable MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFprGKsWRmVeSWpSXmKPExsVyOvqgvO7DDd0BBudPcli0flnFatHa+4zN gclj+u9FjAGMUQ2MNol5efkliSWpCimpxcm2SuGZBUX5Ci6Zxck5iZm5qUVKCpkptkpGSgoF OYnJqbmpeSW2SokFBal5KUp2XAoYwAaoLDNPITUvOT8lMy/dVskz2F/XwsLUUtdQyS4kI1Uh My8tvyg3sSQzP08hOT+vJOEKT8aG3vfsBZ+VK1qnfmVrYPyv0MXIySEhYCJxceIUZghbTOLC vfVsXYxcHEICs5gkHkzqYYdwNjNKbH7ahOD0rX4L5SxllDj/dBYrSD+bgKxE176lYLaIgKHE xe1TWUBsYQENidtrN0HFNSX2dZxhgrCNJG6eOQVmswioSsxbvhvsDl4BP4nPm89A3TGVUeL7 0iXsIAlOgUCJ2U9ngtmMQMd+P7UGrJlZQFzi1pP5TBBPCEgs2XMe6iFRiZeP/7FC2AoSvd8O skPU60gs2P2JDcLWlli28DXUYkGJkzOfgB0tJKAk0b7wA/sERolZSFbMQtI+C0n7LCTtCxhZ VjFKlINiWDcpp0g3t8LAWA/M1UvOz93ECEwxXCeN5HcwHrqjfIjRFej3icxS3KBYAkZ7vLGB AW6Okjgvk2dpgJBAOjApZaemFqQWxReV5qQWH2Jk4uCUamAMmHvSyjN6vow/34fAU1MXnJZS Olb/TE3nZ8tBTsb5rU03Dm58bDwx8I6zdLaySVutfSC7byuT34LpAlcvO69jvd8S6cPxZ9PR h98nBYvyrG61dbv3LXXqgZa7CocUU37oL678lcj1SIBnr/GJX0/arU9cm7Xv3baTO5r8Sua9 Das/9ndTusUxJZbijERDLeai4kQA6aDlVikDAAA= X-Virus-Checked: Checked by ClamAV on apache.org Can you do a JPS and check all the deamons running fine? If yes check your JT web UI is up or not. Thanks, Ashok ________________________________________ From: sagar nikam [sagarnikam123@gmail.com] Sent: Saturday, October 27, 2012 3:14 PM To: user@hive.apache.org; dev@hive.apache.org Subject: Re: FAILED: Hive Internal Error Respected Sir/Madam, I have installed Hadoop on my ubuntu 12.04 system i installed HIVE also.for some days it works fine..but one day i directly sh= utdown my machine (with closing hive & hadoop) now i am running some query..it throws error (query like "show databases","u= se database_name" works fine) but for below hive> select count(*) from cidade; Error thrown:- FAILED: Hive Internal Error: java.lang.RuntimeException(java.net.ConnectExce= ption: Call to localhost/127.0.0.1:54310 failed on c= onnection exception: java.net.ConnectException: Connection refused) java.lang.RuntimeException: java.net.ConnectException: Call to localhost/127= .0.0.1:54310 failed on connection exception: java.ne= t.ConnectException: Connection refused at org.apache.hadoop.hive.ql.Context.getScratchDir(Context.java:151) at org.apache.hadoop.hive.ql.Context.getMRScratchDir(Context.java:190) at org.apache.hadoop.hive.ql.Context.getMRTmpFileURI(Context.java:247) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnal= yzer.java:900) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(Semantic= Analyzer.java:6594) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemantic= Analyzer.java:238) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: java.net.ConnectException: Call to localhost/127.0.0.1:54310 failed on connection exception: java.net.ConnectExceptio= n: Connection refused at org.apache.hadoop.ipc.Client.wrapException(Client.java:767) at org.apache.hadoop.ipc.Client.call(Client.java:743) at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:220) at $Proxy4.getProtocolVersion(Unknown Source) at org.apache.hadoop.ipc.RPC.getProxy(RPC.java:359) at org.apache.hadoop.hdfs.DFSClient.createRPCNamenode(DFSClient.java:106) at org.apache.hadoop.hdfs.DFSClient.(DFSClient.java:207) at org.apache.hadoop.hdfs.DFSClient.(DFSClient.java:170) at org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSy= stem.java:82) at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:1378) at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:66) at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1390) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:196) at org.apache.hadoop.fs.Path.getFileSystem(Path.java:175) at org.apache.hadoop.hive.ql.Context.getScratchDir(Context.java:145) ... 15 more Caused by: java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:567) at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.jav= a:206) at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:404) at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:304) at org.apache.hadoop.ipc.Client$Connection.access$1700(Client.java:176) at org.apache.hadoop.ipc.Client.getConnection(Client.java:860) at org.apache.hadoop.ipc.Client.call(Client.java:720) ... 28 more =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D is it that ,some files may damage during shutdown ? what could be the error ? The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and may= contain proprietary, confidential or privileged information. If you are not= the intended recipient, you should not disseminate, distribute or copy this= e-mail. Please notify the sender immediately and destroy all copies of this= message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should= check this email and any attachments for the presence of viruses. The compa= ny accepts no liability for any damage caused by any virus transmitted by th= is email. www.wipro.com