Dynamic partition in Hive change to nonstrict

Dynamic partition in Hive change to nonstrict
0.0 0


I can’t change it ; why it is set to strict default.
Look guys this is slowly becoming issue more i go in deep more i find i have no authentication to do.
Can any one please explain WHY and if it can be fixed?


Dear dsu barroha,

The default value is hive.exec.dynamic.partition.mode=strict, we can change it to nonstrict by below command.

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

I am able to do now.

If you are giving above command on Hive CLI or Hive View (Under Ambari), this will last for that session only. So every time we need to give above command. For learning purpose, you can go with this plan. But there are other option to play around like (–hiveconf and .hiverc) for permanent setting change.


I am familiar that and that’s what i am trying to do for one of dataset to test. I wasn’t able to change.
But today i am able to do it huh strange.

Thanks for your reply and help. appreciated.