Hi Shinta, If you look at the launcher job's logs, it will have more details. The exit code is coming from HiveCLI (not from Oozie), and it probably printed something to stdout or stderr with the actual problem.
- Robert On Fri, Jan 30, 2015 at 11:10 AM, Shinta Smith <[email protected]> wrote: > 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 > >
