https://community.cloudera.com/t5/Support-Questions/How-to-get-all-the-External-Hive-table-details-from-the-HDFS/m-p/283084#M210407 <P>Hello <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/13154">@JordanMoore</a>&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/28292">@shashankvc</a>&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/66976">@sihi_yassine</a>&nbsp;,</P><P>&nbsp;</P><P>As per your requirement you want list of all external hive tables along with HDFS path location.</P><P><STRONG>Database name,Table name,Table Type(External) and HDFS Location of hive External tables</STRONG>.</P><P>First login to Hive metastore and use the database which is storing all hive metadata&nbsp;</P><P>Use 3 tables TBLS,DBS and SDS tables , on top of this 3 tables we can apply joins on DB_ID and SD_ID</P><P>For more information and query output please check below link .</P><P>&nbsp;</P><P><A href="https://askdoubts.com/question/how-to-find-out-list-of-all-hive-external-tables-and-hdfs-paths-from-hive-metastore/#comment-19" target="_blank">https://askdoubts.com/question/how-to-find-out-list-of-all-hive-external-tables-and-hdfs-paths-from-hive-metastore/#comment-19</A></P><P>&nbsp;</P><P>Thanks,</P><P>Mahesh</P> Fri, 15 Nov 2019 11:49:59 GMT maheshchimmiri 2019-11-15T11:49:59Z