Hello @Gregonmac  From the Error trace, it can be seen that the Authentication failed while connecting. We have seen scenarios in the past where the issue is with having special characters in the password. Do you have any special characters in your password?  If yes, you can give it a try using a below approach: Encode the password that has special characters. For example: a. Password with special characters: Aj8T2heD1cLMsV8qKIULn8g/tfy/+VO3yPLbhJfXQ9U7 b. Encode the password with following command: python -c "import urllib; print urllib.quote_plus('Aj8T2heD1cLMsV8qKIULn8g/tfy/+VO3yPLbhJfXQ9U7')" c. Use the encoded password in your Alert Publisher settings: Aj8T2heD1cLMsV8qKIULn8g%2Ftfy%2F%2BVO3yPLbhJfXQ9U7  Let me know if this helps.   Thank You,  Tarun ... View more

@Daria  In addition to @jsensharma  update, you can also refer to below documentation for a cluster hardware requirement and for Cloudera Reference Architecture   https://docs.cloudera.com/documentation/enterprise/6/release-notes/topics/rg_hardware_requirements.html#concept_vvv_cxt_gbb   https://docs.cloudera.com/documentation/other/reference-architecture.html ... View more

@Peruvian81  To re-distribute the data on all the datanodes you can use the HDFS balancer https://docs.cloudera.com/documentation/enterprise/latest/topics/admin_hdfs_balancer.html ... View more

Hello @geralt  Please confirm the steps followed and the exact command used to import thee cluster template. Also, please share the reference to the documentation you referred to.   Please confirm the CM/CDH version of the cluster from which you downloaded the template and the CM/CDH version of the cluster you are trying to create.   From the host where you are trying to run the import command, try to check if you are able to ping the host which is not available (as per the error).   Also, please share the python code you are using to call the Cloudera's API. ... View more

Hello @Kitboga123  The creation of a table/view from a function is not possible. Creat table/view as statements only work against views/tables. ... View more

@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