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

0 votes

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
714 views

1 answer to this question.

0 votes

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,360 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;

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
77 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
49 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,730 points
3,388 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,730 points
408 views
0 votes
10 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
16,914 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,260 points
1,235 views