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
