The ports used by the TIBCO ActiveMatrix BusinessWorks Plug-in for Big Data are 50111(WebHCat Server), 50070(Hadoop HDFS). These ports need to be open for basic communication between the plugin and the server.
There could be other ports which will be needed based on different requirements. For detailed port information, please refer to the document provided by the Database vendor.