hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gautier vivard <>
Subject select failed in Hive.
Date Mon, 13 May 2013 07:40:38 GMT

I'm beginner in the hadoop world, and more specifically in Hive (I work on
hive-0.9.0 on Ubuntu). I work on MapR M3 in standalone mode. I'm training
on hive and have some issues with one query :

> SELECT year FROM records;
Automatically selecting local only mode for query
Total MapReduce jobs = 1
Launching Job 1 out of 1
Num '"ber of reduce tasks is set to 0
since there's no reduce operator
Execution log at:
/var/mapr/cluster/mapred/jobTracker/staging/mapr406767829/.staging ()
    at Method)
    at org.apache.hadoop.fs.RawLocalFileSystem.setPermission(
    at org.apache.hadoop.fs.RawLocalFileSystem.mkdirs(
    at org.apache.hadoop.fs.FilterFileSystem.mkdirs(
    at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(
    at org.apache.hadoop.mapred.JobClient$
    at org.apache.hadoop.mapred.JobClient$
    at Method)
    at org.apache.hadoop.mapred.JobClient.submitJobInternal(
    at org.apache.hadoop.mapred.JobClient.submitJob(
    at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(
    at org.apache.hadoop.hive.ql.exec.ExecDriver.main(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at org.apache.hadoop.util.RunJar.main(
Job Submission failed with exception
Execution failed with exit status: 2
Obtaining error information

Task failed!
Task ID:


FAILED: Execution Error, return code 2 from

But when I tried :

    > select * from records;

It works fine. I read that's because there is no reduce tasks in this query.
Any idea?



View raw message