批量删除hive表

empcl

已于 2023-12-02 20:45:26 修改

阅读量134

点赞数

文章标签： hive hadoop 数据仓库

于 2023-12-02 20:06:28 首次发布

本文链接：https://blog.csdn.net/qq_20064763/article/details/134756905

版权

#!/bin/bash
delete_table() {
	db=$1
	hive -e "use $db" 2>/dev/null
	tbs=$(hive -e "show tables;" 2>/dev/null)
	for tb in $tbs
	do
		hive -e "DROP TABLE IF EXISTS $tb" 2>/dev/null
		[ $? -eq 0 ] && echo "deleted $db.$tb successfully." || echo "deleted $db.$tb failed."
	done
}

main() {
	dbs=$(hive -e "show databases;" 2>/dev/null)
	for db in $dbs
	do
		delete_table $db
		if [ "default" != "$db" ];then
			hive -e "DROP DATABASE IF EXISTS $db" 2>/dev/null
			[ $? -eq 0 ] && echo "deleted database $db successfully." || echo "deleted database $db failed."
		fi
	done
}

main