change number of subpartition existing table
I have tables with hash subpartitions and I want to reduce the amount of it from 32 to 8.
I am able to coalesce the existing subpartitions but any new partitions are being created with 32 partitions. What do I need to configure for new partitions to be 8?