https://community.cloudera.com/t5/Support-Questions/How-to-show-tables-based-on-the-table-owner/m-p/77612#M13011 <P>Hi <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/23776">@lonetiger</a><BR /><BR />You can do it by two kind of scripts:<BR />1- show all tables:</P><PRE>SHOW TABLES;</PRE><P>get the list and run this query on all tables:</P><PRE><STRONG>DESCRIBE FORMATTED</STRONG> tableX;</PRE><P>Then you can get the results and extract the owner, if it's the <SPAN>desired </SPAN>one, drop the table.<BR /><BR />2- Connect with your <STRONG>hive metastore DB</STRONG> and get the table list of the owner you want</P><PRE>SELECT "TBL_NAME" FROM "TBLS" WHERE "OWNER" = 'ownerX';</PRE><P>Then drop them.<BR /><BR />Good luck.</P> Thu, 26 Jul 2018 09:17:40 GMT AcharkiMed 2018-07-26T09:17:40Z