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  ... View more

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>;     ... View more