指定group 建表方式
最近更新时间: 2025-02-18 16:02:00
postgres=# create table t (id integer,nc text) distribute by shard (id) to group default_group;
CREATE TABLE
postgres=# \d+ t
Table "public.t"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+-----------+----------+--------------+-------------
id | integer | | plain | |
nc | text | | extended | |
Has OIDs: no
Distribute By SHARD(id)
Location Nodes: ALL DATANODES