https://community.cloudera.com/t5/Support-Questions/Error-Error-while-compiling-statement-FAILED/m-p/278413#M208012 <P>Take MySQL backup before doing this operation.</P><P>Go to MySQL</P><P>use &lt;DB&gt;;<BR />select * from TBLS where tbl_name = '&lt;table_name&gt;';</P><P>Make a note of&nbsp;TBL_ID from the table and delete entries&nbsp;from TABLE_PARAMS , TBL_COL_PRIVS , TBL_PRIVS using where clause TBL_ID</P><P>After getting this done, try the below command.</P><P>delete from TBLS where tbl_name = '&lt;table_name&gt;';</P><P>Now open hive shell and check for the table.</P> Fri, 27 Sep 2019 10:03:07 GMT varma1830 2019-09-27T10:03:07Z