If Hive is running on postgresql then : To get tables.txt from postgresql run below command:- 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 Then to make tables1.txt compatible with the python script run below command. awk '{print $1" " $3}' tables1.txt >> tables.txt Now open the file tables.txt and delete the first line which should be something like "----". Now press escape key on keyboard and type below command to get it ready to be used by the findmissingtablesinatlas.txt file Please note to get ^Icharacter you need to use the tab key. :%s/ /^I/g ... View more