Partitioning in Hive | Learn How to Create, Insert Data in to Hive … Apache Hive Table Types | Apache Hive – DataValley SQL Server 2016 Truncate Table with Partitions I believe somehow the Truncate target option is getting executed before the Target PreSQL and removing the file in S3. The TRUNCATE command removes all rows from the table as well as from the partition, but keeps the table structure as it is. Using the truncate target and truncate target partition enabled. Turn on suggestions. Each time data is loaded, the partition column value needs to be specified. Global indexes must be rebuilt unless UPDATE INDEXES is specified.For example, the following SQL statement truncates multiple partitions in the range-partitioned sales table. The table must not be an external table or a view. Truncating a table in Hive is indirectly removing the files from the HDFS as a table in Hive is just a way of reading the data from the HDFS in the table or structural format. The general format of using the Truncate table command is as follows: Specifying a location makes the table an external table . Retrieving the PartitionDemo2016 table’s data again, the result will be like: Hive Tutorial: Creating, Loading & Querying data in partitioned table ALTER TABLE sales TRUNCATE PARTITIONS sales_q1_2008, sales_q2_2008, sales_q3_2008, sales_q4_2008; This page shows how to create, drop, and truncate Hive tables via Hive SQL (HQL). This command does not move the old data, nor does it delete the old data. It simply sets the Hive table partition to the new location. You can use ALTER TABLE with DROP PARTITION option to drop a partition for a table. Not just in different locations but also in different file systems. Since Spark 2.1, data source tables are also supported.