Delete Data from Hive External Table

1 year ago
Ava Mitchell
1 minute

There are two methods available in Hive to delete data from an external table.

  1. Use HiveQL statements:
TRUNCATE TABLE table_name;

This statement will delete all data from the external table, but will preserve the structure and metadata of the table.

  1. You can use HDFS commands directly to delete the data files corresponding to the external table, for example:
hdfs dfs -rm -r /path/to/data/file

This will delete the data files corresponding to the external table in HDFS, but it will not affect the metadata of the external table.

bannerAds