Static Partition in Hive
Insert input data files individually into a partition table is Static Partition
Usually when loading files (big files) into Hive Tables static partitions are preferred
Static Partition saves your time in loading data compared to dynamic partition
You “statically” add a partition in table and move the file into the partition of the table.
We can alter the partition in static partition
Dynamic Partition in Hive
single insert to partition table is known as dynamic partition
Usually dynamic partition load the data from non partitioned table
Dynamic Partition takes more time in loading data compared to static partition
When you have large data stored in a table then Dynamic partition is suitable.
If you want to partition number of column but you don’t know how many columns then also dynamic partition is suitable
... View more