Error 10096 Dynamic partition strict mode requires at least one static partition column To turn this off set hive exec dynamic partition mode nonstrict

Question

Hello,

Actually, I am working with the hive and after creating a partition and bucketed table, when I used the command to insert data to the table it is showing me this error. I am unable to understand why this error is coming and how can I come out of that. Can any one demonstrate how to resolve this?

Answer 1

Hi,

Looking into your error I can say that the error you are facing because of not setting up the properties for partitioning and bucketing. I would suggest you, first you set all these properties and I hope the error will go. Here are the properties, just set all these properties in your hive shell:

hive> SET hive.exec.dynamic.partition=true;
hive> SET hive.exec.dynamic.partition.mode=non-strict;
hive> SET hive.enforce.bucketing =true;​

I hope it will work.

Comments

Hi Iam getting this message
Dynamic partition strict mode requires at least one static partition column
Even after setting up the below properties nothing seems to be change and the error remains

I tried using
hive> SET hive.exec.dynamic.partition=true;
hive> SET hive.exec.dynamic.partition.mode=non-strict;
hive> SET hive.enforce.bucketing =true;

---

I had the same issue. For some reason, the configurations weren't getting updated from Hive console. I fixed it by setting the config programmatically by adding the below lines:

hiveContext.setConf("hive.exec.dynamic.partition", "true") hiveContext.setConf("hive.exec.dynamic.partition.mode", "nonstrict")