Skip to main content
syedshakir
syedshakir
Gold ⭐️
June 22, 2022
Solved

Impala shell error

Hi ,

 

im unable to connect impala shell ( kerberised cluster ) with below: command  on Edge node 

impala-shell -i hostname.abc.com -d default -k

case scenario :  we have two Edge node A and B , able to connect on edgenode A  and unable to connect on edgenode  B with same credentials. checked with different user is it also same as working  on Edge node A and edgenode B . 

observed that both have different python version  A has 2.7.5 as default and B has 3.7.0 is this the cause of connection , if yes how to rectify. 

ERROR screenshot shared.

 


shell error.jpg
syedshakir
syedshakirAnswer
Gold ⭐️
July 14, 2022

Hi Vidya , 

 

Issue has been resolved by setting path : 

export PATH=/opt/cloudera/parcels/CDH-5.15.1-1.cdh5.15.1.p0.4/bin:/usr/bin/python2:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/anaconda3/bin:/opt/anaconda3/condabin

 

 

View in thread

11 replies

ShankerSharma
Gold ⭐️
ShankerSharma
Gold ⭐️
June 22, 2022

Hello Syed,

 

Yes, the impala is compatible with Python version 2.7.5.

 

 

Translate
ShankerSharma
Gold ⭐️
ShankerSharma
Gold ⭐️
June 22, 2022

You can try the below steps in edge node B

virtualenv venv -p python2

cd venv

source bin/activate

(venv) impala-shell

Translate
syedshakir
syedshakirAuthor
Gold ⭐️
June 22, 2022

Thanks for the solution , every time i have to come in venv and run impala shell ? or it will work without venv !!

 

Translate
ShankerSharma
Gold ⭐️
ShankerSharma
Gold ⭐️
June 22, 2022

Yes, you need to switch to venv everytime or you need to reinstall python with the 2.7.5 version.

Translate
ShankerSharma
Gold ⭐️
ShankerSharma
Gold ⭐️
June 23, 2022

For a permanent fix, you need to install the python version 2.7.5.

Translate
syedshakir
syedshakirAuthor
Gold ⭐️
June 23, 2022

Python 2.7.5 is already installed and multiple version are available tried to set path but not working , any alternate solution.. .!!!

 

 

Translate
ChethanYM
Gold ⭐️
ChethanYM
Gold ⭐️
July 6, 2022

Hello Syed,

 

Can you try the alternatives command to change the python version? Check the below link.

https://medium.com/coderlist/how-to-change-default-python-version-on-linux-fedora-28-c22da18bdd6

 

Regards,

Chethan YM

Translate
VidyaSargur
Community Manager
VidyaSargur
Community Manager
July 11, 2022

@syedshakir, Have any of the replies helped resolve your issue? If so, kindly mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

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.
syedshakir
syedshakirAuthorAnswer
Gold ⭐️
July 14, 2022

Hi Vidya , 

 

Issue has been resolved by setting path : 

export PATH=/opt/cloudera/parcels/CDH-5.15.1-1.cdh5.15.1.p0.4/bin:/usr/bin/python2:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/anaconda3/bin:/opt/anaconda3/condabin

 

 

Translate
    Terms & ConditionsAccessibility statement