https://community.cloudera.com/t5/Support-Questions/How-to-Drop-Hive-Database-with-Tables-in-it/m-p/185265#M147372 <P><A rel="user" href="https://community.cloudera.com/users/5746/bandarusridhar1.html" nodeid="5746">@Sridhar Reddy</A> Using cascade for dropping DB will delete the entire directory of DB in given HDFS location and also data of other DB which are in/under that location of dropped DB. So it is not recommended to use CASCADE for dropping DB.</P> Thu, 13 Jul 2017 23:36:24 GMT dhirajk 2017-07-13T23:36:24Z