phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jamie Murray <Jamie.Mur...@D2L.com>
Subject Data type integer representation documentation
Date Wed, 07 Jan 2015 19:32:00 GMT
Hello,

I am looking to find documentation on the integer representation used by Phoenix for its data
types listed here: http://phoenix.apache.org/language/datatypes.html

Here is what I have found so far, this came from a combination of java.sql types for the non-unsigned
types and some phoenix investigation for the unsigned types.

-6  --> TINYINT
5  --> SMALLINT
4  --> INTEGER
-5  --> BIGINT
6  --> FLOAT
8  --> DOUBLE
3  --> DECIMAL
16  --> BOOLEAN
91  --> DATE
92  --> TIME
93  --> TIMESTAMP
12  --> VARCHAR
1  --> CHAR
-2  --> BINARY
-3  --> VARBINARY
9 --> UNSIGNED_INT
10 --> UNSIGNED_LONG
11 --> UNSIGNED_TINYINT
13 --> UNSIGNED_SMALLINT
14 --> UNSIGNED_FLOAT
15 --> UNSIGNED_DOUBLE
18 --> UNSIGNED_TIME
19 --> UNSIGNED_DATE
19 --> UNSIGNED_TIMESTAMP

As you can see I am actually getting the same value for UNSIGNED_DATE and UNSIGNED_TIMESTAMP,
is this intended?  Or am I getting incorrect information.

Thanks,

Jamie

Mime
View raw message