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> 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> 写道:
>
> 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> 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?
>
>
>

Reply via email to