Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Sorry, you do not have a permission to add a question, You must login to ask question.
Hello Ashok, 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. Use 3 tables TBLS,DBS and SDS tables , on top of this 3 tables we can apply joins on DB_ID and SD_IDRead more