You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Dénes Bodó (Jira)" <ji...@apache.org> on 2021/06/22 14:24:00 UTC
[jira] [Resolved] (OOZIE-1265) hive command fails from shell action
- Wrong metastore reference
[ https://issues.apache.org/jira/browse/OOZIE-1265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dénes Bodó resolved OOZIE-1265.
-------------------------------
Resolution: Cannot Reproduce
This ticket seems abandoned. If you feel that this still an issue in Oozie 5 then please reopen.
> hive command fails from shell action - Wrong metastore reference
> ----------------------------------------------------------------
>
> Key: OOZIE-1265
> URL: https://issues.apache.org/jira/browse/OOZIE-1265
> Project: Oozie
> Issue Type: Bug
> Components: action
> Affects Versions: 3.2.0
> Environment: CDH 4.1
> Reporter: Sujesh Chirackkal
> Priority: Minor
>
> Created a shell action. Trying to call hive -e from the shell script. But hive command refers to Derby instead of MySql.
> Actual metastore is MySQL.
> But hive query fails saying "can not fetch table" for select query.
> Tried to create a table from the script,and got the following exception.
> FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details.
> NestedThrowables:
> java.sql.SQLException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details.
> Set the properties in shell action as following. But still getting the same exception.
> <property>
> <name>javax.jdo.option.ConnectionURL</name>
> <value>jdbc:mysql://hostname:3306/hive</value>
> </property>
> <property> <name>javax.jdo.option.ConnectionDriverName</name>
> <value>com.mysql.jdbc.Driver</value>
> </property>
> <property> <name>javax.jdo.option.ConnectionUserName</name>
> <value>hive</value>
> </property>
> <property> <name>javax.jdo.option.ConnectionPassword</name>
> <value>password123</value>
> </property>
> <property>
> <name>datanucleus.fixedDatastore</name>
> <value>true</value>
> </property>
> Thanks,
> Sujesh
--
This message was sent by Atlassian Jira
(v8.3.4#803005)