TIAA interview question

Hive Static partition vs Dynamic partition

Interview Answer

Anonymous

15 Jun 2018

Insert input data files individually into a partition table is Static Partition, fast, can alter the partition, set hive.mapred.mode = strict Single insert to partition table is known as a dynamic partition, slow, can’t perform alter, don’t know how many columns