Script to replicate Hive DB in the same cluster

hive_export_import.sh

#!/bin/sh

SRC_DB_NAME="src"

TGT_DB_NAME="tgt"

EXPORT_DIR="/tmp"

HiveTables=$(hive -e "use $SRC_DB_NAME;show tables;" 2>/dev/null | egrep -v "WARN|^$|^Logging|^OK|^Time\ taken")

for Table in $HiveTables
do
    hive -e "EXPORT TABLE $SRC_DB_NAME.$Table TO '$EXPORT_DIR/$SRC_DB_NAME.$Table';"

    hive -e "IMPORT TABLE $TGT_DB_NAME.$Table FROM '$EXPORT_DIR/$SRC_DB_NAME.$Table';"
done