Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

exercise 2 error timed out (code THRIFTSOCKET):None

SOLVED Go to solution

exercise 2 error timed out (code THRIFTSOCKET):None

New Contributor

After I sucessfully runned "

INSERT OVERWRITE TABLE tokenized_access_logs SELECT * FROM intermediate_access_logs;

" in Hive,

I tried to run 

invalidate metadata;

in impala, it shows error  timed out (code THRIFTSOCKET):None

 

I can see those two external tables have been successfully created on Hive.I could also see those two tables on impala but when I clicked it it shows "error load columns"

 

Any ideas??

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions

Re: exercise 2 error timed out (code THRIFTSOCKET):None

Champion

Check the all the impala and hive demon status using the below command , if anyone one of them is not runing up please start and fire the invalidate metadata for refersh. 

 

 

sudo service impala-state-store status
note - if not started please replace status with start.

 

sudo service impala-catalog status

  

sudo service hive-metastore status

 

 

sudo service impala-server status

 

 

2 REPLIES 2

Re: exercise 2 error timed out (code THRIFTSOCKET):None

Contributor

Hi,

 

Thrift protocol is used for communication inside impala, as well as from impala (and catalog daemon) to hive metastore. If you see socket timeouts withing this context, most probably one service is not in good health, you should check whether the impala service instances are up-and-running: hive metastore, impala daemon, catalog daemon and impala statestore.

 

Regards

 Miklos Szurap

Customer Operations Engineer

Re: exercise 2 error timed out (code THRIFTSOCKET):None

Champion

Check the all the impala and hive demon status using the below command , if anyone one of them is not runing up please start and fire the invalidate metadata for refersh. 

 

 

sudo service impala-state-store status
note - if not started please replace status with start.

 

sudo service impala-catalog status

  

sudo service hive-metastore status

 

 

sudo service impala-server status