New Contributor
Posts: 2
Registered: ‎10-29-2014

what is the difference between partition(Static and Dynamic) and bucketing in Hive??

I wanted to know the main difference between Partitioning and bucketing in Hive

I read that there are 2 concepts in partitioning i,e Static and Dynamic

In static the files are partitioned manually like years (2000 - 2014) we need to partition 2000.csv, 2001.csv etc

where as in Dynamic 2 SET commands instruct hive to change our query to dynamically load partitions (SET hive.exec.dynamic.partition = true; SET hive.exec.dynamic.partition.mode = nonstrict;)

Then in that case how is bucketing different from dynamic partitioning??