Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

exercise 2 error timed out (code THRIFTSOCKET):None

avatar
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

avatar
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

 

 

View solution in original post

2 REPLIES 2

avatar

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

avatar
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