一、开发环境
OpenJDK版本 >= 17
ClickHouse:20.7+
1、支持的数据类型
Format
Support
Comment
AggregatedFunction
❌
limited to groupBitmap, and known to have issue with 64bit bitmap
Array(*)
✅
Bool
✅
Date*
✅
DateTime*
✅
Decimal*
✅
SET output_format_decimal_trailing_zeros=1 in 21.9+ for consistency
Enum*
✅
can be treated as both string and integer
Geo Types
✅
Point, Ring, Polygon, and MultiPolygon
Int*, UInt*
✅
UInt64 is mapped to long
IPv*
✅
Map(*)
✅
Nested(*)
✅
Object('JSON')
✅
SimpleAggregateFunction
✅
*String
✅
Tuple(*)
✅
UUID
✅
二、Java客户端方式
1、引入依赖
<dependency>
<groupId>com.clickhouse</groupId>
<!-- or clickhouse-grpc-client if you prefer gRPC -->
<artifactId>clickhouse-http-client</artifactId>
<version>0.4.0</version>
</dependency>
2、连接ClickHouse
一、开发环境
OpenJDK版本 >= 17
ClickHouse:20.7+
1、支持的数据类