question Re: exercise 2 error timed out (code THRIFTSOCKET):None in Archives of Support Questions (Read Only)

exercise 2 error timed out (code THRIFTSOCKET):None

happyljj — Mon, 21 Nov 2016 16:56:11 GMT

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

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

mszurap — Mon, 21 Nov 2016 19:45:49 GMT

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

csguna — Tue, 22 Nov 2016 07:34:24 GMT

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