Support TRUNCATE TABLE for S3 and HDFS

Why it matters

This feature allows users to efficiently delete all data from tables located on S3 or HDFS without needing to drop and recreate the table, improving manageability and operational convenience for external data storage.

How to use it

Users can simply run the TRUNCATE TABLE <table_name> SQL command on tables stored in S3 or HDFS to quickly remove all their data.