Pre split Region - Based on column value

TiDB
1

Hi team,
I created a table using the command below, where the values for the column “row_id” range from 1 to 9. If I specify a pre-split region of 9, is it possible to load data into specific regions based on the value in the “row_id” column? Additionally, is there a way to load data into the 9 regions using round-robin distribution?
Here is the command used to create the table:
CREATE TABLE instant_cdr_split_region (
ID bigint(20) NOT NULL AUTO_INCREMENT,
row_id int(11) NOT NULL,
msisdn varchar(12) NOT NULL,
date_id int(11) DEFAULT NULL,
channel varchar(12) DEFAULT NULL,
usage_type varchar(12) DEFAULT NULL,
ac_type varchar(15) DEFAULT NULL,
voice_amt int(11) DEFAULT NULL,
sms_amt int(11) DEFAULT NULL,
data_amt int(11) DEFAULT NULL,
field1 varchar(20) DEFAULT NULL,
field2 varchar(20) DEFAULT NULL,
field3 varchar(20) DEFAULT NULL,
field4 varchar(20) DEFAULT NULL,
field5 varchar(20) DEFAULT NULL,
field6 varchar(20) DEFAULT NULL,
field7 varchar(20) DEFAULT NULL,
field8 varchar(20) DEFAULT NULL,
field9 varchar(20) DEFAULT NULL,
field10 varchar(20) DEFAULT NULL,
field11 varchar(20) DEFAULT NULL,
field12 varchar(20) DEFAULT NULL,
field13 varchar(20) DEFAULT NULL,
field14 varchar(20) DEFAULT NULL,
field15 varchar(20) DEFAULT NULL,
field16 varchar(20) DEFAULT NULL,
field17 varchar(20) DEFAULT NULL,
field18 varchar(20) DEFAULT NULL,
field19 varchar(20) DEFAULT NULL,
field20 varchar(20) DEFAULT NULL,
s_date date NOT NULL,
date_idp int(11) DEFAULT NULL,
PRIMARY KEY (ID,row_id) NONCLUSTERED,
KEY msisdn_s_date_idx (msisdn,s_date)
) shard_row_id_bits = 8 pre_split_regions=3

Can anyone please help on this ?

2

Based on the information provided in your CREATE TABLE command, it appears that you are using MySQL syntax to define your table schema. However, the options “shard_row_id_bits” and “pre_split_regions” are not recognized in standard MySQL syntax. These options seem to be specific to a custom implementation or an extension of MySQL.

To determine if it’s possible to load data into specific regions based on the value in the “row_id” column, and if round-robin distribution is supported, we need more information about the specific database system or platform you are using. Please provide details about the database system or platform you are working with, such as its name and version.

With that information, I can provide you with more accurate guidance on how to load data into specific regions based on the value in the “row_id” column and whether round-robin distribution is supported.