Advertisement
korenizla

std2_27

Aug 26th, 2023
1,420
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE std2_27.sales (
  2.     "date" date NULL,
  3.     region varchar(20) NULL,
  4.     material varchar(20) NULL,
  5.     distr_chan varchar(100) NULL,
  6.     quantity int4 NULL,
  7.     check_nm varchar(100) NOT NULL,
  8.     check_pos varchar(100) NOT NULL
  9. )
  10. WITH (
  11.     appendonly=true,
  12.     orientation=row,
  13.     compresstype=zstd,
  14.     compresslevel=1
  15. )
  16. DISTRIBUTED BY (check_nm, check_pos);
  17.  
  18. insert into std2_27.sales
  19. select * from gp.sales;
  20.  
  21. --- SQL Error [42501]: ERROR: permission denied for schema gp
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement