Well you can write a small Unix script to do that. Here are the steps breaukp. Step 1: Get the list of all the databases, commands for that is and redirect the output to any temporary file (e.g. /tmp/databases) hive -e "show databases;" >> /tmp/databases Step 2: Loop through each database to get the list of tables by using "show tables" and redirect the output to temporary file (e.g. /tmp/tables) for f in `cat /tmp/databases` do echo "Database name is $f , Table Names are as below:" hive -e "show tables;" >> /tmp/tables done
... View more
