> Job Submission failed with exception 'Input path doesnt exist : > hdfs://somehost:9000/tmp/hive-someuser/183603784.10002'
Again, looks like the query is trying to access hdfs rather than local directory. Can you paste the output of describe extended game_start? On 7/8/09 5:10 PM, "RSD" <[email protected]> wrote: > hive> describe game_start; > > > recordtime string > user_id int > session_id string > host string > release string > source string > ip string > ip_country string > game_id int > challenge int > suggestion_rank int > language string > day string > hive> select a.game_id, count(distinct(a.user_id)), count(1) from > game_start a where a.day >= '2009-06-01' and a.day < '2009-06-03' and > (a.game_id = 501 or a.game_id = 502 or a.game_id = 504 or a.game_id = > 505 or a.game_id = 563) group by a.game_id; > Total MapReduce jobs = 2 > Starting Job = job_200907071612_0568, Tracking URL = > http://somehost:50030/jobdetails.jsp?jobid=job_200907071612_0568 > Kill Command = /home/analytics/hadoop/dist/current/bin/hadoop job > -Dmapred.job.tracker=somehost:9001 -kill job_200907071612_0568 > ... > Ended Job = job_200907071612_0568 > Job Submission failed with exception 'Input path doesnt exist : > hdfs://somehost:9000/tmp/hive-someuser/183603784.10002' > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.ExecDriver > > there is a local directory /tmp/hive-someuser (and in > /tmp/someuser/hive.log is where i am logging)... > > is there something wrong with the syntax of the query?
