Cloudera CDH/CDP 및 Hadoop EcoSystem, Semantic IoT등의 개발/운영 기술을 정리합니다. gooper@gooper.com로 문의 주세요.
1. jdbc:impala://xxx.xxx.xxx.xxx:21050;AuthMech=0
java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500605) Error occured while opening a session with the server. No Additional detail from the server regarding this error is available. Please ensure that the driver configuration is compatible with the server configuration. This type of error can also occur when the server is too busy to handle the request. Please try again later.
at. com.cloudera.impala.hivecommon.api.HS2Client.openSession(Unknown Source)
at. com.cloudera.impala.hivecommon.api.HS2Client.<init>(Unknown Source)
at. com.cloudera.impala.hivecommon.api.HiveServer2ClientFactory.createClient(Unknown Source)
.....
2. jdbc:impala://xxx.xxx.xxx.xxx:21050;AuthMech=3;UID=test_user;PWD=test_password;
java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: Peer indicated failure: Unspported mechanism type PLAIN.
at.com.cloudera.impala.hivecommon.api.HiveServer2ClientFactory.createTransport((Unknown Source)
at.com.cloudera.impala.hivecommon.api.HiveServer2ClientFactory.createClient((Unknown Source)
at.com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.establishConnection((Unknown Source)
......
3. jdbc:impala://xxx.xxx.xxx.xxx:21050;AuthMech=1;krbRealm=GOOPER.COM;krbServiceName=impala;KrbHostFQDN=ldbserver.gooper.com
는 kinit한 OS user로 인증이된다.
Kerberos client 설치를 하지 못하는 경우 JDBC를 통해서 들어오는 사용자에 대한 인증은 LDAP를 이용하도록 하기 위해서 CM의 구성정보의 명령줄 인수 고급 구성 스니펫(안전 밸브)에 아래와 같이 설정한다.
--enable_ldap_auth=true
--ldap_uri=ldap://xxx.xxx.xxx.xxx
--ldap_domain=xxxxxxxxxxxxxxx
--ldap_passwords_in_clear_ok=true