• Default behaviour is .
  • Partitions are defined at table creation. For more information, refer to CREATE TABLE section.
  • Reduced disk IO for timestamp interval searches. This is because our SQL optimiser leverages partitioning.
  • Physical separation of data files. This makes it easily to implement file retention policies or extract certain intervals.
  1. [quest-user 2019-06]$ dir
  2. _archive    cab_type.v              dropoff_latitude.d     ehail_fee.d