Clickhouse

目录

• 类型对照
• 常见问题
  • Q1.java.sql.SQLFeatureNotSupportedException: Transactions are not supported

类型对照

Java	MySql	ClickHouse	Oracle	Hive	Flink Sql
boolean	boolean tinyint(1)	UInt8	NUMBER(1)	boolean	BOOLEAN
byte	tinyint	Int8	NUMBER(3,0)	tinyint	TINYINT
short	smallint tinyint unsigned	Int16 uint8	NUMBER(5,0)	smallint	SMALLINT
int	int mediumint smallint unsigned mediumint unsigned	Int32 uint16	NUMBER(10,0)	int	INT
long	bigint int unsigned	Int64 UInt32 Int128 Int256 uInt64 uInt128 uInt256	NUMBER(20,0)	bigint	BIGINT
float	float	Float32	BINARY_FLOAT	float	FLOAT
double	double	Float64	BINARY_DOUBLE	double	DOUBLE
String	varchar char text tinytext mediumtext longtext	String uuid fixedString	VARCHAR2 NVARCHAR2 CHAR NCHAR LONG	string	STRING VARCHAR
decimal	decimal numeric precision	Decimal	NUMBER FLOAT		DECIMAL
date	date year	Date			DATE
time	time				TIME(0)
timestamp	timestamp datetime	datetime64	date	timestamp	TIMESTAMP
byte[]	blob binary varbinary tinyblob mediumblob longblob		RAW		BYTES

常见问题

Q1.java.sql.SQLFeatureNotSupportedException: Transactions are not supported

一般都是clickhouse驱动版本的问题，要么使用版本高了，要么低了

<dependency>
    <groupId>ru.yandex.clickhouse</groupId>
    <artifactId>clickhouse-jdbc</artifactId>
    <version>0.2.4</version>
</dependency>