How to config and query Impala SQL interface of CDH with kerberos mechanism
The Problem
Recently, I have spended several days on rearching impala sql interface with security mechanism. There are two methods to query impala data. One is the kerberos mechanism, the other is ldap method which provided user and password. The first one is very difficult and usually adapted for internal using in the hadoop cluster, So I choose the ldap method for external appliction such as jdbc interface. This blog provides the configuration steps and queries demo for using ldap to impala databases.
The test environment
- CDH version 5.8.0+
- kerberos software
- ldap service
- Linux 2.6.32-573.el6 ...