@wert_1311 Your error indicates that two of your roles are missing or incomplete.   1. Data Access Role (arn:aws:iam::8859X2XX911XX:role/Cloudera-datalake-admin-role) is not set up correctly. Please follow the official documentation on required policies for Data Access Role. Missing policies (chunked): arn:aws:iam::8859X2XX911XX:role/Cloudera-datalake-admin-role:s3:AbortMultipartUpload:arn:aws:s3:::cdp-my-bucket/hive_replica_functions_dir/* 2. Data Access Role (arn:aws:iam::8859X2XX911XX:role/Cloudera-ranger-audit-role) is not set up correctly. Please follow the official documentation on required policies for Data Access Role. Missing policies (chunked): arn:aws:iam::8859X2XX911XX:role/Cloudera-ranger-audit-role:s3:PutObject:arn:aws:s3:::cdp-my-bucket/ranger/audit/* Go back to the quickstart and docs, and make sure completd all the setups.  Here is a link with more about the credentials   https://docs.cloudera.com/cdp-public-cloud/cloud/requirements-aws/topics/mc-aws-req-credential.html   There are steps in the page above describing the 2 roles which have conflicts in your error.  The error indicates, in the end of each message, which policies are missing.     ... View more

@wert_1311 No downtime needed. Only agent CM agent restart on Hue servers may required if you see the alternative not taking effect. ... View more

Hi,   -> Have you tried the same query via Hive? Does it work? -> How this table got created via hive or impala? -> Try "invalidate metadata" in impala and retry   Regards, Chethan YM ... View more

@wert_1311 NO, the downtime is recommended.  https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-cdh/topics/ug_cdh_upgrade_hdfs_finalize.html ... View more

Hi @ChethanYM    load_catalog_in_background is unchecked, we were not observing any JVM pauses in Catalogue Logs, however, we were seeing RPC related alerts, we have restarted Impala and the issue seems to have been fixed.   Thanks  Wert ... View more

@wert_1311 A Cloudera Enterprise license is required for the following features: LDAP and SAML authentication Configuration history Alerts delivered as SNMP traps and custom alert scripts Backup and disaster recovery Operational reports Cloudera Navigator Commands such as Rolling Restart, History and Rollback, and Send Diagnostic Data Cluster Utilization Reports Role Based Access Control and Cluster-specific Roles https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_licenses.html ... View more