Doris数据库安装及使用

Apache Doris 是一款基于 MPP 架构的高性能、实时的分析型数据库。适用于‌大数据分析、‌实时分析‌、日志分析‌。支持表、视图、函数等

1、Doris安装

Doris是一款分布式的MPP数据库，正式环境部署一定要采用多节点方式部署。本文为方便演示，采用Docker 单节点方式部署，正式环境部署请参考官方文档。

1.1 拉取镜像

docker pull apache/doris:doris-all-in-one-2.1.0

1.2 运行容器 doris

docker run -it -d --name doris \
-p 8030:8030 -p 8040:8040 -p 9030:9030 -p 8048:8048 \
apache/doris:doris-all-in-one-2.1.0

端口介绍：

• 8030: FE 服务端口。
• 8040: BE 服务端口。
• 9030: FE 的 MySQL 协议端口。

使用浏览器访问：http://localhost:8030/home ，如果能正常访问Doris界面代表启动成功。

1.3连接数据库

使用mysql客户端访问Doris

mysql -uadmin -P9030 -h127.0.0.1

创建测试库

create database jimureport;
use jimureport;

创建测试表

DROP TABLE IF EXISTS `test_demo`;
CREATE TABLE `test_demo` (
  `id` VARCHAR(32) NOT NULL COMMENT '主键',
  `create_by` VARCHAR(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_time` DATETIME DEFAULT NULL COMMENT '创建日期',
  `update_by` VARCHAR(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_time` DATETIME DEFAULT NULL COMMENT '更新日期',
  `no` VARCHAR(30) DEFAULT NULL COMMENT '编号',
  `name` VARCHAR(200) DEFAULT NULL COMMENT '用户名',
  `sex` VARCHAR(32) DEFAULT NULL COMMENT '性别',
  `age` INT DEFAULT NULL COMMENT '年龄',
  `descc` VARCHAR(500) DEFAULT NULL COMMENT '描述',
  `birthday` DATETIME DEFAULT NULL COMMENT '生日',
  `file_kk` VARCHAR(500) DEFAULT NULL COMMENT '附件',
  `top_pic` VARCHAR(500) DEFAULT NULL COMMENT '头像',
  `sel_search` VARCHAR(32) DEFAULT NULL COMMENT '下拉搜索',
  `fen_tree` VARCHAR(200) DEFAULT NULL COMMENT '分类字典',
  `blob_txt` STRING COMMENT '大字段',
  `sel_mult` VARCHAR(200) DEFAULT NULL COMMENT '多选下拉',
  `cust_tree` VARCHAR(200) DEFAULT NULL COMMENT '自定义树',
  `sel_user` VARCHAR(200) DEFAULT NULL COMMENT '选择用户',
  `sel_dep` VARCHAR(200) DEFAULT NULL COMMENT '选择部门',
  `chengshi` VARCHAR(200) DEFAULT NULL COMMENT '省市区',
  `is_open` VARCHAR(1) DEFAULT NULL COMMENT '开关',
  `bpm_status` VARCHAR(2) DEFAULT NULL COMMENT '流程状态',
  `qc_time` VARCHAR(32) DEFAULT NULL COMMENT '起床时间'
) UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
    "replication_allocation" = "tag.location.default: 1"
);

插入测试数据

INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1244275574052069377', 'admin', '2020-03-29 22:49:49', 'admin', '2020-03-29 22:49:55', '1', 'JEECG用户', '2', 712, '18611111111', NULL, NULL, NULL, 'jeecg', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1244451590208847873', 'admin', '2020-03-30 10:29:15', 'admin', '2020-03-30 10:29:56', '2', '李四', '1', 22, 'null', NULL, 'https://static.jeecg.com/temp/gh_f28e66390fc9_344 (shop)_1585535389933.jpg,https://static.jeecg.com/temp/gh_0cf466a0aa08_258 (cms)_1585535393383.jpg', 'https://static.jeecg.com/temp/11_1585535385960.jpg,https://static.jeecg.com/temp/1112_1585535386759.jpg', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1245192850573905921', 'admin', '2020-04-01 11:34:45', 'admin', '2021-06-07 15:38:02', '4', '张三', '2', 11, '15010853032', NULL, '', '', '', '', '', '', '', '', '', '120101', 'N', NULL, '');
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1247856910876667905', 'admin', '2020-04-08 20:00:46', 'admin', '2021-08-03 18:18:45', '4', '王五', '1', 130, '', '1959-10-01 00:00:00', '', '', '', '', '', '', '', '', '', '120102', 'N', NULL, '');
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1272525317374849026', 'admin', '2020-06-15 21:44:12', 'admin', '2021-08-03 18:18:51', '5', '赵六', '1', 33, '', '2020-06-17 03:02:11', '', '', '', '', '', '', '', '', '', '110101', 'N', NULL, '');
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1272525403630710785', 'admin', '2020-06-15 21:44:33', 'admin', '2020-07-27 17:32:06', '6', '管理员', '2', 622, '18611788525', '2020-06-12 00:00:00', '', '', '', '', '', NULL, '', '', '', '', 'N', NULL, NULL);
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1273802277560377345', 'admin', '2020-06-19 10:18:24', 'admin', '2020-11-11 11:26:02', '7', '孙七', '2', 5011, '<p>186111111113333</p>', NULL, 'temp/jeecg cloud 微服务架构图_1592534712178.png', 'temp/jeecg cloud 微服务架构图_1592533111865.png', '', '', '', '1227492235802251265', '', '', 'a7d7e77e06c84325a40932163adcdaa6,57197590443c44f083d42ae24ef26a2c', '140423', 'N', NULL, '');
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1275416273598132225', 'admin', '2020-06-23 21:11:50', 'admin', '2020-08-18 13:54:07', NULL, '周八', '2', 1379, '', '1959-10-01 00:00:00', '捷微200_1592917896501.png', 'https://static.jeecg.com/temp/20180607175028Fn1Lq7zw_1592981132188.png', 'jeecg', NULL, '', '1227492235802251265,a75d45a015c44384a04449ee80dc3503', NULL, NULL, NULL, NULL, 'Y', NULL, NULL);

2、积木报表链接测试

• 新建数据源

数据源类型选择Doris

• 选择数据源并解析字段

• 设计报表

• 预览