Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Unable to execute a query in hive


Copy link to this message
-
Re: Unable to execute a query in hive
Mohammad Tariq 2013-06-27, 20:01
Yes. It'll. Have you changed all the env. vars, like HADOOP_HOME, HIEV_HOME
etc according to your new environment?

Warm Regards,
Tariq
cloudfront.blogspot.com
On Thu, Jun 27, 2013 at 11:43 PM, Manickam P <[EMAIL PROTECTED]> wrote:

> Hi Tariq,
>
> It is a very simple query like select * from table.
> Actually i've moved my masternode node from one server to another. I
> copied all the hadoop temp files and dfs data directory.
> Then i installed hive in the same machine and configured.  i'm getting
> exception while executing the query it throws error.
> will it create any problem here?
>
>
> Thanks,
> Manickam P
> ------------------------------
> From: [EMAIL PROTECTED]
> Date: Thu, 27 Jun 2013 23:37:58 +0530
>
> Subject: Re: Unable to execute a query in hive
> To: [EMAIL PROTECTED]
>
> What's your query?
>
> Warm Regards,
> Tariq
> cloudfront.blogspot.com
>
>
> On Thu, Jun 27, 2013 at 11:17 PM, Manickam P <[EMAIL PROTECTED]>wrote:
>
> Hi,
>
> I checked all the nodes. All  are up and running. normal hive queries like
> show tables are working fine. Queries with map reduce is throwing exception.
>
>
> Thanks,
> Manickam P
>
>
> ------------------------------
> From: [EMAIL PROTECTED]
> Date: Thu, 27 Jun 2013 21:59:22 +0530
> Subject: Re: Unable to execute a query in hive
> To: [EMAIL PROTECTED]
>
>
> Hello Manickam,
>
>            Please make sure your hadoop daemons are running.
>
> Warm Regards,
> Tariq
> cloudfront.blogspot.com
>
>
> On Thu, Jun 27, 2013 at 9:55 PM, Manickam P <[EMAIL PROTECTED]>wrote:
>
> Hi,
>
> I tried to execute a query in hive but i got the below exception. I dont
> know the reason.
> Please help me to resolve the issue.
>
> java.net.ConnectException: Call to 192.168.99.33/192.168.99.33:50000failed on connection exception: java.net.ConnectException: Connection
> refused
>         at org.apache.hadoop.ipc.Client.wrapException(Client.java:1095)
>         at org.apache.hadoop.ipc.Client.call(Client.java:1071)
>         at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:225)
>         at $Proxy6.getProtocolVersion(Unknown Source)
>         at org.apache.hadoop.ipc.RPC.getProxy(RPC.java:396)
>         at org.apache.hadoop.ipc.RPC.getProxy(RPC.java:379)
>         at
> org.apache.hadoop.hdfs.DFSClient.createRPCNamenode(DFSClient.java:119)
>         at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:238)
>         at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:203)
>         at
> org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:89)
>         at
> org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:1386)
>         at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:66)
>         at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1404)
>         at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:254)
>         at org.apache.hadoop.fs.Path.getFileSystem(Path.java:187)
>         at
> org.apache.hadoop.hive.ql.exec.Utilities.isEmptyPath(Utilities.java:1814)
>         at
> org.apache.hadoop.hive.ql.exec.Utilities.isEmptyPath(Utilities.java:1810)
>         at
> org.apache.hadoop.hive.ql.exec.ExecDriver.addInputPaths(ExecDriver.java:876)
>         at
> org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:409)
>         at
> org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:137)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
>         at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)