<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question HiveServer2: could not start ThriftBinaryCLIService in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/HiveServer2-could-not-start-ThriftBinaryCLIService/m-p/77610#M35953</link>
    <description>&lt;P&gt;I have 3 node cluster and install haproxy on node1.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;the list of hive services running on my node 1 are : Metastore server, Webcat server, and HiveServer2.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;one instance of hive server2 is running on node 2 and its working fine.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;But node1 hive server2 is not running and showing this errot:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Error starting HiveServer2: could not start ThriftBinaryCLIService
org.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:10000.
	at org.apache.thrift.transport.TServerSocket.&amp;lt;init&amp;gt;(TServerSocket.java:109)
	at org.apache.thrift.transport.TServerSocket.&amp;lt;init&amp;gt;(TServerSocket.java:91)
	at org.apache.thrift.transport.TServerSocket.&amp;lt;init&amp;gt;(TServerSocket.java:87)
	at org.apache.hadoop.hive.common.auth.HiveAuthUtils.getServerSocket(HiveAuthUtils.java:87)
	at org.apache.hive.service.cli.thrift.ThriftBinaryCLIService.run(ThriftBinaryCLIService.java:67)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Address already in use (Listen failed)
	at java.net.PlainSocketImpl.socketListen(Native Method)
	at java.net.AbstractPlainSocketImpl.listen(AbstractPlainSocketImpl.java:399)
	at java.net.ServerSocket.bind(ServerSocket.java:376)
	at org.apache.thrift.transport.TServerSocket.&amp;lt;init&amp;gt;(TServerSocket.java:106)&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;on cli its showing haproxy is using the port 10000&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;[root@cm1 singhkabir880]# netstat -tulpn | grep 10000tcp 0 0 0.0.0.0:&lt;SPAN&gt;10000&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;0.0.0.0:* LISTEN 882/haproxy [root@cm1 singhkabir880]#&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;i have add hive server2 role first then install haproxy service and made below changes in&amp;nbsp; :&lt;/P&gt;
&lt;PRE&gt;/etc/haproxy/haproxy.cfg&lt;/PRE&gt;
&lt;P&gt;:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;STRONG&gt;listen hiveserver2 :10000&lt;/STRONG&gt; 
#haproxy will listen in port 10000 for hiveserver2 client requests.

&lt;STRONG&gt;mode tcp &lt;/STRONG&gt;
&lt;STRONG&gt;option tcplog&lt;/STRONG&gt;
&lt;STRONG&gt;balance leastconn &lt;/STRONG&gt;

#tcp – connection mode between haproxy to hive servers
#leastconn – requests will be sent to server with less connection

&lt;STRONG&gt;server server1 node1:10000&lt;/STRONG&gt;
&lt;STRONG&gt;server server2 node2:10000&lt;/STRONG&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;What should do i need to order to start newly added hive server2 ?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Kindly Suggest.&lt;/P&gt;</description>
    <pubDate>Fri, 16 Sep 2022 13:30:58 GMT</pubDate>
    <dc:creator>prabhat10</dc:creator>
    <dc:date>2022-09-16T13:30:58Z</dc:date>
  </channel>
</rss>

