Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

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

@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

1 REPLY 1

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

@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

Don't have an account?
Coming from Hortonworks? Activate your account here