Support Questions

Find answers, ask questions, and share your expertise

Status: Waiting for catalog update from the StateStore

New Contributor

I am a Cloudera noob. I first tried to install Impala with CLoudera Manager and failed miserably. Did the same without Cloudera manager by following the link below. 

http://hadoop4beginner.blogspot.in/2015/05/impala-installation-in-ubuntu.html 

 

Have done everything in that link and finally when I tried to run a query from inside the impala shell, I get the following message.

 

"Query: create database sample
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore."

Please help. Thanks in advance.

11 REPLIES 11

New Contributor

updating the link 

hadoop4beginner.blogspot.in/2015/05/impala-installation-in-ubuntu.html

New Contributor

Also, when I use the following command for the first time, the service starts properly. 

sudo service impala-catalog start

After a few seconds when I check the status it says 

* Impala Catalog Server is dead and pid file exists

Could this have anything to do with my problem?

Contributor

I have the same problem .

I check the catalog server log and found that the MySQL driver hive using is not consistent to The MySQL-server.

Fix it ,and all is ok.

 

New Contributor

Hi,

 

I am new to this CDH distribution and it happens I have the same issue here...

Did you resolve this problem and how exactly?

 

 

Thanks,

Skender

Champion

@skollcaku @yash808 @lidaling

if you are not using cloudera manager then fire this command to see your status of the statestore 

 

Check 1  - see if you have software installed in Host that you are trying 

sudo yum install --assumeyes impala-state-store

sudo yum install --assumeyes impala-catalog

Check 2 
sudo service impala-state-store status 

if it is in failed state - check the logs /var/log/impala/

if it is in stop state 

start by firing this command 

sudo service impala-state-store start

then 

check the status again 


sudo service impala-state-store status

if you are using CM please let me know the version of CM/CDH plus your OS version / Kernel version 

 

meantime check the instance to see if it is all green / red - I mean the Impala daemons (State store , catalog , impala daemon ) 

 

Let me know if that works 

New Contributor

I just restart catalog server and statestore server. Then it works

Champion

@NguyenBac I am glad that it worked 

New Contributor

Restart of hive metastore server and hive server worked for me.

New Contributor

How you restart could you please tell step wise

Explorer

seems like both services - impala-state-store and impala-catalog are down, restarting them worked for me

 

sudo service impala-state-store start

 

sudo service impala-catalog start

 

 

New Contributor

[quickstart.cloudera:21000] > history;
[1]: help;
[2]: version;
[3]: history;
[4]: exit;
[5]: profile;
[6]: help;
[7]: profile;
[8]: history;
[9]: version;
[10]: profile;
[11]: CREATE DATABASE IF NOT EXISTS my_database;
[12]: history;
[quickstart.cloudera:21000] > sudo service impala-state-store start;
Query: sudo service impala-state-store start
Query submitted at: 2020-02-02 22:11:26 (Coordinator: http://quickstart.cloudera:25000)
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.

[quickstart.cloudera:21000] > sudo service impala-catalog start
>

[quickstart.cloudera:21000] > sudo service impala-catalog start;
Query: sudo service impala-catalog start
Query submitted at: 2020-02-02 22:11:48 (Coordinator: http://quickstart.cloudera:25000)
ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.

Hi ,

I'm getting an error when fire both the below commands. kindly help 

sudo service impala-state-store start;

sudo service impala-catalog start;

ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.