The cleanest way to do this would be to create a new table with varchar datatype for the partition key along with the partitions and then move the data partition-by-partition.
The rollback would be super easy as well in case some issues arise in applications due to change of datatype.
We have a partition table with partitioning type range and got the requirement from the application team to alter the datatype of partitioning key from bigint to varchar. Please suggest to me the way how this can be achieved.
Data volume is quite huge in the table. ~50 Billion rows