How partitions will work in hive & how to allow dynamic partitions in hive DML/DDL in diyotta?
How partitions will work in hive & how to allow dynamic partitions in hive DML/DDL in diyotta?
- Hive Partitions is a way to organizes tables into partitions by dividing tables into different parts based on partition keys.
- Example of hive query for partition will be as below
- create table state_part(District string,Enrolments string) PARTITIONED BY(state string);
- For partition we must set this property
3.set hive.exec.dynamic.partition =true;
.set hive.exec.dynamic.partition.mode=nonstrict