KNIME EMR Version

bigdata
#1

Hello,
Which version of AWS EMR (for BIG Data ) is supported by KNIME platform and server ?

0 Likes

#2

Hi there!

Not quite sure what you mean by support. Like can you connect to HIVE on newest EMR version? Are you curious about certain application?

Br,
Ivan

0 Likes

#3

Hi,
Sorry for not being so clear earlier. Yes, i meant about the connectivity and accessing the data stored in Hive using knime connectors.

0 Likes

#4

Hi,

no problem. I think you should be able to connect to a Hive in latest EMR using Hive Connector node with no problems.

Creating a connection to Hive depends on JDBC driver which you need to download and add to KNIME preferences. Hive Connector node supports the usage of the Cloudera JDBC drivers. So if you download the latest one you should be able to connect to the last Hive version. From EMR version 5.20.0 (12/2018) Hive&HCatalog version is 2.3.4. and the latest Hive version is 2.3.5.

Here is an example for connecting Hive in EMR with SQL Workbench:
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/HiveJDBCDriver.html

Try it out and if any problems come back and we’ll try to figure it out.

Br,
Ivan

0 Likes