Skip to main content
Itsmehani
Itsmehani
Gold ⭐️
March 20, 2023
Solved

Impala shell is not connecting to shell

HI i am using cdp 6.3

i am trying to connect impala shell it is giving me this error

impala-shell. i am using 3 nodes , and i tried with all nodes . impala service is working fine and even i can run queries from Hue dashboard but self impala shell is not connecting 

 

 

Running Command : impala-shell 


Result :

Starting Impala Shell without Kerberos authentication
Error connecting: TTransportException, Could not connect to mprl508:21000
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v3.4.0-SNAPSHOT (27b919f) built on Tue Aug 3 21:32:01 UTC 2021)

When you set a query option it lasts for the duration of the Impala shell session.
***********************************************************************************
[Not connected] >

 

Itsmehani
ItsmehaniAnswer
Gold ⭐️
March 22, 2023

Thanks for Help , Issue is resolved 

 

After restarting Impala from Ui.

Status tab in CDP (impala -> status)

it show 

Impala Connection String Example shows 

command to connect : i.e 

Impala Shell Command

mpala-shell -i mprl510 -d default . 

i am successfully login into my impala shell

View in thread

4 replies

VidyaSargur
Community Manager
VidyaSargur
Community Manager
March 21, 2023

@Itsmehani, Welcome to our community! To help you get the best possible answer, I have tagged in our Impala experts @ChethanYM @Chella @ShankerSharma @mszurap    who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
ShankerSharma
Gold ⭐️
ShankerSharma
Gold ⭐️
March 21, 2023

Hello ,

 

- Please share the complete impala-shell command that you are using?

- Is there any load balancer configured for impala?

 

Thanks

Translate
Itsmehani
ItsmehaniAuthor
Gold ⭐️
March 22, 2023

- Please share the complete impala-shell command that you are using?

I tried :

1. impala-shell;

2. impala-shell -i  ip

3. impala-shell;

[Not connected] >  connect mprl509 :- mprl509 (hostname)

[Not connected] > connect 10.64.63.82 :- ip 

- Is there any load balancer configured for impala?

i am not using any loadbalancer for Impala . Screen shot attached for cross verified 

Itsmehani_0-1679463735566.png

 

 

Translate
Itsmehani
ItsmehaniAuthorAnswer
Gold ⭐️
March 22, 2023

Thanks for Help , Issue is resolved 

 

After restarting Impala from Ui.

Status tab in CDP (impala -> status)

it show 

Impala Connection String Example shows 

command to connect : i.e 

Impala Shell Command

mpala-shell -i mprl510 -d default . 

i am successfully login into my impala shell

Translate
Terms & ConditionsAccessibility statement