-- 版本：cdh6.2.1 hive2.1.1 doris2.1.0 hadoop3.0.0
-- 切换到hive catalog
switch hive_bdsp
show databases
-- 报错如下：
arg．jkiss．dbeaver．model．sql．DBSQLException：SQL 错误［1105］ ［HY000］： RuntimeException， msg：javax．security．auth．login．LoginException： Unable to obtain password from user
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementlmpl.executeStatement(JDBCStatementlmpl.java:133)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:510)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:441)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DB ExecUtils.java:171)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:428)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:813)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3280)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4624)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by:java.sql.SQLException:RuntimeException, msg:javax.security.auth.login.LoginException: Unable to obtain password from user
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.Statementlmpl.executelnternal(Statementlmpl.java:762)
at com.mysql.cj.jdbc.Statementlmpl.execute(Statementlmpl.java:646)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementlmpl.execute(JDB CStatementlmpl.java:330)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementlmpl.executeStatement(JDB CStatementlmpl.java:130)
...12 more
-- hive catalog ddl如下：
-- 升级doris前hive catalog是正常的，升级前后未改动该catalog
CREATE CATALOG hive bdsp PROPERTIES(
"yarn.resourcemanager.principal” = hadoop@APP.PAIC.COM.CN",
"type" = "hms",
"ipc.client. fallback-to-simple-auth-allowed" = "true",
"hive.metastore. uris" = "thrift://xxxxx:9083",
"hive.metastore.sasl.enabled" = "true",
"hive.metastore.kerberos, principal"1”= "hive/_Fve/ HOST@APP.PAIC.COM.CN",
"hadoop.security.authentication"="}'kerberos",
"hadoop.kerbero3.principal” = "hadooplAPP.PAIC.COM.CN",
"hadoop.kerberos.keytab" =="/var/"/var/soft/hadoopcont/hadoop.keytab"
"dfs.nameservices" = "bdsp-cluster",
"dfs.namenode.rpc-address.bdsp-cluster.nn2"" = "xxxxxx:8020",
"dfs.namenode.rpc-address.bdspprcster.n1=xxxxx:8020",
"dfs.ha.namenodes.bdap-cluster"="nn1,nn2",
"dfs.client.failover.proxy. provider.bdsp-cluster"="org.apache.hadoop.hdfs.server.namenode.ha.comfiguredfailoverproxyprovider",
"create time"time" ="20"2024-02-26 14:04:35.282"
);
