Hello @JordanMoore @shashankvc @sihi_yassine ,   As per your requirement you want list of all external hive tables along with HDFS path location. Database name,Table name,Table Type(External) and HDFS Location of hive External tables. First login to Hive metastore and use the database which is storing all hive metadata  Use 3 tables TBLS,DBS and SDS tables , on top of this 3 tables we can apply joins on DB_ID and SD_ID For more information and query output please check below link .   https://askdoubts.com/question/how-to-find-out-list-of-all-hive-external-tables-and-hdfs-paths-from-hive-metastore/#comment-19   Thanks, Mahesh ... View more

Hi Chiran, I could understand the details above. However i have one question- Which user does the call for ranger.plugin.hive.policy.rest.url for the first time and subsequent attempts? In my case i have ranger installed in separate server and cluster in separate servers. What is the authentication and user involved by rest client for talking to each other? I found from ranger audits and could see curl entries for "admin" user and no other further attempts to authenticate? ... View more