I have created a table with dynamic partition in hive as below
create table sample(uuid String,date String,Name String,EmailID String,Comments String,CompanyName String,country String,url String,keyword String,source String) PARTITIONED BY (id String) Stored as parquet;
Also I have set the following in hive shell
set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.max.dynamic.partitions=100000000; set hive.exec.max.dynamic.partitions.pernode=100000000; set hive.exec.max.created.files = 100000000;
Is this a good practise as I am setting the values 100 million for each dynamic partitions configuration as shown above?