How to delete truncate tables from Hadoop-Hive

Question

Please tell me how to delete table from hive and also tell from where i can get more information about hive queries

User · Accepted Answer

You can use drop command to delete meta data and actual data from HDFS.

And just to delete data and keep the table structure, use truncate command.

For further help regarding hive ql, check language manual of hive.

User · Answer

You need to drop the table and then recreate it and then load it again

User · Answer

Use the following to delete all the tables in a linux environment   hive -e  show tables    xargs -I      hive -e  drop table

User · Answer

To Truncate   hive -e  TRUNCATE TABLE IF EXISTS  tablename    To Drop   hive -e  Drop TABLE IF EXISTS  tablename

[hadoop] How to delete/truncate tables from Hadoop-Hive?