hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <>
Subject RE: [hive-users] insert overwrite local directory syntax?
Date Thu, 20 Nov 2008 16:30:30 GMT
Moving to the apache mailing list.

I think you are using a wrong version of hive. validateInput was not present in the 0.18 and
0.19 versions of hadoop. It seems that you are using a 0.17 version of hive with one of those
versions of hadoop.

From: []
On Behalf Of tim robertson []
Sent: Thursday, November 20, 2008 7:19 AM
Subject: [hive-users] insert overwrite local directory syntax?

Hi All,

I'm trying to select into a local file but getting a 255 error.  Are
the errors defined anywhere public?
(I am using the tutorial:
which has this syntax)



hive> INSERT OVERWRITE LOCAL DIRECTORY '/tmp/delme' select
occurrence_record.* from occurrence_record;
Total MapReduce jobs = 1
08/11/20 16:14:12 WARN exec.ExecDriver: Number of reduce tasks not
specified. Defaulting to 0 since there's no reduce operator
08/11/20 16:14:12 INFO exec.ExecDriver: Adding input file
08/11/20 16:14:12 INFO jvm.JvmMetrics: Initializing JVM Metrics with
processName=JobTracker, sessionId=
        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(
        at org.apache.hadoop.mapred.JobShell.main(

FAILED: Execution Error, return code 255 from
Time taken: 2.149 seconds
hive-users mailing list

View raw message