AWS EMR Impala daemon issue

Question

I've just created EMR cluster and trying to create my first Impala table. Getting this error: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore. Any suggestion please? I did everything as documented by Amazon.

[ip-10-72-69-85.ec2.internal:21000] > connect localhost;
Connected to localhost:21000
Server version: impalad version 1.2.1 RELEASE (build d0bf3eae1df0f437bb4d0e44649293756ccdc76c)
[localhost:21000] > show tables;
Query: show tables
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.
[localhost:21000] > 

Answer 1

I had the same error - after many troubles I've found the simple solution:

A. Check impala-state-store and impala-catalog daemons are running:

sudo service impala-state-store status
sudo service impala-catalog status

If not running - check the logs and be sure to activate them.

B.If they are running - simply type in your impala-shell:

invalidate metadata;‏

This command will update your catalog from the state store.

Then, you are ready to start!