About Scharan

Scharan · ‎01-14-2021

@Christy09 Use the below API to put a node/host in maintenance mode curl -u <Username>:<Password> -H 'X-Requested-By:ambari' -i -X PUT -d '{"RequestInfo":{"context":"Turn On Maintenance Mode for host","query":"Hosts/host_name.in(<HOST_NAME>)"},"Body":{"Hosts":{"maintenance_state":"ON"}}}' http://<AMBARI_HOST>:8080/api/v1/clusters/<CLUSTER_NAME>/hosts Example: curl -u admin:<PASSWORD> -H 'X-Requested-By:ambari' -i -X PUT -d '{"RequestInfo":{"context":"Turn On Maintenance Mode for host","query":"Hosts/host_name.in(c486-node2.coelab.cloudera.com)"},"Body":{"Hosts":{"maintenance_state":"ON"}}}' http://c486-node1.coelab.cloudera.com:8080/api/v1/clusters/c486/hosts

vijaypabothu · ‎10-04-2020

@Scharan , Its working . Thank you!!.

lucky_day · ‎09-22-2020

It works,thank you.

Shelton · ‎11-07-2019

@Manoj690 Can you check whether authorization has been delegated to Ranger/Kerbe/SQLAuth if you have Ranger plugin for Hive enabled then the authorization has been delegated to Ranger the central authority. You will need to enable the permissions through ranger for all hive database Hive > Configs > Settings > In Security it is set to ?

Scharan · ‎11-07-2019

@Harish-hadoop Add the queue name in hive.url property in jdbc interpreter settings hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name> EXAMPLE: hive.url= jdbc:hive2://test1:2181,test2:2181,test3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai

Scharan · ‎11-06-2019

@wdailey Use "ldapRealm=org.apache.zeppelin.realm.LdapRealm" Below is the template for your reference ldapRealm=org.apache.zeppelin.realm.LdapRealm ldapRealm.contextFactory.systemUsername =cn=manager,dc=charan,dc=com ldapRealm.contextFactory.systemPassword =admin ldapRealm.contextFactory.authenticationMechanism=simple ldapRealm.contextFactory.url=ldap://test1:389 ldapRealm.authorizationEnabled=true #ldapRealm.pagingSize = 20000 ldapRealm.searchBase= ldapRealm.userSearchBase= ldapRealm.groupSearchBase= ldapRealm.userObjectClass= ldapRealm.userSearchAttributeName = uid ldapRealm.userSearchScope = subtree ldapRealm.groupSearchScope = subtree ldapRealm.userSearchFilter= ldapRealm.memberAttribute = member ldapRealm.memberAttributeValueTemplate=(name={0})

Scharan · ‎10-24-2019

@IrenaKon Refer below link https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/index.html

Scharan · ‎10-22-2019

@Peruvian81 You need to update ranger, You can follow the below steps to reset the password in postgres: 1.Login into postgres 2. postgres=# \connect ranger 3. ranger=# update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin'; Above would reset the password to 'admin'. 4. Login to Ranger UI using the above password 5. Go to User Profile and change the password 6. Open Ambari UI Ranger Configs 7. Update 'admin_password' in Advanced ranger-env with the newly set password

Scharan · ‎09-04-2019

To encrypt LDAP bind password in zeppelin Shiro configuration follow below steps: 1. Removed system password line from the config (this line contained the password for the system user that is doing the LDAP lookups) 2. Added the following line in shiro.ini: ldapRealm.hadoopSecurityCredentialPath=jceks://file/home/zeppelin/conf/zeppelin.jceks 3. Run the following command as Zeppelin user on Zeppelin host: # hadoop credential create ldapRealm.systemPassword -provider jceks://file/home/zeppelin/conf/zeppelin.jceks #Entered password <test> Where <test> is my password 4. Confirmed that file has 700 attributes 5. Restart Zeppelin

Scharan · ‎09-04-2019

Jdbc interpreter is will take default queue to run a job. To run the job in specific queue add the queue name in hive.url property in JDBC interpreter settings as shown below hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name> EXAMPLE: hive.url= jdbc:hive2://c186-node2.-labs.com:2181,c186-node3.-labs.com:2181,c186-node4.-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai Where sai is my queue name. To check and confirm execute below query in zeppelin using JDBC interpreter and check-in Yarn Resource manager UI %jdbc(hive) show databases; use <database name>; show tables; select count (*) from <table name>;

Online	Offline
Last Visited	‎04-27-2026 03:35 AM

Member Since	‎07-09-2019 07:05 AM
Last Visited	‎04-27-2026 03:35 AM
Posts	422
Kudos received	97

Cloudera Community

Re: How to add Delay during Rolling Restart Until ...

Re: HDP 2.6.5.0-292 Ranger service Mysql version c...

Re: Phoenix Query Server Unrecoverable service err...

Re: snappy library not available in hadoop

Re: After depolying CDP 7.1.7 , the GUI shows serv...

Re: Ambari API to put a node in Maintenance Mode

Re: CDP 7.1.3 - Zepplin not able to login with de...

Re: ranger error RangerServiceNotFoundException

Re: Hbase shell error

Re: how to add the queue name zeppelin jdbc interp...

Re: Zeppelin 0.8 on HDP 3.1.0.0 class org.apache.z...

Re: Where can I download HDP 2.6.5

Re: Ranger Password reset

How to encrypt Ldap bind password in zeppelin shir...

How to execute jdbc interpreter jobs in specific y...