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. Want to know more about what has changed? Check out the Community News blog.

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

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 

Highlighted

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