Its because your oozie hive action is not connecting to the hive metastore. You need to start the hive metastore service. Refer https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin Once you start your remote metastore, make the required changes in the hive-site.xml which your oozie application is using. This includes changing the property hive.metastore.uris to point to the remote metastore. This should work.
On Thu, Apr 17, 2014 at 1:51 PM, Manish Kothari <[email protected]>wrote: > 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> > >
