Partitioning guidelines

Here are some partitioning guidelines for small and large tables.

  • For large tables, such as fact tables, aim for as many tablets as you have cores in the cluster.
  • For small tables, such as dimension tables, ensure that each tablet is at least 1 GB in size.