Hive Compare Tables and Databases before and after Upgrade/Migration

[#1]

Hive Compare Tables and Databases before and after Upgrades.

Run below script to collect all databases.

hive -e "show databases" | sed "s/ *$//g" |  sed "s/^ *//g" | sort 1>databaselist 

Run below script to collect all tables in database.

for dbname in `cat databaselist`  ; do hive -e "use ${dbname} ; show tables ;" | sed "s/ *$//g" |  sed "s/^ *//g" | sort  1> tablelist; done ; 

Execute Scripts above before upgrade and once after upgrade .

Simply do vimdiff afterwards to identify the difference if any.

Happy Migrating or Upgrading.