Hello,
I'm having an issue running what I thought was a simple Hive action. I
have a coordinator that watches a directory (/data/daily_dump) and when a
_SUCCESS file appears, it kicks off a workflow running a Hive action with
this script:
CREATE external TABLE IF NOT EXISTS daily_dump (
id bigint,
creationdate timestamp,
datelastupdated timestamp,
data1 string,
data2 string)
LOCATION '/data/daily_dump';
FROM daily_dump d
INSERT OVERWRITE TABLE mydata_orc PARTITION(id, date)
SELECT d.id, d.creationdate, d.datelastupdated, d.data1, d.data2;
DROP TABLE daily_dump;
If I run the script manually from hive CLI, it works fine.
The workflow got kicked off correctly when _SUCCESS file shows up. It
appears the script is halfway executed as I can see from hive CLI that the
table "daily_dump" got created. I can see data in it.
But the statement after that seemed to die in Oozie with this error:
2015-01-30 18:04:40,086 WARN HiveActionExecutor:542 - USER[me] GROUP[-]
TOKEN[] APP[guzzler] JOB[0000162-150114210350250-oozie-oozi-W]
ACTION[0000162-150114210350250-oozie-oozi-W@copy_to_mydata] Launcher
ERROR, reason: Main class [org.apache.oozie.action.hadoop.HiveMain], exit
code [40000]
What does error 40000 mean?
Thanks,
-shinta
