Re: Can hive 0.8.1 work with hadoop 0.23.0?

2012-02-21 Thread Carl Steinbach
Hi Xiaofeng,

Which mode are you running Hadoop in, e.g. local, pseudo-distributed, or
distributed?

Thanks.

Carl

2012/2/1 张晓峰 zhangxiaofe...@q.com.cn

 Hi,

 ** **

 I installed hadoop 0.23.0 which can work.

 The version of my hive is 0.8.1. The query like ‘select * from tablename’
 can work. But an exception is thrown when executing query like ‘select col1
 form tablename’.

 ** **

 2012-02-01 16:32:20,296 WARN  mapreduce.JobSubmitter
 (JobSubmitter.java:copyAndConfigureFiles(139)) - Use GenericOptionsParser
 for parsing the arguments. Applications should implement Tool for the same.
 

 2012-02-01 16:32:20,389 INFO  mapreduce.JobSubmitter
 (JobSubmitter.java:submitJobInternal(388)) - Cleaning up the staging area
 file:/tmp/hadoop-hadoop/mapred/staging/hadoop-469936305/.staging/job_local_0001
 

 2012-02-01 16:32:20,392 ERROR exec.ExecDriver
 (SessionState.java:printError(380)) - Job Submission failed with exception
 'java.io.FileNotFoundException(File does not exist:
 /home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar)'

 java.io.FileNotFoundException: File does not exist:
 /home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar

 at
 org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:764)
 

 at
 org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.getFileStatus(ClientDistributedCacheManager.java:208)
 

 at
 org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.determineTimestamps(ClientDistributedCacheManager.java:71)
 

 at
 org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.java:246)
 

 at
 org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.java:284)
 

 at
 org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:355)
 

 at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1159)

 at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1156)

 at java.security.AccessController.doPrivileged(Native Method)

 at javax.security.auth.Subject.doAs(Subject.java:396)

 at
 org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1152)
 

 at org.apache.hadoop.mapreduce.Job.submit(Job.java:1156)

 at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:571)
 

 at
 org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:452)

 at
 org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:710)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 

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

 at java.lang.reflect.Method.invoke(Method.java:597)

 at org.apache.hadoop.util.RunJar.main(RunJar.java:189)

 ** **

 Thanks,

 xiaofeng

 ** **



RE: Can hive 0.8.1 work with hadoop 0.23.0?

2012-02-21 Thread hezhiqiang (Ransom)
Hi Xiaofeng,

Backup “hive_exec.jar” in all hadop directory, then delete “hive_exec.jar”. Try 
it.
Because “select *  just use hdfs . And “select col1” will use MapReduce.

Best regards
Ransom.

From: Carl Steinbach [mailto:c...@cloudera.com]
Sent: Tuesday, February 21, 2012 4:45 PM
To: user@hive.apache.org
Subject: Re: Can hive 0.8.1 work with hadoop 0.23.0?

Hi Xiaofeng,

Which mode are you running Hadoop in, e.g. local, pseudo-distributed, or 
distributed?

Thanks.

Carl
2012/2/1 张晓峰 zhangxiaofe...@q.com.cnmailto:zhangxiaofe...@q.com.cn
Hi,

I installed hadoop 0.23.0 which can work.
The version of my hive is 0.8.1. The query like ‘select * from tablename’ can 
work. But an exception is thrown when executing query like ‘select col1 form 
tablename’.

2012-02-01 16:32:20,296 WARN  mapreduce.JobSubmitter 
(JobSubmitter.java:copyAndConfigureFiles(139)) - Use GenericOptionsParser for 
parsing the arguments. Applications should implement Tool for the same.
2012-02-01 16:32:20,389 INFO  mapreduce.JobSubmitter 
(JobSubmitter.java:submitJobInternal(388)) - Cleaning up the staging area 
file:/tmp/hadoop-hadoop/mapred/staging/hadoop-469936305/.staging/job_local_0001
2012-02-01 16:32:20,392 ERROR exec.ExecDriver 
(SessionState.java:printError(380)) - Job Submission failed with exception 
'java.io.FileNotFoundException(File does not exist: 
/home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar)'
java.io.FileNotFoundException: File does not exist: 
/home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar
at 
org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:764)
at 
org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.getFileStatus(ClientDistributedCacheManager.java:208)
at 
org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.determineTimestamps(ClientDistributedCacheManager.java:71)
at 
org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.java:246)
at 
org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.java:284)
at 
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:355)
at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1159)
at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1156)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1152)
at org.apache.hadoop.mapreduce.Job.submit(Job.java:1156)
at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:571)
at 
org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:452)
at org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:710)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:189)

Thanks,
xiaofeng




Can hive 0.8.1 work with hadoop 0.23.0?

2012-02-01 Thread 张晓峰
Hi,

 

I installed hadoop 0.23.0 which can work.

The version of my hive is 0.8.1. The query like ‘select * from tablename’
can work. But an exception is thrown when executing query like ‘select col1
form tablename’.

 

2012-02-01 16:32:20,296 WARN  mapreduce.JobSubmitter
(JobSubmitter.java:copyAndConfigureFiles(139)) - Use GenericOptionsParser
for parsing the arguments. Applications should implement Tool for the same.

2012-02-01 16:32:20,389 INFO  mapreduce.JobSubmitter
(JobSubmitter.java:submitJobInternal(388)) - Cleaning up the staging area
file:/tmp/hadoop-hadoop/mapred/staging/hadoop-469936305/.staging/job_local_0
001

2012-02-01 16:32:20,392 ERROR exec.ExecDriver
(SessionState.java:printError(380)) - Job Submission failed with exception
'java.io.FileNotFoundException(File does not exist:
/home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar)'

java.io.FileNotFoundException: File does not exist:
/home/hadoop/hive-0.8.1/lib/hive-builtins-0.8.1.jar

at
org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSy
stem.java:764)

at
org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.getFileS
tatus(ClientDistributedCacheManager.java:208)

at
org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.determin
eTimestamps(ClientDistributedCacheManager.java:71)

at
org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.
java:246)

at
org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.
java:284)

at
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java
:355)

at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1159)

at org.apache.hadoop.mapreduce.Job$2.run(Job.java:1156)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:396)

at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.ja
va:1152)

at org.apache.hadoop.mapreduce.Job.submit(Job.java:1156)

at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:571)

at
org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:452)

at
org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:710)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

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

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.hadoop.util.RunJar.main(RunJar.java:189)

 

Thanks,

xiaofeng