Apache Drill DataTypes
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
Still loading...
ABCDEFGHIJKL
1
ENUM#Minor TypeBYTESCommonTypeDescription/NotesAlso Known AsPROTO DEF
2
0LATEn/aLatelate binding type LATE = 0; // late binding type
3
1MAPn/aMapan empty map column. Useful for conceptual setup. Children listed within here MAP = 1; // an empty map column. Useful for conceptual setup. Children listed within here
4
2REPEATMAPn/aRepeatMapa repeated map column (means that multiple children sit below this) REPEATMAP = 2; // a repeated map column (means that multiple children sit below this)case REPEATMAP: return RepeatMap.class;
5
3TINYINT1Fixed1single byte signed integer TINYINT = 3; // single byte signed integercase TINYINT: return Fixed1.class;case TINYINT: return NullableFixed1.class;case TINYINT: return RepeatedFixed1.class;case TINYINT: return 1;case TINYINT: return new Fixed1(field, allocator);
6
4SMALLINT2Fixed2two byte signed integer SMALLINT = 4; // two byte signed integercase SMALLINT: return Fixed2.class;case SMALLINT: return NullableFixed2.class;case SMALLINT: return RepeatedFixed2.class;case SMALLINT: return 2;case SMALLINT: return new Fixed2(field, allocator);
7
5INT4Fixed4four byte signed integer INT = 5; // four byte signed integercase INT: return Fixed4.class;case INT: return NullableFixed4.class;case INT: return RepeatedFixed4.class;case INT: return 4;case INT: return new Fixed4(field, allocator);
8
6BIGINT8Fixed8eight byte signed integer BIGINT = 6; // eight byte signed integercase BIGINT: return Fixed8.class;case BIGINT: return NullableFixed8.class;case BIGINT: return RepeatedFixed8.class;case BIGINT: return 8;case BIGINT: return new Fixed8(field, allocator);
9
7DECIMAL44Fixed4a decimal supporting precision between 1 and 8 (4 bits for decimal location, 1 sign)numeric DECIMAL4 = 7; // a decimal supporting precision between 1 and 8 (4 bits for decimal location, 1 sign)case DECIMAL4: return Fixed4.class;case DECIMAL4: return NullableFixed4.class;case DECIMAL4: return RepeatedFixed4.class;case DECIMAL4: return 4;case DECIMAL4: return new Fixed4(field, allocator);
10
8DECIMAL88Fixed8a decimal supporting precision between 9 and 18 (5 bits for decimal location, 1 sign)numeric DECIMAL8 = 8; // a decimal supporting precision between 9 and 18 (5 bits for decimal location, 1 sign)case DECIMAL8: return Fixed8.class;case DECIMAL8: return NullableFixed8.class;case DECIMAL8: return RepeatedFixed8.class;case DECIMAL8: return 8;case DECIMAL8: return new Fixed8(field, allocator);
11
9DECIMAL1212Fixed12a decimal supporting precision between19 and 28 (5 bits for decimal location, 1 sign)numeric DECIMAL12 = 9; // a decimal supporting precision between19 and 28 (5 bits for decimal location, 1 sign)case DECIMAL12: return Fixed12.class;case DECIMAL12: return NullableFixed12.class;case DECIMAL12: return RepeatedFixed12.class;case DECIMAL12: return 12;case DECIMAL12: return new Fixed12(field, allocator);
12
10DECIMAL1616Fixed16a decimal supporting precision between 29 and 37 (6 bits for decimal location, 1 sign)numeric DECIMAL16 = 10; // a decimal supporting precision between 29 and 37 (6 bits for decimal location, 1 sign)case DECIMAL16: return Fixed16.class;case DECIMAL16: return NullableFixed16.class;case DECIMAL16: return RepeatedFixed16.class;case DECIMAL16: return 16;case DECIMAL16: return new Fixed16(field, allocator);
13
11MONEY8Fixed8signed decimal with two digit precision MONEY = 11; // signed decimal with two digit precisioncase MONEY: return Fixed8.class;case MONEY: return NullableFixed8.class;case MONEY: return RepeatedFixed8.class;case MONEY: return 8;case MONEY: return new Fixed8(field, allocator);
14
12DATE4Fixed4days since 4713bc DATE = 12; // days since 4713bc case DATE: return Fixed4.class;case DATE: return NullableFixed4.class;case DATE: return RepeatedFixed4.class;case DATE: return 4;case DATE: return new Fixed4(field, allocator);
15
13TIME8Fixed8time in micros before or after 2000/1/1 TIME = 13; // time in micros before or after 2000/1/1case TIME: return Fixed8.class;case TIME: return NullableFixed8.class;case TIME: return RepeatedFixed8.class;case TIME: return 8;case TIME: return new Fixed8(field, allocator);
16
14TIMETZ12Fixed12time in micros before or after 2000/1/1 with timezone TIMETZ = 14; // time in micros before or after 2000/1/1 with timezonecase TIMETZ: return Fixed12.class;case TIMETZ: return NullableFixed12.class;case TIMETZ: return RepeatedFixed12.class;case TIMETZ: return 12;case TIMETZ: return new Fixed12(field, allocator);
17
15TIMESTAMP8Fixed8unix epoch time in millis TIMESTAMP = 15; // unix epoch time in milliscase TIMESTAMP: return Fixed8.class;case TIMESTAMP: return NullableFixed8.class;case TIMESTAMP: return RepeatedFixed8.class;case TIMESTAMP: return 8;case TIMESTAMP: return new Fixed8(field, allocator);
18
16DATETIME8Fixed8TBD DATETIME = 16; // TBDcase DATETIME: return Fixed8.class;case DATETIME: return NullableFixed8.class;case DATETIME: return RepeatedFixed8.class;case DATETIME: return 8;case DATETIME: return new Fixed8(field, allocator);
19
17INTERVAL12Fixed12TBD INTERVAL = 17; // TBDcase INTERVAL: return Fixed12.class;case INTERVAL: return NullableFixed12.class;case INTERVAL: return RepeatedFixed12.class;case INTERVAL: return 12;case INTERVAL: return new Fixed12(field, allocator);
20
18FLOAT44Fixed44 byte ieee 754 real, float FLOAT4 = 18; // 4 byte ieee 754 case FLOAT4: return Fixed4.class;case FLOAT4: return NullableFixed4.class;case FLOAT4: return RepeatedFixed4.class;case FLOAT4: return 4;case FLOAT4: return new Fixed4(field, allocator);
21
19FLOAT88Fixed88 byte ieee 754double, double precision FLOAT8 = 19; // 8 byte ieee 754case FLOAT8: return Fixed8.class;case FLOAT8: return NullableFixed8.class;case FLOAT8: return RepeatedFixed8.class;case FLOAT8: return 8;case FLOAT8: return new Fixed8(field, allocator);
22
20BOOLEAN1/8Bitsingle bit value BOOLEAN = 20; // single bit valuecase BOOLEAN: return Bit.class;case BOOLEAN: return NullableBit.class;case BOOLEAN: return RepeatedBit.class;case BOOLEAN: return 1/8;case BOOLEAN: return new Bit(field, allocator);
23
21FIXEDCHARlenFixedLenutf8 fixed length string, padded with spaces FIXEDCHAR = 21; // utf8 fixed length string, padded with spacescase FIXEDCHAR: return FixedLen.class;case FIXEDCHAR: return NullableFixedLen.class;case FIXEDCHAR: return RepeatedFixedLen.class;case FIXEDCHAR: return len;case FIXEDCHAR: return new FixedLen(field, allocator);
24
22VARCHAR22 + lenVarLen2utf8 variable length string (up to 2^16 in length) VARCHAR2 = 22; // utf8 variable length string (up to 2^16 in length)case VARCHAR2: return VarLen2.class;case VARCHAR2: return NullableVarLen2.class;case VARCHAR2: return RepeatedVarLen2.class;case VARCHAR2: return 2 + len;case VARCHAR2: return new VarLen2(field, allocator);
25
23VARCHAR44 + lenVarLen4utf8 variable length string (up to 2^32 in length) VARCHAR4 = 23; // utf8 variable length string (up to 2^32 in length)case VARCHAR4: return VarLen4.class;case VARCHAR4: return NullableVarLen4.class;case VARCHAR4: return RepeatedVarLen4.class;case VARCHAR4: return 4 + len;case VARCHAR4: return new VarLen4(field, allocator);
26
24FIXEDBINARYlenFixedLenfixed length binary, padded with 0 bytes FIXEDBINARY = 24; // fixed length binary, padded with 0 bytescase FIXEDBINARY: return FixedLen.class;case FIXEDBINARY: return NullableFixedLen.class;case FIXEDBINARY: return RepeatedFixedLen.class;case FIXEDBINARY: return len;case FIXEDBINARY: return new FixedLen(field, allocator);
27
25VARBINARY22 + lenVarLen2variable length binary (up to 2^16 in length) VARBINARY2 = 25; // variable length binary (up to 2^16 in length)case VARBINARY2: return VarLen2.class;case VARBINARY2: return NullableVarLen2.class;case VARBINARY2: return RepeatedVarLen2.class;case VARBINARY2: return 2 + len;case VARBINARY2: return new VarLen2(field, allocator);
28
26VARBINARY44 + lenVarLen4variable length binary (up to 2^32 in length) VARBINARY4 = 26; // variable length binary (up to 2^32 in length)case VARBINARY4: return VarLen4.class;case VARBINARY4: return NullableVarLen4.class;case VARBINARY4: return RepeatedVarLen4.class;case VARBINARY4: return 4 + len;case VARBINARY4: return new VarLen4(field, allocator);
29
27UINT11Fixed1unsigned 1 byte integer UINT1 = 27; // unsigned 1 byte integercase UINT1: return Fixed1.class;case UINT1: return NullableFixed1.class;case UINT1: return RepeatedFixed1.class;case UINT1: return 1;case UINT1: return new Fixed1(field, allocator);
30
28UINT22Fixed2unsigned 2 byte integer UINT2 = 28; // unsigned 2 byte integercase UINT2: return Fixed2.class;case UINT2: return NullableFixed2.class;case UINT2: return RepeatedFixed2.class;case UINT2: return 2;case UINT2: return new Fixed2(field, allocator);
31
29UINT44Fixed4unsigned 4 byte integer UINT4 = 29; // unsigned 4 byte integercase UINT4: return Fixed4.class;case UINT4: return NullableFixed4.class;case UINT4: return RepeatedFixed4.class;case UINT4: return 4;case UINT4: return new Fixed4(field, allocator);
32
30UINT88Fixed8unsigned 8 byte integer UINT8 = 30; // unsigned 8 byte integercase UINT8: return Fixed8.class;case UINT8: return NullableFixed8.class;case UINT8: return RepeatedFixed8.class;case UINT8: return 8;case UINT8: return new Fixed8(field, allocator);
33
31PROTO22 + lenVarLen2protobuf encoded complex type. (up to 2^16 in length) PROTO2 = 31; // protobuf encoded complex type. (up to 2^16 in length)case PROTO2: return VarLen2.class;case PROTO2: return NullableVarLen2.class;case PROTO2: return RepeatedVarLen2.class;case PROTO2: return 2 + len;case PROTO2: return new VarLen2(field, allocator);
34
32PROTO44 + lenVarLen4protobuf encoded complex type. (up to 2^32 in length) PROTO4 = 32; // protobuf encoded complex type. (up to 2^32 in length)case PROTO4: return VarLen4.class;case PROTO4: return NullableVarLen4.class;case PROTO4: return RepeatedVarLen4.class;case PROTO4: return 4 + len;case PROTO4: return new VarLen4(field, allocator);
35
33MSGPACK22 + lenVarLen2msgpack encoded complex type. (up to 2^16 in length) MSGPACK2 = 33; // msgpack encoded complex type. (up to 2^16 in length)case MSGPACK2: return VarLen2.class;case MSGPACK2: return NullableVarLen2.class;case MSGPACK2: return RepeatedVarLen2.class;case MSGPACK2: return 2 + len;case MSGPACK2: return new VarLen2(field, allocator);
36
34MSGPACK44 + lenVarLen4msgpack encoded complex type. (up to 2^32 in length) MSGPACK4 = 34; // msgpack encoded complex type. (up to 2^32 in length)case MSGPACK4: return VarLen4.class;case MSGPACK4: return NullableVarLen4.class;case MSGPACK4: return RepeatedVarLen4.class;case MSGPACK4: return 4 + len;case MSGPACK4: return new VarLen4(field, allocator);
Loading...
 
 
 
Basic Data Types
ValueVector Types