Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB