Bigdata, 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