stalary commented on issue #4638:
URL:
https://github.com/apache/incubator-doris/issues/4638#issuecomment-695766278
ddl
```
CREATE TABLE `dwd_live_att_lesson` (
`courseId` int(11) NOT NULL COMMENT "课程id",
`lessonId` int(11) NOT NULL COMMENT "课时id",
`userId` varchar(255) NOT NULL COMMENT "用户id",
`submitDay` date NOT NULL COMMENT "数据提交日期",
`liveId` varchar(255) NULL COMMENT "直播id",
`lessonDuration` bigint(20) NOT NULL COMMENT "单课时直播时长",
`groupId` int(11) NULL COMMENT "组id",
`watchedLiveDuration` bigint(20) NOT NULL COMMENT "已观看直播时长",
`watchedRecordDuration` bigint(20) NOT NULL COMMENT "已观看录播时长",
`watchedDuration` bigint(20) NOT NULL COMMENT "已观看时长",
`attendanceRate` double NOT NULL COMMENT "出勤率",
`syncedAt` bigint(20) NOT NULL COMMENT "同步时间"
) ENGINE=OLAP
UNIQUE KEY(`courseId`, `lessonId`, `userId`)
COMMENT "DWD层_直播出勤课时维度数据"
DISTRIBUTED BY HASH(`courseId`) BUCKETS 10
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2"
);
```
I use routine load import data
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
