kudu建表sql怎么写?
解决方法:
其中ousn就是唯一主键非空
CREATE TABLE sys_new (
ousn INT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
oucode STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
effectivedate BIGINT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
PRIMARY KEY (ousn)
)
PARTITION BY HASH (ousn) PARTITIONS 8
STORED AS KUDU