Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE std2_27.sales (
- "date" date NULL,
- region varchar(20) NULL,
- material varchar(20) NULL,
- distr_chan varchar(100) NULL,
- quantity int4 NULL,
- check_nm varchar(100) NOT NULL,
- check_pos varchar(100) NOT NULL
- )
- WITH (
- appendonly=true,
- orientation=row,
- compresstype=zstd,
- compresslevel=1
- )
- DISTRIBUTED BY (check_nm, check_pos);
- insert into std2_27.sales
- select * from gp.sales;
- --- SQL Error [42501]: ERROR: permission denied for schema gp
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement