docker-安装doris

准备(linux 机器)：

sudo sysctl -w vm.max_map_count=2000000 ---设置最大句柄
sudo swapoff -a ---关闭交换内存swap

https://blog.csdn.net/luoyeyilin/article/details/135293726

 

建表语句：

CREATE TABLE IF NOT EXISTS test_13
(
`user_id` BIGINT NOT NULL COMMENT "用户id",
`username` VARCHAR(50) NOT NULL COMMENT "用户昵称",
`city` VARCHAR(20) COMMENT "用户所在城市",
`age` SMALLINT COMMENT "用户年龄",
`sex` TINYINT COMMENT "用户性别",
`phone` LARGEINT COMMENT "用户电话",
`address` VARCHAR(500) COMMENT "用户地址",
`register_time` DATETIME COMMENT "用户注册时间"
)
UNIQUE KEY(`user_id`, `username`)
DISTRIBUTED BY HASH(`user_id`) BUCKETS 10

PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);

 

INSERT INTO test_13 VALUES
(10001, 'Alice', 'Beijing', 28, 0, 13800138000, 'Chaoyang District, Beijing', '2024-01-15 10:30:00'),
(10002, 'Bob', 'Shanghai', 35, 1, 13900139000, 'Pudong District, Shanghai', '2023-11-20 14:45:00'),
(10003, 'Charlie', 'Guangzhou', 22, 1, 13700137000, 'Tianhe District, Guangzhou', '2023-06-10 09:15:00'),
(10004, 'Diana', 'Shenzhen', 30, 0, 13600136000, 'Nanshan District, Shenzhen', '2024-02-01 18:00:00'),
(10005, 'Eve', 'Hangzhou', 27, 0, 13500135000, 'Xihu District, Hangzhou', '2023-12-05 16:20:00');