KUDU表的增删改查

一、创建kudu表

CREATE TABLE IOV_DAILY (
	`DID` string,
	`START_GEAR` INT,
	`DATA_TIME` BIGINT,
	`DATA_DAY` string,
	`POINTS` INT,
	PRIMARY KEY ( DID, START_GEAR, DATA_TIME ) 
) PARTITION BY HASH ( DID ) PARTITIONS 15,
RANGE ( DATA_TIME ) ( PARTITION VALUES < 1577808000000, 
PARTITION 1577808000000 <= VALUES < 1609430400000,
PARTITION 1609430400000 <= VALUES < 1640966400000 ) STORED AS KUDU

二、查看建表语句

show create table `表名`

三、删除表

drop table `表名`

四、新增列

alter TABLE `表名` add columns(open_time bigint, STORAGE_TIME bigint);

五、删除列

alter TABLE `表名` DROP COLUMN open_time;