Hi, I have written an oozie job with hive action. It completes successfully but does not create a table in hive. When I execute the hive query independently it creates the table. Any help in this regard is appreciated.
Here is the oozie log file : - 2014-04-17 20:35:53,445 INFO ActionStartXCommand:539 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@:start:] Start action [0000016-140415213056450-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10] 2014-04-17 20:35:53,445 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@:start:] [***0000016-140415213056450-oozie-oozi-W@:start:***]Action status=DONE 2014-04-17 20:35:53,446 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@:start:] [***0000016-140415213056450-oozie-oozi-W@:start:***]Action updated in DB! 2014-04-17 20:35:53,601 INFO ActionStartXCommand:539 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] Start action [0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10] 2014-04-17 20:35:54,619 WARN HiveActionExecutor:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] credentials is null for the action 2014-04-17 20:35:57,073 INFO HiveActionExecutor:539 - USER[root] GROUP[-] TOKEN[] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] checking action, external ID [job_1397592572894_0174] status [RUNNING] 2014-04-17 20:35:57,074 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] [***0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging***]Action status=RUNNING 2014-04-17 20:35:57,075 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] [***0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging***]Action updated in DB! 2014-04-17 20:36:29,057 INFO CallbackServlet:539 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] callback for action [0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] 2014-04-17 20:36:29,509 INFO HiveActionExecutor:539 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] action completed, external ID [job_1397592572894_0174] 2014-04-17 20:36:29,542 INFO HiveActionExecutor:539 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@hive-gwcalls-staging] action produced output 2014-04-17 20:36:29,771 INFO ActionStartXCommand:539 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@end] Start action [0000016-140415213056450-oozie-oozi-W@end] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10] 2014-04-17 20:36:29,771 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@end] [***0000016-140415213056450-oozie-oozi-W@end***]Action status=DONE 2014-04-17 20:36:29,772 WARN ActionStartXCommand:542 - USER[root] GROUP[-] TOKEN[-] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[0000016-140415213056450-oozie-oozi-W@end] [***0000016-140415213056450-oozie-oozi-W@end***]Action updated in DB! 2014-04-17 20:36:29,887 WARN CoordActionUpdateXCommand:542 - USER[root] GROUP[-] TOKEN[] APP[hive-gwcalls-insert-wf] JOB[0000016-140415213056450-oozie-oozi-W] ACTION[-] E1100: Command precondition does not hold before execution, [, coord action is null], Error Code: E1100 Thanks, Manish Kothari Oracle Business Analyst Vonage | 23 Main Street | Holmdel, NJ 07733-2136 t: +1.732.203.7613 | BB: +1.848.248.9615 e: [email protected]<mailto:[email protected]> w: www.vonage.com<http://www.vonage.com>
