Dump a list of databases to a file, write a bash script to iterate through and execute drop database with cascade commands?
Something like: hive --outputformat=dsv --showHeader=false -e "drop database $LINE with cascade;" done < "$FILE" From: Terry <tharu...@gmail.com> Sent: Sunday, May 26, 2019 2:14 AM To: user@hive.apache.org Subject: Delete all databases in hive Team, Is there a way to delete all db’s owned by a user in hive? We have hundreds of db’s owned by several users who left the organization. Any help is much appreciated!
