Partitioning and bucketing

Originally published at: http://www.itversity.com/topic/bde-partitioning-and-bucketing/

Introduction Let us understand various partitioning and bucketing options Traditional databases have different types of partitioning List partitioning Hash partitioning Range partitioning Nested partitioning Hive supports Partitioning (same as list partitioning) Bucketing (similar to hash partitioning) Nested partitioning and bucketing Data into partitioned or bucketed tables are typically loaded using INSERT command Loading or Inserting…