Support Questions

Find answers, ask questions, and share your expertise

Impala shell is not connecting to shell

avatar
New Contributor

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] >

 

1 ACCEPTED SOLUTION

avatar
New Contributor

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 solution in original post

4 REPLIES 4

avatar
Community Manager

@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.



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.
Learn more about the Cloudera Community:

avatar
Expert Contributor

Hello ,

 

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

- Is there any load balancer configured for impala?

 

Thanks

avatar
New Contributor

- 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

 

 

avatar
New Contributor

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