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

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

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

1 REPLY 1
Highlighted

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

View solution in original post

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