Contact Us| About Us| Terms| Privacy Policies
Powered by Lorquins Technologies© 2017 All Rights Reserved

Hive Tutorial
Home »  Hive » Hive Drop Table

Hive Drop Table

Drop Table in Hive

The drop tables command removes the metadata completely and moves data to Trash or to the current directory if Trash is configured

hive> DROP TABLE IF EXISTS empty_ctas_employee;

Truncate Table in Hive

The truncate tables command removes all the rows from a table that should be an internal table

hive> TRUNCATE TABLE cte_employee;