[
https://issues.apache.org/jira/browse/HIVE-16800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16042352#comment-16042352
]
Bing Li commented on HIVE-16800:
--------------------------------
Hi, Vigneshwaran
I think the document you referred to is out-of-date.
Please try the following steps in your cluster (using the commands for RHEL as
an example):
1. Install MySQL
yum -y install mysql-server mysql mysql-devel
2. Start MySQL
/etc/init.d/mysqld start
3. Link or copy mysql-connector-java.jar to hive/lib
4. Set configurations in hive-site.xml
javax.jdo.option.ConnectionDriverName=com.mysql.jdbc.Driver
javax.jdo.option.ConnectionURL=jdbc:mysql://myhost.com/hive?createDatabaseIfNotExist=true
javax.jdo.option.ConnectionUserName=APP
javax.jdo.option.ConnectionPassword=mine
5. Prepare database for HiveMetastore in MySQL
mysql>create database hive;
mysql> grant all on hive.* to 'APP'@'myhost.com' identified by 'mine';
6. Verification on MySQL
mysql -u APP -h myhost.com -p
Type with "mine" as the password
7. Run Hive SchemaTool
hive/bin/schematool -dbType mysql -initSchema
8. Start HiveMetastore
hive/bin/hive --service metastore
> Hive Metastore configuration with Mysql
> ---------------------------------------
>
> Key: HIVE-16800
> URL: https://issues.apache.org/jira/browse/HIVE-16800
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.2
> Reporter: Vigneshwaran
> Assignee: Bing Li
>
> I'm trying to configure MySql as metastore in Hive 1.2.2 by following the
> link https://dzone.com/articles/how-configure-mysql-metastore, but when I'm
> trying to run hive after all the step I'm getting the below errors:
> Exception in thread "main" java.lang.RuntimeException:
> java.lang.RuntimeException: Unable to instantiate
> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
> Caused by: java.lang.RuntimeException: Unable to instantiate
> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
> at
> org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)
> Caused by: java.lang.reflect.InvocationTargetException
> Caused by: javax.jdo.JDOFatalUserException: Exception thrown setting
> persistence propertiesNestedThrowables:
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
