1.doris修改默认密码,初始密码为空(必须是以本用户登录才能修改本用户的密码)
| |
| SET PASSWORD FOR 'root' = PASSWORD('123456'); |
| |
| |
2.doris创建用户
| #所有权限 |
| create user 'doris_user' identified by '123456'; |
| grant all on *.* to doris_user; |
| |
| #查询权限 |
| CREATE USER 'doris_user'@'10.%' IDENTIFIED BY '123456'; |
| GRANT SELECT_PRIV ON *.* TO 'doris_user'@'10.%'; |
| |
| |
| #增删改查权限 |
| CREATE USER 'doris_user'@'10.%' IDENTIFIED BY '123456'; |
| GRANT SELECT_PRIV,LOAD_PRIV,ALTER_PRIV,CREATE_PRIV,DROP_PRIV ON *.* TO 'doris_user'@'10.%'; |
| |
| 删除用户 |
| DROP USER 'doris_user'@'10.%'; |
3.按天创建分区表
保留7天分区数据,预创建未来3天分区
| CREATE TABLE partition_test_table |
| ( |
| data_time datetime NOT NULL COMMENT '时间(如2024-06-19 00:00:00)', |
| serial_number VARCHAR(20) NOT NULL COMMENT '电话号码', |
| user_name VARCHAR(8) NOT NULL COMMENT '用户名称' |
| ) |
| PARTITION BY RANGE(data_time) () |
| DISTRIBUTED BY HASH(data_time) |
| PROPERTIES |
| ( |
| "dynamic_partition.enable" = "true", |
| "dynamic_partition.time_unit" = "DAY", |
| "dynamic_partition.start" = "-7", |
| "dynamic_partition.end" = "3", |
| "dynamic_partition.prefix" = "p", |
| "dynamic_partition.buckets" = "32" |
| ); |
| |
| |
doris 使用指南 :http://cdnd.selectdb.com/zh-CN/docs/1.2/data-table/basic-usage
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)