Skip to main content
smishra1
Gold ⭐️
smishra1
Gold ⭐️
January 21, 2017

Hive Compare Tables and Databases before and after Upgrade/Migration

  • October 5, 2026 at 9:29 AM
  • 0 replies
  • 1882 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.

Terms & ConditionsAccessibility statement