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.

Status: Waiting for catalog update from the StateStore

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.

9 REPLIES 9
Highlighted

Re: Status: Waiting for catalog update from the StateStore

New Contributor

updating the link 

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

Re: Status: Waiting for catalog update from the StateStore

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?

Re: Status: Waiting for catalog update from the StateStore

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.

 

Re: Status: Waiting for catalog update from the StateStore

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

Re: Status: Waiting for catalog update from the StateStore

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 

Re: Status: Waiting for catalog update from the StateStore

New Contributor

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

Re: Status: Waiting for catalog update from the StateStore

Champion

@NguyenBac I am glad that it worked 

Re: Status: Waiting for catalog update from the StateStore

New Contributor

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

Re: Status: Waiting for catalog update from the StateStore

New Contributor

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

 

 

Don't have an account?
Coming from Hortonworks? Activate your account here