...
| Info |
|---|
Make sure you have downloaded the MySQL driver jar and included that in $BAM_HOME/repository/components/lib directory. |
If you are going to use mysql server to write the summarised data of hive query, then you should include the my sql driver in the $BAM_HOME/repository/conf/advanced/hive-site.xml and include the driver in $BAM_HOME/repository/components/lib directory. you need to include the my sql driver jar to the hive auxiliary jars properties, as shown below and restart the server. Please note that x.x.x is mysql driver version, and you should include your correct name/path to your mysql driver path.
property>
<name>hive.aux.jars.path</name>
<value>file://${CARBON_HOME}/repository/components/plugins/apache-cassandra_1.1.3.wso2v2.jar,file://${CARBON_HOME}/repository/components/plugins/guava_12.0.0.wso2v1.jar,file://${CARBON_HOME}/repository/components/plugins/json_2.0.0.wso2v1.jar,file://${CARBON_HOME}/repository/components/plugins/commons-dbcp_1.4.0.wso2v1.jar,file://${CARBON_HOME}/repository/components/plugins/commons-pool_1.5.6.wso2v1.jar,file://${CARBON_HOME}/repository/components/lib/mysql-connector-java-x.x.x.bin.jar</value>
</property>
If you have done all the steps mentioned above, then you have configured BAM to operate in MT mode. Now you can restart the server get all configurations loaded, and work in MT mode.