Hello @KrishnaSanka    Can you cat / jbod5 /dfs/dn/current/VERSION on the problematic data node and verify the entry for 'datanodeUuid' with the other data nodes that are up and in healthy state? I believe it will be different than the 'datanodeUuid' you will find in the VERSION files for the other disks.    Cheers! ... View more

Hello @Mentor    You can use the service resource API to update (PUT) the service configuration. Please refer the below API doc https://archive.cloudera.com/cm7/7.0.3/generic/jar/cm_api/apidocs/resource_ServicesResource.html#resource_ServicesResource_ClustersResourceV40_ServicesResourceV33_updateServiceConfig_PUT   Let me know if this helps!   Cheers! 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

Hello @bsivalingam83    You may navigate to NiFi configuration and search for ignore.   To remove the “ java.arg.13=-XX:+UseG1GC ” you can add a property under the “ bootstrap.conf ignored properties ” section for “ java.arg.13 ". Kindly let me know if this helps.   Br, Tarun 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

@Deaks @HGeorge    This issue can occur if you had some previous mount points and later if you have unmounted them. In some unusual scenarios, CM agent will still tries to grab the filesystem information of that mount point and fails.   To temporarily suppress this error, update the /etc/cloudera-scm-agent/config.ini on each of the hosts affected to: 1. In the line that lists the nodev filesystems: # The list of non-device (nodev) filesystem types which will be monitored. monitored_nodev_filesystem_types=nfs,nfs4,tmpfs   2. Please change the uncommented line to read as : monitored_nodev_filesystem_types=nfs,nfs4   3. Restart the cloudera manager agent with: service cloudera-scm-agent restart   Br, Tarun 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

@Bibhusisa  Could you please share the exact error you are getting and how you are trying to access the logs. A snapshot would really help us review the exact issue.   Br, Tarun ... View more

Hello @KarthiK439 ,   You can get the list of Yarn Applications using the below API https://archive.cloudera.com/cm7/7.0.3/generic/jar/cm_api/apidocs/resource_YarnApplicationsResource.html   Let me know if this is what you are looking for.   Br, Tarun   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

@Cristiano    Rolling restart is valid only for below services: Flume HBase HDFS Kafka Key Trustee KMS Key Trustee Server MapReduce Oozie YARN ZooKeeper Since rolling restart is not available for Sentry, you are getting an error mentioning not a valid command.    ... View more

@GauravCha    Yes your query to get the cluster CPU usage is correct.  Regarding the  Data Granularity, in the chart builder you can select Show Additional Options next to 30d in the time frame. In the Additional Options you can select the granularity to be Hourly.   Kindly let me know if this is what you are looking for.   ... View more

Hi @Jinmu    You can use the below article to reset the admin password   https://community.cloudera.com/t5/Support-Questions/reset-cdm-5-8-password/m-p/45843/highlight/true#M35380   I hope this helps!   Regards, Tarun 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

@Amn_468    On a high level below are the steps:   Use Cloudera Manager to manage and distribute the  krb5.conf  that the CDH needs for requesting Kerberos tickets. Here are the recommended steps: Shutdown the CDH services Shutdown the Cloudera Manager Management services Walkthrough the steps for configuring direct to AD integration Regenerate all the principals Distribute the new   krb5.conf  (which has AD realm information) Start the Cloudera Manager Management services Start the CDH Services   Also, review below docs: Enabling Kerberos Authentication for CDH https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_sg_intro_kerb.html?scroll=xd_583c10bfdbd326ba--6eed2fb8-14349d04bee--76dd   I hope this helps.   Thanks, Tarun 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

@AK_    The target_cm_host should have the value as below. Could you please update this and let us know if this helps. TARGET_CM_HOST = " target.cm.cloudera.com "  Also, please review the below documentation to automate BDR https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_bdr_howto_api.html#bdr_api_1   I hope this helps.   Regards, Tarun   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

Hello @AK_    You can use the below documentation to automate BDR replication. The documentation includes an example to demonstrate this https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_bdr_howto_api.html   I hope this helps.   Regards, Tarun   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

Hello @CloudEraLong    I see that we don't have the following folder created: /var/www/html/cloudera-repos/gplextras6 Could you please try executing the steps mentioned for  CDH 6.3.2 or lower  here?   You would have to update the wget command to include the correct version.   Let me know if this helps. Tarun   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

@Mondi  could you please let us know if you are getting any error while doing so? If yes, could you please share the error stack?     ... View more

Hello @sarm    Please refer the below community post to do the needful   https://community.cloudera.com/t5/Support-Questions/How-to-change-HDP-service-users-password/m-p/236410#M198223   Thank you, Tarun   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

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