下面的shell脚本将为您提供所需的结果：

output=""|
hive -e 'show tables in <database_name>'  |
while read line
do
 echo "TABLE NAME : $line"
  if eval "hive -e 'describe <database_name>.$line'" | grep -q "tv"; then
     output+="Required table name: $line"'\n'
   else
     output+=""
  fi
echo -e "$output"
done