All hive tables location
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

