search

timeplus-io / proton-java-driver

JDBC driver for Timeplus Proton
https://timeplus.com
Apache License 2.0
3 stars 0 forks source link

Feature/issue 12 test jdbc history query #13

Closed leo-cai-timeplus closed 8 months ago

leo-cai-timeplus commented 8 months ago

Data Type Conversion Table

Proton Type JDBC Type Java Type Java Object Type
interval_year BIGINT long java.lang.Long
interval_quarter BIGINT long java.lang.Long
interval_month BIGINT long java.lang.Long
interval_week BIGINT long java.lang.Long
interval_day BIGINT long java.lang.Long
interval_hour BIGINT long java.lang.Long
interval_minute BIGINT long java.lang.Long
interval_second BIGINT long java.lang.Long
uint8 SMALLINT short java.lang.Short
uint16 INTEGER int java.lang.Integer
uint32 BIGINT long java.lang.Long
uint64 NUMERIC long java.lang.Long
uint128 NUMERIC java.math.BigInteger java.math.BigInteger
uint256 NUMERIC java.math.BigInteger java.math.BigInteger
int8 TINYINT byte java.lang.Byte
byte TINYINT byte java.lang.Byte
int16 SMALLINT short java.lang.Short
smallint SMALLINT short java.lang.Short
int32 INTEGER int java.lang.Integer
integer INTEGER int java.lang.Integer
int64 BIGINT long java.lang.Long
bigint BIGINT long java.lang.Long
int128 NUMERIC java.math.BigInteger java.math.BigInteger
int256 NUMERIC java.math.BigInteger java.math.BigInteger
bool BOOLEAN byte java.lang.Byte
boolean BOOLEAN byte java.lang.Byte
date DATE java.time.LocalDate java.time.LocalDate
date32 DATE java.time.LocalDate java.time.LocalDate
datetime TIMESTAMP_WITH_TIMEZONE java.time.LocalDateTime java.time.LocalDateTime
datetime32 TIMESTAMP_WITH_TIMEZONE java.time.LocalDateTime java.time.LocalDateTime
datetime64 TIMESTAMP_WITH_TIMEZONE java.time.LocalDateTime java.time.LocalDateTime
decimal DECIMAL java.math.BigDecimal java.math.BigDecimal
decimal32 DECIMAL java.math.BigDecimal java.math.BigDecimal
decimal64 DECIMAL java.math.BigDecimal java.math.BigDecimal
decimal128 DECIMAL java.math.BigDecimal java.math.BigDecimal
decimal256 DECIMAL java.math.BigDecimal java.math.BigDecimal
uuid VARCHAR java.util.UUID java.util.UUID
enum8 VARCHAR java.lang.String java.lang.String
enum VARCHAR java.lang.String java.lang.String
enum16 VARCHAR java.lang.String java.lang.String
float32 FLOAT float java.lang.Float
float FLOAT float java.lang.Float
float64 DOUBLE double java.lang.Double
double DOUBLE double java.lang.Double
ipv4 VARCHAR java.net.Inet4Address java.net.Inet4Address
ipv6 VARCHAR java.net.Inet6Address java.net.Inet6Address
fixed_string VARCHAR java.lang.String java.lang.String
string VARCHAR java.lang.String java.lang.String
aggregate_function OTHER java.lang.String java.lang.String
simple_aggregate_function OTHER java.lang.String java.lang.String
array ARRAY java.lang.Object java.lang.Object
map OTHER java.util.Map java.util.Map
nested STRUCT java.lang.Object java.lang.Object
tuple STRUCT java.util.List java.util.List
point ARRAY java.lang.Object java.lang.Object
polygon ARRAY java.lang.Object java.lang.Object
multi_polygon ARRAY java.lang.Object java.lang.Object
ring ARRAY java.lang.Object java.lang.Object
nothing NULL java.lang.Object java.lang.Object