Greenplum常用sql语句

最新推荐文章于 2024-07-08 20:24:23 发布

凝结水晶

最新推荐文章于 2024-07-08 20:24:23 发布

阅读量6.7k

点赞数

分类专栏： GreenPlum 文章标签： greenplum sql table date

本文链接：https://blog.csdn.net/ningjieshuijing/article/details/5769102

版权

GreenPlum 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1. 查看表使用空间
SELECT      *
FROM         PUBLIC.dba_segments
WHERE         owner   LIKE   'owber_name'
AND            table_name   LIKE   '%table_name%'
ORDER   BY   table_name;

2. GP中查看分区：
select   partitionname,partitionboundary   from   pg_partitions   where   tablename='table_name';
select   partitionname,partitionboundary   from   pg_catalog.pg_partitions   where   tablename='table_name';

3. 查看正在运行的sql
select   *   from   pg_stat_activity;

4. 修改表的owner语句
Alter table table_name owner to owner_name;

5. 增加表分区
ALTER TABLE table_name   ADD PARTITION P20091001 START (DATE '2009-10-01') INCLUSIVE END (DATE '2009-10-02') EXCLUSIVE WITH(appendonly=true,compresslevel=5);

6. 修改列类型
ALTER TABLE table_name ALTER COLUMN a TYPE varchar(2048);

7. 修改distributed 列
alter table table_name set distributed by(column_1);