他的回复:
回复：suwei 发表于 2021-1-21 17:03 建议通过hcat接口出现下面的错误是什么原因？hcat -e'describe test_2.t_user'SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/opt/MRS_Client/HDFS/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/Hive/HCatalog/lib/slf4j-log4j12-1.7.28.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/HBase/HBase/hbase/tools/hbase-tools-2.2.3-hw-ei-301001-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/HBase/HBase/hbase/tools/hbase-hbck2-2.2.3-hw-ei-301001-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/HBase/HBase/hbase/lib/client-facing-thirdparty/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/HBase/HBase/hbase/lib/jdbc/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/MRS_Client/HBase/HBase/hbase/ranger-2.0.0-hbase-plugin/install/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]2021-01-21 17:58:46,630 INFO conf.HiveConf: Found configuration file file:/opt/MRS_Client/Hive/HCatalog/conf/hive-site.xml2021-01-21 17:58:46,839 INFO conf.HiveConf: current conf hive.parquet.time.zone.isLocal=true2021-01-21 17:58:47,167 WARN conf.HiveConf: HiveConf of name hive.http.filter.initializers does not exist2021-01-21 17:58:47,172 INFO conf.HiveConf: current conf hive.parquet.time.zone.isLocal=true2021-01-21 17:58:47,172 INFO task.AppManagerImpl: ----->AppManagerImpl init-----2021-01-21 17:58:47,208 WARN conf.HiveConf: HiveConf of name hive.http.filter.initializers does not exist2021-01-21 17:58:47,210 INFO conf.HiveConf: current conf hive.parquet.time.zone.isLocal=true2021-01-21 17:58:48,955 WARN conf.HiveConf: HiveConf of name hive.http.filter.initializers does not exist2021-01-21 17:58:48,956 WARN conf.HiveConf: HiveConf of name hive.metastore.blacklist.keep.times does not exist2021-01-21 17:58:48,963 INFO conf.HiveConf: current conf hive.parquet.time.zone.isLocal=trueHive Session ID = dc3a626d-5732-42ba-b7c9-f59d2e38796a2021-01-21 17:58:49,018 INFO SessionState: Hive Session ID = dc3a626d-5732-42ba-b7c9-f59d2e38796a2021-01-21 17:58:49,064 WARN session.SessionState: load mapred-default.xml, HIVE_CONF_DIR env not found!2021-01-21 17:58:49,127 WARN security.UserGroupInformation: Exception encountered while running the renewal command for hiveuser@HADOOP.COM. (TGT end time:1611223668000, renewalFailures: 0,renewalFailuresTotal: 1)ExitCodeException exitCode=1: kinit: KDC can't fulfill requested option while renewing credentialsat org.apache.hadoop.util.Shell.runCommand(Shell.java:1009)at org.apache.hadoop.util.Shell.run(Shell.java:902)at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:1227)at org.apache.hadoop.util.Shell.execCommand(Shell.java:1321)at org.apache.hadoop.util.Shell.execCommand(Shell.java:1303)at org.apache.hadoop.security.UserGroupInformation$AutoRenewalForUserCredsRunnable.run(UserGroupInformation.java:899)at java.lang.Thread.run(Thread.java:748)2021-01-21 17:58:50,241 INFO sqlstd.SQLStdHiveAccessController: Created SQLStdHiveAccessController for session context : HiveAuthzSessionContext [sessionString=dc3a626d-5732-42ba-b7c9-f59d2e38796a, clientType=HIVECLI]2021-01-21 17:58:50,245 WARN session.SessionState: METASTORE_FILTER_HOOK will be ignored, since hive.security.authorization.manager is set to instance of HiveAuthorizerFactory.2021-01-21 17:58:51,046 INFO metastore.HiveMetaStoreClient: Trying to connect to metastore with URI thrift://bu1-vm-svr-40:210882021-01-21 17:58:51,053 INFO metastore.HiveMetaStoreClient: HMSC::open(): Could not find delegation token. Creating KERBEROS-based thrift connection.2021-01-21 17:58:51,057 INFO utils.MetaStoreUtils: Whether to use hadoop rpc protection: true2021-01-21 17:58:51,137 INFO metastore.HiveMetaStoreClient: Opened a connection to metastore, current connections: 12021-01-21 17:58:51,139 INFO metastore.HiveMetaStoreClient: Connected to metastore.2021-01-21 17:58:51,139 INFO metastore.RetryingMetaStoreClient: RetryingMetaStoreClient proxy=class org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=hiveuser@HADOOP.COM (auth:KERBEROS) retries=1 delay=1 lifetime=02021-01-21 17:58:51,606 INFO ql.Driver: State: Compiling.2021-01-21 17:58:51,652 INFO ql.Driver: Compiling command(queryId=root_20210121175851_c9017fd6-e933-496d-8b64-cc6217c043d1): describe test_2.t_user; Current sessionId=dc3a626d-5732-42ba-b7c9-f59d2e38796a2021-01-21 17:58:52,567 INFO ql.Driver: hive.compile.auto.avoid.cbo=true2021-01-21 17:58:52,612 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager2021-01-21 17:58:52,731 INFO parse.DDLSemanticAnalyzer: analyzeDescribeTable done2021-01-21 17:58:52,732 INFO SemanticAnalysis.HCatAuthUtil: Metastore authorizer is skipped for V2 authorizer or DefaultHiveAuthorizationProvider2021-01-21 17:58:52,732 INFO ql.Driver: Semantic Analysis Completed (retrial = false)2021-01-21 17:58:52,784 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null)2021-01-21 17:58:52,882 INFO exec.ListSinkOperator: Initializing operator LIST_SINK[0]2021-01-21 17:58:52,926 INFO sqlstd.SQLStdHiveAccessController: Current user : hiveuser, Current Roles : [public[hiveuser:USER]]FAILED: HiveAuthzPluginException Unsupported privilege type ALL2021-01-21 17:58:52,973 ERROR ql.Driver: FAILED: HiveAuthzPluginException Unsupported privilege type ALLorg.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthzPluginException: Unsupported privilege type ALLat org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLPrivilegeType.getRequirePrivilege(SQLPrivilegeType.java:37)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLPrivTypeGrant.getSQLPrivTypeGrant(SQLPrivTypeGrant.java:81)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.RequiredPrivileges.addPrivilege(RequiredPrivileges.java:39)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.addRequiredPrivs(SQLAuthorizationUtils.java:377)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.getRequiredPrivsFromThrift(SQLAuthorizationUtils.java:353)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.getPrivilegesFromMetaStore(SQLAuthorizationUtils.java:219)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.getPrivilegesFromMetaStore(SQLAuthorizationUtils.java:178)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizationValidator.checkPrivileges(SQLStdHiveAuthorizationValidator.java:281)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizationValidator.checkPrivileges(SQLStdHiveAuthorizationValidator.java:104)at org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizerImpl.checkPrivileges(HiveAuthorizerImpl.java:86)at org.apache.hadoop.hive.ql.Driver.doAuthorizationV2(Driver.java:1542)at org.apache.hadoop.hive.ql.Driver.doAuthorizationV2(Driver.java:1521)at org.apache.hadoop.hive.ql.Driver.doAuthorization(Driver.java:1297)at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:752)at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:2110)at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:2057)at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:2052)at org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:137)at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:237)at org.apache.hive.hcatalog.cli.HCatDriver.run(HCatDriver.java:49)at org.apache.hive.hcatalog.cli.HCatCli.processCmd(HCatCli.java:308)at org.apache.hive.hcatalog.cli.HCatCli.processLine(HCatCli.java:262)at org.apache.hive.hcatalog.cli.HCatCli.main(HCatCli.java:199)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.util.RunJar.run(RunJar.java:318)at org.apache.hadoop.util.RunJar.main(RunJar.java:232)Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLPrivilegeType.ALLat java.lang.Enum.valueOf(Enum.java:238)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLPrivilegeType.valueOf(SQLPrivilegeType.java:24)at org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLPrivilegeType.getRequirePrivilege(SQLPrivilegeType.java:35)... 28 more2021-01-21 17:58:52,974 INFO ql.Driver: Completed compiling command(queryId=root_20210121175851_c9017fd6-e933-496d-8b64-cc6217c043d1); Time taken: 1.367 seconds2021-01-21 17:58:52,974 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager2021-01-21 17:58:52,975 INFO exec.ListSinkOperator: RECORDS_OUT_INTERMEDIATE:0, RECORDS_OUT_OPERATOR_LIST_SINK_0:0, 2021-01-21 17:58:53,007 INFO session.SessionState: Deleted directory: /tmp/hive/hiveuser/dc3a626d-5732-42ba-b7c9-f59d2e38796a on fs with scheme hdfs2021-01-21 17:58:53,007 INFO session.SessionState: Deleted directory: /tmp/root/dc3a626d-5732-42ba-b7c9-f59d2e38796a on fs with scheme file2021-01-21 17:58:53,018 INFO metastore.HiveMetaStoreClient: Closed a connection to metastore, current connections: 0
