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, 2019 in Big Data Hadoop by reena
16,280 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, 2019 by Gitika
• 65,850 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, 2019 in Big Data Hadoop by Suman
1,134 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, 2019 in Big Data Hadoop by Likith
1,309 views
0 votes
1 answer

What happens in a MapReduce job when you set the number of reducers to one?

If you set number of reducers as ...READ MORE

answered Jul 31, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
2,045 views
+1 vote
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
• 11,380 points
11,001 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
• 11,380 points
2,513 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,644 views
–1 vote
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,390 points
4,595 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP