hi all i exec hive (zh_site)> select id, > longitude, > latitude, > month, > round(avg(sd), 2) as avgsd > from data_zh > where id between '50000' and '60000' > and month = 1 > and hour >= 0 > and hour <= 3 > group by station, longitude, latitude, month > order by station, longitude, latitude, month > limit 1000; Total MapReduce jobs = 2 Launching Job 1 out of 2 first 1 is succfully but the second is error like this my $HIVE_HOME/lib/ exist the hive-builtins-0.10.0-cdh4.3.0.jar why the search from hdfs
java.io.FileNotFoundException: File does not exist: hdfs://hydra0001/opt/module/hive-0.10.0-cdh4.3.0/lib/hive-builtins-0.10.0-cdh4.3.0.jar at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:824) at org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.getFileStatus(ClientDistributedCacheManager.java:288) at org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.getFileStatus(ClientDistributedCacheManager.java:224) at org.apache.hadoop.mapreduce.filecache.ClientDistributedCacheManager.determineTimestamps(ClientDistributedCacheManager.java:93) -- In the Hadoop world, I am just a novice, explore the entire Hadoop ecosystem, I hope one day I can contribute their own code YanBit yankunhad...@gmail.com