web访问hive

• 配置

  <property>
 	  <name>hive.server2.thrift.port</name>
 	  <value>10000</value>
  </property>
  <property>
 	  <name>hive.server2.thrift.bind.host</name>
 	  <value>slave1</value>
  </property>
  <property>
	  <name>hive.metastore.event.db.notification.api.auth</name>
 	  <value>false</value>
  </property>
  <property>
 	  <name>hive.cli.print.header</name>
 	  <value>true</value>
  </property>
  <property>
 	  <name>hive.cli.print.current.db</name>
 	  <value>true</value>
  </property>
  <!-- 可以不设置以下两个值，走默认 -->
<!--
  <property>
      <name>hive.server2.webui.port</name>
      <value>10002</value>
  </property>
  <property>
      <name>hive.server2.webui.host</name>
      <value>ip</value>
  </property>
-->

• 启动

# slave1启动hive
hive --service metastore &
hive --service hiveserver2 &

• 浏览器访问：http://192.168.128.101:10002/
  

查看详情

• 查看hive日志，报错

2023-12-26T20:57:25,701 ERROR [HiveServer2-Handler-Pool: Thread-39] server.TThreadPoolServer: Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Invalid status 71
	at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:269) ~[hive-exec-2.3.9.jar:2.3.9]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
Caused by: org.apache.thrift.transport.TTransportException: Invalid status 71
	at org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:184) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41) ~[hive-exec-2.3.9.jar:2.3.9]
	at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216) ~[hive-exec-2.3.9.jar:2.3.9]
	... 4 more

• 改异常可忽略，参考