Kindly set the propert as non-strict in hive.exec.dynamic.partition.mode

Due to this i am not able to load the data in partition table.

1 Like


You can set by yourself after Hive launch, if you close and open again then it will be defaulted again.

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;


Please include this statement as well:
set hive.exec.max.dynamic.partitions.pernode=1000;