Hologres:ALTER LOGICAL PARTITION TABLE

Modify a logical partitioned table

Hologres supports the ALTER TABLE syntax. For more information about using ALTER TABLE for non-partitioned tables, see ALTER TABLE. As physical tables, logical partitioned tables also support the ALTER TABLE syntax and have all ALTER TABLE functionalities of non-partitioned tables. In addition, logical partitioned tables support modifying partition properties by partition. For more information about logical partitioned tables and partition properties, see Table properties and Partition properties.

ALTER TABLE <table_name> SET (<property_name> = <property_value> [, ...]);

ALTER TABLE <table_name> RESET (<property_name> [, ...]);

ALTER TABLE <table_name> PARTITION(<partition_key> = '<partition_value>') [...] SET (<property_name> = <property_value> [, ...]);

ALTER TABLE <table_name> PARTITION(<partition_key> = '<partition_value>') [...] RESET (<property_name> [, ...]);

Examples

-- Create a logical partitioned table.
CREATE TABLE public.hologres_logical_parent_1 (
    a TEXT,
    b INT,
    c TIMESTAMP,
    ds DATE NOT NULL,
    PRIMARY KEY (b, ds)) 
LOGICAL PARTITION BY LIST (ds) 
WITH (
    orientation = 'column',
    distribution_key = 'b',
    partition_expiration_time = '30 day', 
    partition_keep_hot_window = '15 day', 
    partition_require_filter = TRUE,
    binlog_level = 'replica',
    partition_generate_binlog_window = '3 day'
);

-- Insert data.
INSERT INTO public.hologres_logical_parent_1 
VALUES 
    ('a', 1, '2025-03-16 10:00:00', '2025-03-16'), 
    ('b', 2, '2025-03-17 11:00:00', '2025-03-17');

ALTER TABLE public.hologres_logical_parent_1 
SET (
    partition_expiration_time = '60 day', 
    partition_keep_hot_window = '30 day', 
    partition_require_filter = FALSE);

ALTER TABLE public.hologres_logical_parent_1 
PARTITION (ds = '2025-03-16') PARTITION (ds = '2025-03-17')
SET (
    keep_alive = TRUE, 
    storage_mode = 'hot');