We dont have steps realted to IBM Websphere. I am going to provide generic steps : As IBM Webspehre is a java application,so you need a JDBC driver to connect to hive. 1. Download the JDBC driver from Cloudera website https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-15.html 2. Use the driver in the Websphere classpath and check using lsof -p <webspehere pid> | grep <driver name> ==> igf it is loaded after adding 3. In Webspehere Datasource URL ,use hostname of hiveserver2 and port(probably 10000 if binary). The URL looks like as below: jdbc:hive2://<hiveserver host>:10000/default 4. Test the datasource(I was handling Weblogic,and there is an option to test datasource URL) 5. If everything works good,test the application. Note: Please check your Websphere documentation if Hive is a supported database before implementing the above action plan. If your Webspeheis SSL and Kerberos enabled,then the jdbc URL would change,I would suggest to test with non-SSL Websphere.
... View more
