How to check the existence of the table in Beeline Hive using shell script

[#1 · Accepted solution]

@Gayathri Devi,

You can use the below script .

beeline -u "{connection-string}" -e "show tables"  | grep $1
if [ $? -eq 0 ]
then
  echo "table found"
else
  echo "table not found"
fi

But the content in a file say checktable.sh and run the below steps

chmod +x checktable.sh
./checktable.sh {tablename to check}

Thanks,

Aditya