question Re: Impala shell is not connecting to shell in Support Questions

Impala shell is not connecting to shell

Itsmehani — Tue, 21 Apr 2026 07:41:45 GMT

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

Re: Impala shell is not connecting to shell

VidyaSargur — Tue, 21 Mar 2023 05:58:16 GMT

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

Re: Impala shell is not connecting to shell

ShankerSharma — Tue, 21 Mar 2023 07:01:48 GMT

Hello ,

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

- Is there any load balancer configured for impala?

Thanks

Re: Impala shell is not connecting to shell

Itsmehani — Wed, 22 Mar 2023 05:42:28 GMT

- 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

Re: Impala shell is not connecting to shell

Itsmehani — Wed, 22 Mar 2023 10:49:12 GMT

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