Skip to main content
smishra1
Gold ⭐️
Gold ⭐️
Jan 21, 2017 3:49 AM UTC

Hive Compare Tables and Databases before and after Upgrade/Migration

  • Oct 5, 2026 9:29 AM UTC
  • 0 replies
  • 1886 views
  • Translate All

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.