Skip to main content
roshanbi
roshanbi
Gold ⭐️
June 11, 2021
Solved

impala shell connection

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
aakulovAnswer
Platinum ⭐️
June 15, 2021

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?

View in thread

6 replies

aakulov
Platinum ⭐️
aakulov
Platinum ⭐️
June 11, 2021

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

Translate
roshanbi
roshanbiAuthor
Gold ⭐️
June 14, 2021

Hi,

 

thanks for the update.

 

Please find below details:

impalad version 3.4.0-SNAPSHOT RELEASE (build 134517e42b7b6085e758195465f956f431e0e575) Built on Sat Dec 12 11:15:02 UTC 2020
Version: Cloudera Enterprise 7.1.3 (#4999720 built by jenkins on 20200805-1701 git: fa596184790377f07ba80e9cd4da8b875237939c)

Java VM Name: OpenJDK 64-Bit Server VM

Java Version: 11.0.10

 

 

Thanks,

 

Roshan

Translate
aakulov
Platinum ⭐️
aakulov
Platinum ⭐️
June 14, 2021

Hello Roshan,


THe official documentation for using impala-shell to connect to impala is available here for your version of CDP:
https://docs.cloudera.com/cdp-private-cloud-base/7.1.3/impala-manage/topics/impala-shell-connecting.html

 

Note that the default port to connect to impalad is 21000 (not 27000). Please check which port you are using in your deployment (can be done by running 

netstat -tulpn | grep impalad

on the host that's running impalad).

 

Another thing to check if SSL is enabled on in Impala on your cluster, you'll need to use --ssl option when connecting via impala-shell.


Regards,
Alex

Translate
    Terms & ConditionsAccessibility statement