Advertisement
korenizla

прак№1

Aug 17th, 2023
1,229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create schema std2_27;
  2.  
  3. create table std2_27.table1
  4. (
  5. field1 int,
  6. field2 text
  7. )
  8. distributed by (field1);
  9.  
  10. insert into std2_27.table1
  11. select a, md5(a::text)
  12. from generate_series(1, 1000) a;
  13.  
  14. select gp_segment_id, count(1) from std2_27.table1 group by 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement