Nov 172012
Greenplum data types
This article contains the overview of Greenplum Data Types and detailed examples. Greenplum Unified Analytics Platform (UAP) combines the co-processing of structured and unstructured data with a productivity engine that enables collaboration among your data science team. Greenplum UAP includes Greenplum Database, Greenplum HD, and Greenplum Chorus
| Greenplum Data Types | Size | Description |
| bigint | 8 bytes | large range integer |
| bigserial | 8 bytes | large autoincrementing integer |
| bit [ (n) ] | n bits | fixed-length bit string |
| bit varying [ (n) ] | actual number of bits | variable-length bit string |
| boolean | 1 byte | logical boolean (true/false) |
| box | 32 bytes | rectangular box in the plane – not allowed in distribution key columns. |
| bytea | 1 byte + binary string | variable-length binary string |
| character [ (n) ] | 1 byte + n | fixed-length, blank padded |
| character varying [ (n) ] | 1 byte + string size | variable-length with limit |
| cidr | 12 or 24 bytes | IPv4 and IPv6 networks |
| circle | 24 bytes | circle in the plane – not allowed in distribution key columns. |
| date | 4 bytes | calendar date (year, month, day) |
| decimal [ (p, s) ] | variable | user-specified precision, exact |
| double precision | 8 bytes | variable-precision, inexact |
| inet | 12 or 24 bytes | IPv4 and IPv6 hosts and networks |
| integer | 4 bytes | usual choice for integer |
| interval [ (p) ] | 12 bytes | time span |
| lseg | 32 bytes | line segment in the plane – not allowed in distribution key columns. |
| macaddr | 6 bytes | MAC addresses |
| money | 4 bytes | currency amount |
| path | 16+16n bytes | geometric path in the plane – not allowed in distribution key columns. |
| point | 16 bytes | geometric point in the plane – not allowed in distribution key columns. |
| polygon | 40+16n bytes | closed geometric path in the plane – not allowed in distribution key columns. |
| real | 4 bytes | variable-precision, inexact |
| serial | 4 bytes | autoincrementing integer |
| smallint | 2 bytes | small range integer |
| text | 1 byte + string size | variable unlimited length |
| time [ (p) ] [ without time zone ] | 8 bytes | time of day only |
| time [ (p) ] with time zone | 12 bytes | time of day only, with time zone |
| timestamp [(p)] [without time zone ] | 8 bytes | both date and time |
| timestamp [ (p) ] with time zone | 8 bytes | both date and time, with time zone |
| xml | 1 byte + xml size | variable unlimited length |