There are many database tables (by monthly partition) which contains the tag history data, the tables are named as sqlt_data_{driverId}_{year}_{month}. As time passed away, I want to purge the tables which are over 12 months ago. My question is: Can I just manually delete these old tables use DROP TABLE sqlt_data_{driverId}_{year}_{month} ？ I noticed all monthly partition tables' name are contained in another table sqlth_partitions. Is it necessary to also update this table (delete the rows) at same time?
You have not enabled the pruning. If you don't enable it, it will not delete data.
Thank you David!