Created 03-20-2023 04:35 AM
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] >
Created 03-22-2023 03:49 AM
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
Created 03-20-2023 10:58 PM
@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,Created 03-21-2023 12:01 AM
Hello ,
- Please share the complete impala-shell command that you are using?
- Is there any load balancer configured for impala?
Thanks
Created 03-21-2023 10:42 PM
- 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
Created 03-22-2023 03:49 AM
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