Advanced Analytics Forum

[Solved] How to enable dynamic partition in hive?  

  RSS

Jitesh Reddy
(@hadoopuser)
New Member
Joined: 4 months ago
Posts: 4
16/08/2018 4:07 am  

Hi,

I am looking to do dynamic partition here in Hive.

Can you please tell me how to do it?

-Jitesh


ReplyQuote
HDFS Tutorial Team
(@ashuhadoop)
Member Admin
Joined: 3 years ago
Posts: 3
16/08/2018 4:11 am  

Hi Jitesh,

First of all thanks for asking the question. To enable the dynamic property in Hive, you need to enable the following 2 properties in Hive. You can run these 2 from Hive shell and then you will be able to create a dynamic partition.

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

Hope this will help. If you need more details on this, please check this link-

https://www.hdfstutorial.com/blog/capgemini-hadoop-interview-questions-and-answers/#14_What_is_Hive_Partition_and_have_you_used_hive_partition


Jitesh Reddy liked
ReplyQuote
Jitesh Reddy
(@hadoopuser)
New Member
Joined: 4 months ago
Posts: 4
16/08/2018 4:13 am  
Posted by: HDFS Tutorial Team

Hi Jitesh,

First of all thanks for asking the question. To enable the dynamic property in Hive, you need to enable the following 2 properties in Hive. You can run these 2 from Hive shell and then you will be able to create a dynamic partition.

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

Hope this will help. If you need more details on this, please check this link-

https://www.hdfstutorial.com/blog/capgemini-hadoop-interview-questions-and-answers/#14_What_is_Hive_Partition_and_have_you_used_hive_partition

Thanks so much 😀 


ReplyQuote
Share:

  
Working

Please Login or Register