Hi @dearvenkat  ,  Sorry I was thinking that you just want to change the value, but if you are using RENAME PARTITION sql command it will depend on which type of table you have If it's EXTERNAL the data in HDFS will remain in the same old directory. If your table is MANAGED it should change the directory name to the new one.   Please refer to this article: https://community.cloudera.com/t5/Support-Questions/Partition-rename-in-Hive-HDFS-path/td-p/193283   Apache Hive SQL Reference: https://cwiki.apache.org/confluence/display/hive/languagemanual+ddl#LanguageManualDDL-RenamePartition   ... View more