Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)
Cloudera Employee

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.

0 Kudos
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎01-20-2017 07:49 PM
Updated by:
Top Kudoed Authors