1

I wrote a Row-Level Geo-Partitioning POC, and I set up the following link. I found that all the data of the node table are exactly the same.enter code here I want to make the horizontal split how to achieve it，how do you du it, thank you!

https://docs.yugabyte.com/latest/explore/multi-region-deployments/row-level-geo-partitioning/

/usr/local/yugabyte-2.9.0.0/bin/yugabyted start                            \
  --base_dir=/home/yugabyte/yugabyte-data      \
  --listen=192.168.106.34                               \
  --master_flags "placement_cloud=aws,placement_region=us-east-1,placement_zone=us-east-1a" \
  --tserver_flags "placement_cloud=aws,placement_region=us-east-1,placement_zone=us-east-1a" &

/usr/local/yugabyte-2.9.0.0/bin/yugabyted start                            \
  --base_dir=/home/yugabyte/yugabyte-data      \
  --listen=192.168.106.23                               \
  --join=192.168.106.34                                 \
  --tserver_flags "placement_cloud=aws,placement_region=us-east-1,placement_zone=us-east-1a"

CREATE TABLE transactions (
    user_id   INTEGER NOT NULL,
    account_id INTEGER NOT NULL,
    geo_partition VARCHAR,
    account_type VARCHAR NOT NULL,
    amount NUMERIC NOT NULL,
    txn_type VARCHAR NOT NULL, 
    created_at TIMESTAMP DEFAULT NOW()
) PARTITION BY LIST (geo_partition);

 
CREATE TABLESPACE us_central_1_tablespace WITH (
  replica_placement='{"num_replicas": 1, "placement_blocks":
  [{"cloud":"aws","region":"us-east-1","zone":"us-east-1a","min_num_replicas":1}]}'
);

CREATE TABLESPACE ap_south_1_tablespace WITH (
  replica_placement='{"num_replicas": 1, "placement_blocks":
  [{"cloud":"cloud1","region":"datacenter1","zone":"rack1","min_num_replicas":1}]}'
);

CREATE TABLE transactions_us 
    PARTITION OF transactions 
      (user_id, account_id, geo_partition, account_type, 
      amount, txn_type, created_at,
      PRIMARY KEY (user_id HASH, account_id, geo_partition))
    FOR VALUES IN ('US') TABLESPACE us_central_1_tablespace;


CREATE TABLE transactions_default 
    PARTITION OF transactions 
      (user_id, account_id, geo_partition, account_type, 
      amount, txn_type, created_at,
      PRIMARY KEY (user_id HASH, account_id, geo_partition))
    FOR VALUES IN ('India') TABLESPACE ap_south_1_tablespace;

INSERT INTO transactions 
    VALUES (200, 20001, 'India', 'savings', 1000, 'credit');
INSERT INTO transactions 
    VALUES (300, 30001, 'US', 'checking', 105.25, 'debit');

select * from transactions;
select * from transactions_us;
select * from transactions_default;
Eric Pan
  • 11
  • 1
  • 1
    Welcome, Eric. It's great that you showed the code. Can I suggest you make the question itself a bit clearer, because it's not obvious to me what you are asking? Writing the title as a question can help. – Dominic Cronin Sep 09 '21 at 08:30
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Sep 14 '21 at 17:18

0 Answers0