I have hive partitions folder at HDFS location, but all the partitions folders are in upper case.
i.e. YEAR=2021/MONTH=07/DAY=31/HOUR=00 like this.
in hive when i am creating table it taking partition columns in lowercase
/year=2021/month=07/day=31/hour=00 like this.
since hdfs is case sensitive and hive is case insensitive so hive is expecting partitions column in lowercase at hdfs location and I am not able to see any partition in my hive table.
so is there any way to handle this case.either hive column in uppercase or Recursively change all hdfs partitions column in lowercase. I have 8000+ partitions (1day=24 hours=30 days=12 months(24*30*12=8640) for 1 year so not able to rename every folder manually.