I need to connect to an Hadoop table throught Impala Connector.
I know that the server is protected with Kerberos, but I want to bypass it.
I also use Microsoft Power BI and I have reached the goal using the Windows Authentication.
Can someone help me to “translate” the following info to configure the Impala Connector in Knime? the following configuration works perfectly in Microsoft Power BI only using the host name and setting the Windows current credentials.
currently there is no good way in KNIME to use the Kerberos ticket that your machine obtained during Windows login. This is an unfortunate limitation of the Java platform that KNIME is built upon.
Have you considered our blog post on this topic?
It walks you through the necessary steps of getting a Kerberos ticket that KNIME can read and then setting up the connector nodes.
To answer your more specific questions:
Is it correct the ODBC driver? Have I to install the JDBC one?
The Impala Connector node does not support ODBC drivers. It supports two different JDBC drivers:
The built-in JBDC driver for Hive/Impala (here you don’t have to install any drivers yourself. The driver comes with the node). This is recommended.
How to configure the Impala Connector node to use the Windows credential Authentication?
As I wrote above, currently there is no good way in KNIME to use the Kerberos ticket that your machine obtained during Windows login. You have to follow the steps from the blog post to get a new ticket that is stored in a file cache.
I wrote the topic only because I wanted to investigate about different ways in approaching to the problem!
By your reply I have understood that:
It is recommended to use the built-in JDBC driver (The procedure File > Preferences > KNIME > Databases > Add file/directory it is not necessary, right? Maybe do I have to add file/directory from the KNIME path?);
It is recommended to use the built-in JDBC driver (The procedure File > Preferences > KNIME > Databases > Add file/directory it is not necessary, right? Maybe do I have to add file/directory from the KNIME path?);
Yes, it is recommended to use the builtin driver. Going through File > Preferences > KNIME > Databases > Add file/directory it is not necessary in this case.