...
| Info |
|---|
Property name “user” indicates the username of the MySQL server and “password” as name implies the password of the MYSQL server. Please edit the configuration accordingly for your MySQL set-up. |
Setting up Hive
In this section you have to point the hive meta data store URL in the hive-site.xml. Please follow the below instructions for that.
Go to $BAM_HOME/repository/conf/advanced/hive-site.xml if you are using unix based machine. If you are using windows machine, please edit the hive-site-win.xml.
Please edit the following properties.
| No Format |
|---|
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/metastore_db</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
............
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>password to use against metastore database</description>
</property>
|