Community Articles
Find and share helpful community-sourced technical articles
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
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
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎01-20-2017 07:49 PM
Updated by:
Top Kudoed Authors