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

+1 vote

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?

May 17 in Big Data Hadoop by reena
933 views

1 answer to this question.

+1 vote

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.

answered May 17 by Gitika
• 25,420 points
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")

Related Questions In Big Data Hadoop

0 votes
1 answer
0 votes
1 answer

Hive: Dynamic partition without using static partition

Hive asks for a static partition as ...READ MORE

answered May 21 in Big Data Hadoop by Suman
96 views
0 votes
1 answer

How to set maximum dynamic partitions in MapReduce mode?

There is a default maximum number of ...READ MORE

answered May 21 in Big Data Hadoop by Likith
55 views
0 votes
1 answer
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,800 points
3,579 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,800 points
455 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
18,437 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,280 points
1,334 views