Robert, Yes, hi, same Paul. Apologies if cross-posting is discouraged.
What are my options for continuing to use Hive? We did restart the original hive-server instance, but didn't seem to help. What do I need to do to point at the old instance (which does not currently appear to be interfering with hive-server2)? Thanks, Paul -----Original Message----- From: Robert Kanter [mailto:[email protected]] Sent: Monday, March 04, 2013 4:04 PM To: [email protected] Subject: Re: Hive action failing after upgrade to hive-server2 Hi Paul, Is this same issue that you were asking about in the CDH-User list? (is this the same Paul?) Unfortunately, the Hive action in Oozie isn't compatible with Hive Server 2. We are working on this and we hope (though I cannot promise) it will be done for CDH 4.3. Hi Edward, The reason that your Hive action isn't the default is because we didn't know it existed. If you'd like to contribute your Hive action back to Oozie, please create a JIRA on https://issues.apache.org/jira/browse/OOZIEexplaining why your Hive action is better and post a patch; we're always looking for more contributions. Also, I'm just curious, what is the advantage of your 2 shell actions over the built-in shell action? thanks - Robert On Mon, Mar 4, 2013 at 2:31 PM, Edward Capriolo <[email protected]>wrote: > Understood. Hive-thift-2 is NOT compatible with hive-thrift so getting > it to work out of the box will be impossible. You will have to at > least update some oozie jars. > > Edward > > On Mon, Mar 4, 2013 at 5:05 PM, Paul Chavez < > [email protected] > > wrote: > > > I agree this should be easier. However as just an oozie user and not > > an administrator of the stack I am not in a position to implement > > the workaround you linked. This needs to work with what's provided > > with CDH > 4.2 > > out of the box. Is this the wrong list? > > > > > > -----Original Message----- > > From: Edward Capriolo [mailto:[email protected]] > > Sent: Monday, March 04, 2013 10:51 AM > > To: [email protected] > > Subject: Re: Hive action failing after upgrade to hive-server2 > > > > now that all the concurrency bugs are "solved" with hive server 2, I > > see no reason why the lighter thrift action I made is not the default. > > > > > > > http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/hive_and_ooz > ie_featuring_hive > > > > > > > > On Mon, Mar 4, 2013 at 1:40 PM, Paul Chavez < > > [email protected] > > > wrote: > > > > > Hello, > > > > > > I've had some coordinators running since the first of this year > > > that run a nightly sqoop and then some hive scripts afterward. > > > Last week our cluster was upgraded to CDH 4.2 and HDFS HA, since > > > then the actions fail on the first data load step. We also have > > > always had a MySQL metastore database for hive. > > > > > > I'm pretty sure the issue lies with accessing the metastore, since > > > the first LOAD statement actually moves the files to the new > > > location but then fails with a qlMove exeption and the partition > > > never appears in the table list. > > > > > > Previously I was attaching 4 javax.jod.option properties > > > (ConnectionURL, ConnectionDriveName, ConnectionUserName, > > > ConnectionUserPassword) to the hive action itself to get this to work. > > > So far I have verified that the MySQL connector JAR is still in > > > the oozie share lib as it was before. If I remove the 4 jdo > > > properties I get a 'table not found' error. I recently updated the > > > connectionURL slightly to the new format in hive-site.xml > > > (appending some query params for encoding) and now I get a > > > 'Exception while processing > > '<table_name>'. > > > > > > Previously hive was managed by 'us', now it's integrated with CM 4.5. > > > We also moved from hive-server to hive-server2. I know a lot of > > > things changed at once, so hoping for some guidance as I'm a bit > > > lost as to what needs to be fixed here. > > > > > > thank you, > > > Paul Chavez > > > > > > > > >
