@frank_albers @PNW supervisor has a listener process which keeps monitoring the CDH processes. For any service with auto restart configured if faces an unexpected exit , supervisord will restart the process. Agent looks for unexpected exits in the notifications it receives via the supervisor listener and forwards relevant event info to the associated role's monitor to update its unexpected exit state. A normal agent restart does not affect supervisord process, it continues to be running and managing CDH processes. A hard stop/restart on agent will affect supervisord and in turn kill all managed CDH processes.   Hope this helps, Paras Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.     ... View more

@Srinivs Kindly check if the username and passwords are correct for DB and there should not be any extra space.    grant the privileges as shown below. postgres=# GRANT CONNECT ON DATABASE rman TO rman; GRANT postgres=# GRANT ALL ON DATABASE rman TO rman; GRANT postgres=# GRANT ALL PRIVILEGES ON DATABASE "rman" to rman; GRANT   If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped. ... View more

Hi, > Add the below configuration in HDFS from CM UI: CM -> hdfs -> Configuration    hadoop.proxyuser.hive.hosts = * hadoop.proxyuser.hive.groups = *    > If the above is already set, please disable the DB notification API auth.  In Hive and Hive_On_Tez Service: In Hive Service Advanced Configuration hive-site safety value:    Name: hive.metastore.event.db.notification.api.auth Value: false   Restart stale configs and check if it works.   Regards, Chethan YM   ... View more

> No metrics/graph to check " inc_stats_size"   That's what I thought. > If 1GB is insufficient, Try to use "compute stats" instead of "compute incremental stats"   However, there is a problem in that case.   This table is updated every hour adding a new partition. But, the "compute stats" take well over an hour to complete. ... View more

Hi,   The alert message does not give more information to check, review the HMS and CM service monitor logs related to this issue and provide the stack-traces.   Regards, Chethan YM     ... View more

@coco, has the above issue been resolved for you? was @ChethanYM 's response helpful? If you have found a solution, can you please share it with our community?  ... View more

How create function SURROGATE_KEY()?. I note that it would be necessary to install a package to perform the function in Impala   ... View more

thanks Chethan. The solution here https://community.cloudera.com/t5/Support-Questions/Invalid-resource-request-requested-resource-type-yarn-io-gpu/m-p/243629#M205427 is apparently no longer valid. I switched back to the Capacity scheduler, increased yarn.nodemanager.resource.memory-mb and everything seems to be OK now ... View more

@Former Member --Thanks for sharing information. ... View more