Greenplum中查询数据

最新推荐文章于 2024-03-04 18:23:02 发布

VIP文章 mavs41

最新推荐文章于 2024-03-04 18:23:02 发布

阅读量8.7k

点赞数 3

分类专栏： Big Data Greenplum+Hadoop学习笔记文章标签： greenplum

本文链接：https://blog.csdn.net/mavs41/article/details/51420591

版权

1 查询数据
1.1 系统数据字典
1) 所有的系统数据字典存放在pg_catalog模式下；
2) 标准的PostgreSQL系统数据字典是以pg_*开头；
3) GP特定的数据字典是以gp_*开头；

devdw=# select * from gp_configuration;
 content | definedprimary | dbid | isprimary | valid | hostname | port | datadir 
---------+----------------+------+-----------+-------+----------+------+---------
(0 rows)
devdw=# select * from gp_pgdatabase;
 dbid | isprimary | content | valid | definedprimary 
------+-----------+---------+-------+----------------
    1 | t         |      -1 | t     | t
    2 | t         |       0 | t     | t
    3 | t         |       1 | t     | t
(3 rows)

4) 在PSQL中列出所有的系统字典：\dtS，列出所有的系统视图：\dvS

devdw=# \dtS     列出所有的系统字典表
                                            List of relations
   Schema   |                              Name                               | Type  |  Owner  | Storage 
------------+-----------------------------------------------------------------+-------+---------+---------
 pg_catalog | gp_configuration                                                | table | gpadmin | heap
 pg_catalog | gp_configuration_history                                        | table | gpadmin | heap
 pg_catalog | gp_db_interfaces                                                | table | gpadmin | heap
 pg_catalog | gp_distribution_policy                                          | table | gpadmin | heap
 pg_catalog | gp_fastsequence                                                 | table | gpadmin | heap
 pg_catalog | gp_fault_strategy                                               | table | gpadmin | heap
 pg_catalog | gp_global_sequence                                              | table | gpadmin | heap
 pg_catalog | gp_id                                                           | table | gpadmin | heap
 pg_catalog | gp_interfaces                                                   | table | gpadmin | heap
 pg_catalog | gp_master_mirroring                                             | table | gpadmin | heap
 pg_catalog | gp_persistent_database_node                                     | table | gpadmin | heap
 pg_catalog | gp_persistent_filespace_node                                    | table | gpadmin | heap
 pg_catalog | gp_persistent_relation_node                                     | table | gpadmin | heap
 pg_catalog | gp_persistent_tablespace_node                                   | table | gpadmin | heap
 pg_catalog | gp_relation_node                                                | table | gpadmin | heap
 pg_catalog | gp_san_configuration                                            | table | gpadmin | heap
 pg_catalog | gp_segment_configuration                                        | table | gpadmin | heap
 pg_catalog | gp_verification_history                                         | table | gpadmin | heap
 pg_catalog | gp_version_at_initdb                                            | table | gpadmin | heap
 pg_catalog | pg_aggregate                                                    | table | gpadmin | heap
 pg_catalog | pg_am                                                           | table | gpadmin | heap
 pg_catalog | pg_amop                                                         | table | gpadmin | heap
 pg_catalog | pg_amproc                                                       | table | gpadmin | heap
 pg_catalog | pg_appendonly                                                   | table | gpadmin | heap
 pg_catalog | pg_appendonly_alter_column                                      | table | gpadmin | heap
 pg_catalog | pg_attrdef                                                      | table | gpadmin | heap
 pg_catalog | pg_attribute                                                    | table | gpadmin | heap
 pg_catalog | pg_attribute_encoding                                           | table | gpadmin | heap
 pg_catalog | pg_auth_members                                                 | table | gpadmin | heap
 pg_catalog | pg_auth_time_constraint                                         | table | gpadmin | heap
 pg_catalog | pg_authid                                                       | table | gpadmin | heap
 pg_catalog | pg_autovacuum                                                   | table | gpadmin | heap
 pg_catalog | pg_cast                                                         | table | gpadmin | heap
 pg_catalog | pg_class                                                        | table | gpadmin | heap
 pg_catalog | pg_compression                                                  | table | gpadmin | heap
 pg_catalog | pg_constraint                                                   | table | gpadmin | heap
 pg_catalog | pg_conversion                                                   | table | gpadmin | heap
 pg_catalog | pg_database                                                     | table | gpadmin | heap
 pg_catalog | pg_depend