【详述】ddl新建clickhouse外部表 然后select * 显示错误
【StarRocks版本】StarRocks-3.0.0-rc02
create external resource resource_ck5
properties (
“type”=“jdbc”,
“user”=“user1”,
“password”=“passwd1”,
“jdbc_uri”=“jdbc:clickhouse://4.4.4.4:8123/tb1?allowPublicKeyRetrieval=false”,
“driver_url”=“http://pc1/clickhouse-jdbc-0.4.6-all.jar”,
“driver_class”=“com.clickhouse.jdbc.ClickHouseDriver”
);
CREATE EXTERNAL TABLE ck1 (
device_id String
,report_date BIGINT NULL
) ENGINE=JDBC
COMMENT “JDBC”
PROPERTIES (
“resource” = “resource_ck5”,
“table” = “tb11”
);
select * from ck1 报错:
ERROR 1064 (HY000): Type is not supported on column[report_date], JDBC result type is [java.math.BigInteger]
uint64不能用bigint接?
难道是因为我的starrocks版本太低?
