question Re: Can we setup and use KNIME in HDP in Support Questions

Can we setup and use KNIME in HDP

shashank_naresh — Sat, 07 Sep 2019 19:14:00 GMT

Hi,

Just wanted to know if we can setup and use KNIME (A visual data analytics tool). I've tried to install in HDP 3.0 with the help of link "https://docs.knime.com/2018-12/server_installation_guide/index.html". Installation was successful but when I was trying to use link sandbox-hdf.hortonworks.com:8090, it was not connecting. In error log file I could see that "tomcat" was not able to connect localhost:8005. Not sure if this was the reason.

Please let me know if anyone used KNIME in HDP sandbox. Or any Visual Data Analytics tool you have used.

Thanks.

Re: Can we setup and use KNIME in HDP

Shelton — Sun, 08 Sep 2019 12:08:55 GMT

@shashank_naresh

The compatibility states that KNIME Big Data Connectors are certified by Cloudera for CDH 5.x, by Hortonworks for HDP 2.1 to 2.4 but should be valid also for later versions as well as MapR for MapR 4.1. with Hive 0.13.

It seems you are trying to access Knime UI withing HDP, that is not possible, the essence is to connect and work with the data. So the most appropriate access required is to the DWH over HDFS which in your case is Hive.
Question How are you trying to connect to Knime? You should use JDBC check Big Data Extensions can be purchased at http://www.knime.org/knime-big-data-extensions.

Refs:

https://www.knime.com/knime-big-data-connectors

https://hortonworks.com/wp-content/uploads/2014/12/Knime-Hortonworks-Solutions-Brief.pdf

Hope that helps

Re: Can we setup and use KNIME in HDP

shashank_naresh — Mon, 09 Sep 2019 18:19:44 GMT

Thanks @Shelton ,it helps!