Doris Tips

create table example

CREATE TABLE celery_tasks_valuetable (
	id BIGINT, 
	`StartDate` DATEV2, 
	`EndDate` DATEV2, 
	`Value` FLOAT, 
	`BranchNumber_id` TEXT, 
	`ValueTypeId_id` BIGINT, 
	`UpdateTime` DATETIME
)
DISTRIBUTED BY HASH(`EndDate`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
)

create user example

create USER helei@'%' IDENTIFIED BY 'heleidorismima'

permission modify example

GRANT SELECT_PRIV ON spider.* TO 'helei'@'%';

drop table example

DROP TABLE spider.doris_dict_map_table