impala shell connection

Question

Hello Team,

can you please help me with the connection to impala?

[root@rb-hadoop-02 admin]# impala-shell -i <HUE_IP>:27000 --user=hive
Starting Impala Shell without Kerberos authentication
Opened TCP connection to 10.10.104.106:27000
Socket error 32: [Errno 32] Broken pipe
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v3.4.0-SNAPSHOT (134517e) built on Sat Dec 12 11:15:02 UTC 2020)

Press TAB twice to see a list of available commands.
***********************************************************************************
[Not connected] > show dbs;
Connection lost, reconnecting...
Opened TCP connection to 10.10.104.106:27000
Socket error 32: [Errno 32] Broken pipe
Query: show dbs
Not connected (use CONNECT to establish a connection)
[Not connected] >

Thanks,

Roshan

aakulov · Accepted Answer

Ok, so now it's a "connection refused error". Can you try without --ssl option, since you said Impala is not enabled with TLS/SSL.

Are you able to ping the IP of your impalad server from the host where you are running impala-shell?

aakulov · Answer

Would be helpful to know which version of CDH or CDP you are using.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.