All hive tables location

[#1]

Hello,

Is there a way get the hdfs locations of all tables in CDP 7.1.7 SP1?

I tried running a for loop against a list of tables on below command, however, it will take ages to get the list as I am looking forward to 66k+ tables.

hive -e “desc formatted <table>;” | grep Location

Thought of to get from HMS DB directly, however, I can only see DB location URI, but nothing specific to tables.

Kindly help as this is urgent.

Thanks

snm1523

[#2]

Thank you for the respone @ggangadharan