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

Gayathridevi — Mon, 08 Jan 2018 13:35:21 GMT

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

asirna — Mon, 08 Jan 2018 15:11:02 GMT

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