Dear dsu barroha,
The default value is hive.exec.dynamic.partition.mode=strict, we can change it to nonstrict by below command.
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.