I'd like to connect to a Hive 2 server using the Cloudera ODBC driver I have installed on my Mac. Adding new drivers to Knime seems to require .zip or .jar files. But the Cloudera ODBC driver comes as a set of dylibs.
Accessing Hive is quite complicated because it requires a bunch of extra libraries. You can either use our new Hive connector nodes or try the steps described in http://tech.knime.org/node/20858. I wouldn't use the ODBC driver, JDBC is much better suited for Java programs ;-).