In order to connect to an external Hive server, rather than using the embedded Hive server which is shipped with WSO2 BAM, the following properties at "hive-site.xml" can be modified to connect to the external Hive server.
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>