Error Messages:

[root@cpucode100 bin]# beeline -u jdbc:hive2://cpucode100:10000 -n root
Connecting to jdbc:hive2://cpucode100:10000
21/12/15 21:41:51 [main]: WARN jdbc.HiveConnection: Failed to connect to cpucode100:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://cpucode100:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root (state=08S01,code=0)
Beeline version 3.1.2 by Apache Hive

Connecting to jdbc:hive2://cpucode100:10000
21/12/16 21:15:53 [main]: WARN jdbc.HiveConnection: Failed to connect to cpucode100:10000
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://cpucode100:10000: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
Beeline version 3.1.2 by Apache Hive

Solution:
The configuration information in the hadoop file core-site.xml is as follows, restart Hadoop, and start hiveserver2 and beeline again. Can
Replace the root below with your own username

	<property>
		<name>hadoop.proxyuser.root.hosts</name>
		<value>*</value>
	</property>
	<property>
		<name>hadoop.proxyuser.root.groups</name>
		<value>*</value>
	</property>

distribute

xsync /etc

Restart start

myhadoop.sh stop

myhadoop.sh start

hive --service hiveserver2

Wait, it will be a long time here, about 10 minutes

beeline -u jdbc:hive2://cpucode100:10000 -n root

Read More:

• The authentication server Configurate NoClassDefFoundError Error (store client information in a JDBC-based database)
• [Solved] Disconnected from the target VM, address : ‘127.0.0.1:6847’ , transport : ‘socket’
• [Solved] Feign Error: -‘oauth-client.FeignClientSpecification‘ could not be registered
• [Solved] Flink jdbc Error: Access Denied for user ‘root‘@‘10.0.0.x‘ (using password: YES)
• [Solved] Chrome Error: The request client is not a secure context
• [Solved] Error: failed to create deliver client: orderer client failed to connect to orderer.example.com:7050
• [Solved] JDBC error: Communications link failure
• Springcloud configuration center client 3355 startup Error: error on get request for“ http://localhost:8761/eureka/apps/ “: Connection
• [Solved] sqoop Error: jSQLException in nextKeyValue Caused by: ORA-24920:column size too large for client
• [Solved] fatal error C1083: Could Not Open Unable to open include file:“stdint.h”: No such file or directory
• Kubernetes Error: Error in configuration: unable to read client-cert* unable to read client-key*
• JMeter JDBC Error: No pool found named: ‘test‘ [How to Solve]
• [Solved] Fabric Start Network Error: Error: error getting endorser client for channel: endorser client failed to connect to
• Spring deployment error: Could not open ServletContext resource [/db.properties]
• Error configuring application listener of class jdbc.ContextListener [One of the solutions]
• Spark ERROR client.TransportResponseHandler: Still have 1 requests outstanding when connection from
• CDH-hue : Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available
• [Solved] CXF Call webservice Client Error: 2 counts of InaccessibleWSDLException
• How to Solve Client-go Mod Error
• [Solved] rabbitMQ: factory.newConnection() Error: com.rabbitmq.client.ShutdownSignalException