Sign Up

Have an account?

Sign In

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

Sorry, you do not have a permission to add a question, You must login to ask question.

Need An Account,

Sorry, you do not have a permission to add a question, You must login to ask question.

Need An Account,
Search
Ask A Question

srilakshmi

Beginner
Ask srilakshmi
Follower
  1. Asked: In:

    How to find out list of all hive external tables and hdfs paths from Hive Metastore ?

    srilakshmi

    View Profile
    srilakshmi Beginner
    Added an answer on November 15, 2019 at 4:42 pm

    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