-- Set Region split policies for both existing and future partitions:
ALTER TABLE <table_name>
  SPLIT {PRIMARY KEY [<pk_name>] | INDEX <index_name>}
  BETWEEN (<lower_bound>) AND (<upper_bound>)
  REGIONS <num_regions>;

CREATE TABLE <table_name> (
  <column_definitions>,
  [PRIMARY KEY (<pk_column_list>)],
  [INDEX <index_name> (<index_column_list>), ...]
)
[PARTITION BY RANGE COLUMNS (<partition_column_list>) (
  PARTITION <partition_name_1> VALUES LESS THAN (<value_1>),
  ...,
  PARTITION <partition_name_n> VALUES LESS THAN (MAXVALUE)
)]
[SPLIT PRIMARY KEY [<pk_name>] BETWEEN (<lower_bound>) AND (<upper_bound>) REGIONS <num_regions>]
[SPLIT INDEX <index_name> BETWEEN (<lower_bound>) AND (<upper_bound>) REGIONS <num_regions>, ...];