@KiraAL you can try repairing the crashed table using below steps:   1. Make a copy of your MySQL data file e.g. ~/mysql_backup1 2. Make another copy of your MySQL data file to ~/mysql_backup2 before continuing.   3. Cd into ~/mysql_backup2   4. Run myisamchk ~/mysql_backup2/*.MYI 4.1 This command will list your damaged tables   5. Use "myisamchk --backup -r django_session" 5.1 -r means “recovery mode" 5.2 --backup means “Make a backup of the .MYD file as file_name-time.BAK”). 5.3 This removes incorrect rows and deleted rows from the data file and reconstructs the index file.   6. If the preceding step fails, use "myisamchk --backup --safe-recover django_session"   7. Put back your repaired MySQL data files from ~/mysql_backup2 into the original location   8. If any problem occurs after the repaired data files are restored restore the copy from the ~/mysql_backup1   The below link also document the way to repair a crashed table. Mysql MyISAM Table-Maintenance Utility https://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html   Regards, Tarun Jangid ... View more

Hello @chhaya_vishwaka    Could you please confirm if you have set up the scm database mentioned here  https://www.cloudera.com/documentation/enterprise/latest/topics/prepare_cm_database.html   From the error stack, I see that it's indicating table 'scm.CM_VERSION' doesn't exist.    If you have followed the above step, then there might be a possibility that there is some issue/corruption with backend DB. If you are okay to recreate the DB, please do so. ... View more

Hello @Ansar, You can use the CM API to get the service's state as below: http(s)://<cm-server>:<port>/api/v7/clusters/{clusterName}/services Then, you can search for "serviceState" & "healthSummary" to get the service status (STARTED or STOPPED) & health status (GOOD or BAD). The detailed document is here: http://cloudera.github.io/cm_api/apidocs/v7/path__clusters_-clusterName-_services.html Regards, Tarun Jangid ... View more

Hello @Kamalindia, You can setup Database HA using the below document: https://www.cloudera.com/documentation/enterprise/latest/topics/admin_cm_ha_dbms.html To understand the DB failover in detail, request you to refer here: https://www.postgresql.org/docs/9.1/warm-standby-failover.html Regards, Tarun Jangid ... View more

Hello @Nick, You can get the detailed document to configure HA for MySQL here https://www.cloudera.com/documentation/enterprise/latest/topics/admin_cm_ha_dbms.html Regards, Tarun Jangid ... View more

Hi @Viktor, You can setup Hue load balancer via Cloudera Manager directly using the document[1]. Regards, Tarun Jangid [1] https://www.cloudera.com/documentation/enterprise/latest/topics/hue_use_add_lb.html ... View more

Hi @bvk, For Hue to work properly with a Cloudera cluster that uses Kerberos for authentication, the Kerberos Ticket Renewer must be added to the Hue service. Use the Cloudera Manager Admin Console to add the Kerberos Ticket Renewer role to each host with a Hue Server role instance. Kindly refer the document[1] to get the detailed steps for enabling Hue to use Kerberos for authentication. Regards, Tarun Jangid [1] https://www.cloudera.com/documentation/enterprise/latest/topics/cm_sg_enable_hue_sec_s10.html ... View more

Hi @VijayM I am afraid that you cannot gather the required information from the Sentry command. However, you can get it from the MySQL database. To do so, please follow: 1. Login to MySQL. 2. Select the Sentry database using "use <database>". 3. Execute the below query: SELECT DB_NAME, ACTION,ROLE_NAME,GROUP_NAME FROM SENTRY_DB_PRIVILEGE INNER JOIN SENTRY_ROLE_DB_PRIVILEGE_MAP ON SENTRY_DB_PRIVILEGE.DB_PRIVILEGE_ID=SENTRY_ROLE_DB_PRIVILEGE_MAP.DB_PRIVILEGE_ID INNER JOIN SENTRY_ROLE ON SENTRY_ROLE.ROLE_ID=SENTRY_ROLE_DB_PRIVILEGE_MAP.ROLE_ID INNER JOIN SENTRY_ROLE_GROUP_MAP ON SENTRY_ROLE_GROUP_MAP.ROLE_ID=SENTRY_ROLE.ROLE_ID INNER JOIN SENTRY_GROUP ON SENTRY_GROUP.GROUP_ID=SENTRY_ROLE_GROUP_MAP.GROUP_ID; Please do let me know if this helps you. Regards, Tarun Jangid ... View more

Hi @VijayM To list all the roles assigned to the given group name (only allowed for Sentry admin users and other users that are part of the group specified by group name) you can use the below command from beeline. SHOW ROLE GRANT GROUP group name; Also for more details about beeline commands, you can refer to https://www.cloudera.com/documentation/enterprise/latest/topics/sg_hive_sql.html Regards, Tarun Jangid ... View more

Hi rvt, Yes, you can get the status of the namenode using the below-mentioned way: http://<cmhost>:<port>/api/v1/clusters/<cluster-name>/services/HDFS/roles/HDFS-NAMENODE-<namenode id> and search for "haStatus" Regards, Tarun Jangid ... View more