Hi Nitin , How to check this,  you mean to check  hive-site.xml. please 
let me know how to check this.
 




From:   Nitin Pawar <nitinpawar...@gmail.com>
To:     "user@hive.apache.org" <user@hive.apache.org>
Date:   07/09/2015 07:35 PM
Subject:        Re: Hive Query Error



can u check your config? 
host appears twice 01hw357381.tcsgegdc.com: 01hw357381.tcsgegdc.com
it shd be hostname:port 

also once you correct this, you do a nslookup on the host to make sure its 
identified by the hive client 

On Thu, Jul 9, 2015 at 7:19 PM, Ajeet O <ajee...@tcs.com> wrote:
Hi All , I have installed Hadoop 2.0 ,  Hive 0.12  on Cent OS 7. 

When I run a query  in Hive -  select count(*)  from u_data ;  it gives 
following errors.   , However I can run  select  * from u_data ;  pls 
help. 

hive> select count(*) from u_data; 
Total MapReduce jobs = 1 
Launching Job 1 out of 1 
Number of reduce tasks determined at compile time: 1 
In order to change the average load for a reducer (in bytes): 
  set hive.exec.reducers.bytes.per.reducer=<number> 
In order to limit the maximum number of reducers: 
  set hive.exec.reducers.max=<number> 
In order to set a constant number of reducers: 
  set mapred.reduce.tasks=<number> 
java.net.UnknownHostException: 01hw357381.tcsgegdc.com: 
01hw357381.tcsgegdc.com: unknown error 
        at java.net.InetAddress.getLocalHost(InetAddress.java:1484) 
        at 
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:439)
 

        at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1296) 
        at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1293) 
        at java.security.AccessController.doPrivileged(Native Method) 
        at javax.security.auth.Subject.doAs(Subject.java:422) 
        at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
 

        at org.apache.hadoop.mapreduce.Job.submit(Job.java:1293) 
        at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:562) 
        at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:557) 
        at java.security.AccessController.doPrivileged(Native Method) 
        at javax.security.auth.Subject.doAs(Subject.java:422) 
        at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
 

        at 
org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:557) 
        at 
org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:548) 
        at 
org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:425) 
        at 
org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:144) 
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151) 
        at 
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65) 

        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414) 
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192) 
        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020) 
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888) 
        at 
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259) 
        at 
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216) 
        at 
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413) 
        at 
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781) 
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675) 
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614) 
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 

        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 

        at java.lang.reflect.Method.invoke(Method.java:497) 
        at org.apache.hadoop.util.RunJar.run(RunJar.java:221) 
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136) 
Caused by: java.net.UnknownHostException: 01hw357381.tcsgegdc.com: unknown 
error 
        at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) 
        at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:907) 
        at 
java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1302) 
        at java.net.InetAddress.getLocalHost(InetAddress.java:1479) 
        ... 34 more 
Job Submission failed with exception 'java.net.UnknownHostException(
01hw357381.tcsgegdc.com: 01hw357381.tcsgegdc.com: unknown error)' 
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.mr.MapRedTask 

Thanks 
Ajeet

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



-- 
Nitin Pawar

Reply via email to