Quicktostudy
11/20/2018   
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;

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