Delete all databases in hive

[Terry <th...@gmail.com>]

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!

RE: Delete all databases in hive

[Jon Morisi <Jo...@hsc.utah.edu>]

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 <th...@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!