Can we setup and use KNIME in HDP

[#1]

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.

[#2 · Accepted solution]

@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

[#3]

Thanks @Shelton ,it helps!