https://community.cloudera.com/t5/Support-Questions/How-to-Drop-Hive-Database-with-Tables-in-it/m-p/185259#M147366 <P>DROP DATABASE IF EXISTS userdb CASCADE;</P><P>By using CASCADE, tables in userdb will be deleted first and then the database will be dropped.</P><P>Is it safe to use cascade for Dropping the Hive database? </P><P>Is there any best practice?</P> Thu, 13 Jul 2017 02:10:06 GMT dhirajk 2017-07-13T02:10:06Z