Hive Dynamic partition without using static partition

Question

Hi. I am trying to create a dynamic partition in hive but it keeps asking me to specify a static partition. I don't have any static partition to specify, how can I overcome this?

Answer 1

Hive asks for a static partition as a safety measure just in case user accidentally overwrites all the partitions. This is called strict mode. You can override this by setting the configuration to a nonstrict mode. You can do it as follows:

$ hive --hiveconf hive.exec.dynamic.partition.mode=nonstrict