If you are using the Postgres DB then use the below query to get table information :   1. log in to DB server and execute the below query :   ./psql -d hive -c "SELECT \"NAME\", \"TBL_NAME\" FROM \"DBS\" as a, \"TBLS\" as b where a.\"DB_ID\"=b.\"DB_ID\";" > /tmp/tables1.txt > awk '{print $1" " $3}' tables1.txt >> tables.txt > cat /tmp/tables1.txt | wc -l       ... View more