THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Type | Field Size | Default Value | Description |
---|---|---|---|
Int8 | 1 | 0 | 1-byte signed integer |
Int16 | 1, 2 | 0 | 2-byte signed integer, but may occupy less space due to compression mechanism described below |
Int32 | 1, 2, 4 | 0 | 4-byte signed integer, but may occupy less space due to compression mechanism described below |
Int64 | 1, 2, 4, 8 | 0 | 8-byte signed integer, but may occupy less space due to compression mechanism described below |
Float | 4 | 0.0 | 4-byte floating-point number |
Double | 4, 8 | 0.0 | 8-byte floating-point number, but may occupy 4 bytes if fits into float w/o loss of precision |
Number | variable | 0 | Variable-length integer |
Decimal | variable | 0 | Variable-length fixed-point number, the scale is determined by the schema though it is stored with the number |
UUID | 16 | 00000000-0000-0000-0000-000000000000 | UUID |
String | variable | empty string | An utf-8 encoded string |
Binary | variable | empty binary | Variable-length arbitrary binary data |
Bitmask | variable | empty bit-string | Variable-length binary data representing a bit-string |
Date | 3 |
before 1 AD in the Gregorian calendar) | A timezone-free date (a year, month, day) |
Time | 4, 5, 6 | 00:00:00.000000 | A timezone-free time (hour, minute, second, microseconds) |
DateTime | 7, 8, 9 | Jan 1, 1 BC, 00:00:00.000000 | A timezone-free datetime encoded as (date, time) |
Timestamp | 8, 12 | Jan 1, 1970, 00:00:00.000000 | Number of microseconds since Jan 1, 1970 00:00:00.000000 (with no timezone) |
Duration | 8, 12 | 0 (PT0S) | See below |
Period | 3, 6, 12 | 0 (P0D) | See below |
Boolean | 1 | false | A boolean value (either true of false ) |
...