Rather than using the embedded Hive server that comes with WSO2 BAM by default, you can connect to an external Hive server using the following properties in <BAM_HOME>/repository/conf/advanced/hive-site.xml
file.
hive-site.xml
<property> <name>hive.server.url</name> <value>jdbc:hive://host:port/default</value> </property> <property> <name>hive.server.user</name> <value></value> </property> <property> <name>hive.server.password</name> <value></value> </property>