Hello @kums    Hs2 will play key role to execute the quires and retrieve the data from filesystem. please follow below link for best practices of Hs2 heap recommendations.   Hiveserver2 Heap Size Recommendations   ... View more

Here is the very good explanation of hive view and hue replace in hdp 3.0   https://hadoopcdp.com/data-analytics-studio-das-replace-of-hue-hive-views-in-cdp/ ... View more

Below is the very good article for differences between hadoop 2.x and Hadoop 3.x Difference Between Hadoop 2 and Hadoop 3 ... View more

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