Nov 172012
 

Greenplum data types
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

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>