ClickHouse Java JDBC Type Mapping

The below table maps from one clickhouse data type to one java data type:

ClickHouse TypeSizeSQL TypeJava TypeDecimal Digits
Array(UInt8)ARRAY
Date10DATEDate
DateTime19TIMESTAMPTimestamp
Decimal(5)DECIMALBigDecimal
EnumVARCHARString
FixedString(1)1VARCHARString
Float328FLOATFloat8
Float6417DOUBLEDouble17
Int166INTEGERInteger
Int3211INTEGERInteger
Int6420BIGINTLong
Int84INTEGERInteger
StringVARCHARString
TupleVARCHARString
UInt165INTEGERLong
UInt3210INTEGERLong
UInt6419BIGINTBigInteger
UInt83INTEGERLong

The table is generated from: TypeUtils.java