About tjangid

tjangid · ‎07-04-2019

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

tjangid · ‎06-28-2019

Setting a limit to -1 is not recommended as it could have a severe performance impact. It is better to set it to the value that may resolve your issue. Or it is suggested to change the value to default again once you are done with your job. It will make Hue Server slow or process exited with out of memory issues, and the root cause is mostly downloading large files. The following options currently exist for downloading files through the Impala and Hive editors: Use XLS if result set is <= 30K rows Use CSV if result set is > 30K rows Use Hue Safety Valve for CSV if result set > 1M rows (default). While this limitation can be bypassed, doing so may have a negative impact on performance. From Cloudera Manager, navigate to Hue > Configuration > Service-Wide > Advanced > Hue Server Advanced Configuration Snippet (Safety Value) for hue_safety_valve_server.ini Regards, Tarun Jangid

tjangid · ‎06-26-2019

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

tjangid · ‎06-23-2019

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

tjangid · ‎05-15-2019

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

tjangid · ‎05-15-2019

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

tjangid · ‎04-29-2019

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

tjangid · ‎04-22-2019

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

tjangid · ‎04-16-2019

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

Online	Offline
Last Visited	‎08-21-2019 05:32 AM

Date Registered	‎01-11-2019 02:10 AM
Last Visited	‎08-21-2019 05:32 AM
Total Messages Posted	9
Total Kudos Received	4

Re: Status Check for all Services running in CM on...

Re: HUE parameter change from Cloudera Manager:

Re: Setting up External Postgres DB with high avai...

Re: How to Use MySQL HA with Cloudera.

Re: Configuring Hue with load balancer using CM AP...

Re: Does Hue support Kerberos authentication?

Re: How to get Unix group Name mapped to Sentry ro...

Re: How to get Unix group Name mapped to Sentry ro...

Re: CM API to get hdfs active namenode