Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE data.log
- (
- id BIGINT GENERATED ALWAYS AS IDENTITY
- (
- INCREMENT BY 1
- MINVALUE -9223372036854775808
- MAXVALUE 9223372036854775807
- START WITH -9223372036854775808
- RESTART WITH -9223372036854775808
- CYCLE
- ),
- epoch_millis BIGINT NOT NULL,
- message TEXT NOT NULL
- ) PARTITION BY RANGE (epoch_millis);
- CREATE TABLE data.foo_log
- PARTITION OF data.log
- (
- PRIMARY KEY (id)
- )
- FOR VALUES FROM (0) TO (9999999999);
- INSERT INTO data.foo_log (epoch_millis, message)
- VALUES (1000000, 'hello');
- INSERT INTO data.log (epoch_millis, message)
- VALUES (1000000, 'hello');
- CREATE TABLE data.foo_log
- PARTITION OF data.log
- (
- id DEFAULT nextval('data.log_id_seq'),
- PRIMARY KEY (id)
- )
- FOR VALUES FROM (0) TO (9999999999);
Add Comment
Please, Sign In to add comment