O'Reilly logo

Greenplum - Architecture and SQL by Leona Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 – Greenplum Table Structures

“Let me once again explain the rules. The Greenplum Data Warehouse Rules!”

- Tera-Tom Coffing

The Concepts of Greenplum Tables

1.Tables are either Distributed by Hash or Distributed Randomly.

2.Tables are either stored in a heap or are append-only tables.

3.The rows of a table by default are unsorted in a heap or they can be physically sorted with a clustered index.

4.Tables are stored physically on disk in either a row or columnar format.

5.Tables can be partitioned.

6.Tables are either permanent, temporary or external Tables.

7.Table can have Primary and Foreign Key constraints although Foreign Key constraints are not enforced.

8.Tables can have Unique constraints and other Boolean constraints.

9.Compression ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required