RE: Oozie job with hive action completes successfully but does not create table

2014-04-22 Thread Manish Kothari
] Sent: Thursday, April 17, 2014 5:40 PM To: user@oozie.apache.org Subject: Re: Oozie job with hive action completes successfully but does not create table Try adding hive-site.xml to your hive action. Also make sure that the metastore uri:port is reachable from all the machines on your hadoop

Re: Oozie job with hive action completes successfully but does not create table

2014-04-17 Thread Amit Patil
> fs.file.impl.disable.cache > true > > > hive.security.authorization.manager > > org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider > > > hive.metastore.execute.setugi > true > > >

RE: Oozie job with hive action completes successfully but does not create table

2014-04-17 Thread Manish Kothari
-Original Message- From: Amit Patil [mailto:arpa...@skyhighnetworks.com] Sent: Thursday, April 17, 2014 4:56 PM To: user@oozie.apache.org Subject: Re: Oozie job with hive action completes successfully but does not create table Its because your oozie hive action is not connecting to the hiv

Re: Oozie job with hive action completes successfully but does not create table

2014-04-17 Thread Amit Patil
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