Hi, Antal Thank you, I have followed some web guide and set hive2 transport mode to http, then the port number become 10001. I changed it back and set the proxy username in hdfs and it worked.
Regards, Hou > 在 2018年4月25日，下午6:23，Antal Sinkovits <asinkov...@cloudera.com> 写道： > > Hi, > > First of all, I would check if the HiveServer2 is running, and listens on the > given port. > > E.g: > lsof -i -P |grep java > > You should see something like: > java 33169 asinkovits 349u IPv6 0x1111111111111111 0t0 TCP > *:10000 (LISTEN) > java 33169 asinkovits 350u IPv6 0x1111111111111111 0t0 TCP > *:10002 (LISTEN) > > If it does, try > beeline -u jdbc:hive2://localhost:10000 > > Regards, > Antal > > > On Tue, Apr 24, 2018 at 10:19 AM, 侯宗田 <zongtian...@icloud.com > <mailto:zongtian...@icloud.com>> wrote: > Thank you very much for your reply, I have changed the port number and set > the thrift.bind.host to localhost. But I still get the error, do you have > some ideas about this? > > beeline> !connect jdbc:hive2://localhost:10000 <> anonymous anonymous > Connecting to jdbc:hive2://localhost:10000 <> > /04/24 16:13:59 [main]: WARN jdbc.HiveConnection: Failed to connect to > localhost: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://localhost:10000: <> java.net.ConnectException: Connection > refused (Connection refused) (state=08S01,code=0) > >> 在 2018年4月24日，上午1:55，Johannes Alberti <johan...@altiscale.com >> <mailto:johan...@altiscale.com>> 写道： >> >> You should connect by default to 10000, the webui port is not the port >> beeline connects with. Regards, Johannes >> >> Sent from my iPhone >> >> On Apr 23, 2018, at 6:38 AM, 侯宗田 <zongtian...@icloud.com >> <mailto:zongtian...@icloud.com>> wrote: >> >>> Hi, >>> >>> I have started hiveserver2 and try to connect it with beeline using the >>> following command: >>> >!connect jdbc:hive2://localhost:10002/default <> >>> >>> But get the following error >>> >>> WARN jdbc.HiveConnection: Failed to connect to localhost:10002 >>> Unknown HS2 problem when communicating with Thrift server. >>> Error: Could not open client transport with JDBC Uri: >>> jdbc:hive2://localhost:10002/default: <> Invalid status 72 >>> (state=08S01,code=0) >>> beeline> >>> >>> I have set the webUI port to 10002 and mode as http, do I still lost >>> something? >>> Does anyone know what is the problem and how to solve it? > >
