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??