我使用 HDP3.1。而我用Ambari来部署hadoop集群和hive。部署后，我可以在 shell 中成功运行配置单元。然后我部署了Apache Kylin2.6，它可以同步hive表。但是当我构建立方体时，出现以下错误:

java.io.IOException: OS command error exit with return code: 1, error message: SLF4J: Class path contains multiple SLF4J bindings. 
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] 
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hadoop/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.apache.logging.slf4j.Log4jLoggerFactory] 
Connecting to jdbc:hive2://datacenter1:2181,datacenter2:2181,datacenter3:2181/default;password=hdfs;serviceDiscoveryMode=zooKeeper;user=hdfs;zooKeeperNamespace=hiveserver2 
19/02/15 10:04:53 [main]: INFO jdbc.HiveConnection: Connected to datacenter3:10000 
19/02/15 10:04:53 [main]: WARN jdbc.HiveConnection: Failed to connect to datacenter3:10000 
19/02/15 10:04:53 [main]: ERROR jdbc.Utils: Unable to read HiveServer2 configs from ZooKeeper 
Error: Could not open client transport for any of the Server URI's in ZooKeeper: Failed to open new session: java.lang.IllegalArgumentException: Cannot modify dfs.replication at runtime. It is not in list of params that are allowed to be modified at runtime (state=08S01,code=0) 
Cannot run commands specified using -e. No current connection 
The command is:  
hive -e "USE default; 

我在 shell 中运行 hive 命令。这是成功。连接字符串与在 kylin 中运行 build cube 时的字符串相同。我很困惑为什么它在 shell 中成功但在构建立方体中失败。

SLF4J: Class path contains multiple SLF4J bindings. 
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] 
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.0.0-78/hadoop/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.apache.logging.slf4j.Log4jLoggerFactory] 
Connecting to jdbc:hive2://datacenter1:2181,datacenter2:2181,datacenter3:2181/default;password=hdfs;serviceDiscoveryMode=zooKeeper;user=hdfs;zooKeeperNamespace=hiveserver2 
19/02/15 12:10:19 [main]: INFO jdbc.HiveConnection: Connected to datacenter3:10000 
Connected to: Apache Hive (version 3.1.0.3.1.0.0-78) 
Driver: Hive JDBC (version 3.1.0.3.1.0.0-78) 
Transaction isolation: TRANSACTION_REPEATABLE_READ 
Beeline version 3.1.0.3.1.0.0-78 by Apache Hive 
0: jdbc:hive2://datacenter1:2181,datacenter2:>  

请您参考如下方法:

您可以尝试将这两个属性添加到hive-site.xml。

<property> 
  <name>hive.security.authorization.sqlstd.confwhitelist</name> 
  <value>mapred.*|hive.*|mapreduce.*|spark.*</value> 
</property> 
 
<property> 
  <name>hive.security.authorization.sqlstd.confwhitelist.append</name> 
  <value>mapred.*|hive.*|mapreduce.*|spark.*</value> 
</property>