Could you give a certain example?

CREATE TABLE `test` (
  `courseId` int(11) NOT NULL COMMENT "",
  `lessonId` int(11) NOT NULL COMMENT "",
  `type` int(11) REPLACE_IF_NOT_NULL NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`courseId`, `lessonId`)
COMMENT "测试"
DISTRIBUTED BY HASH(`courseId`) BUCKETS 150
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2"
);

select * from test limit 10
select * from test limit 1, 10 (default order by courseId)

CREATE TABLE `test` (
  `courseId` int(11) NOT NULL COMMENT "",
  `lessonId` int(11) NOT NULL COMMENT "",
  `type` int(11) REPLACE_IF_NOT_NULL NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`courseId`, `lessonId`)
COMMENT "测试"
DISTRIBUTED BY HASH(`courseId`) BUCKETS 150
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2"
);

select * from test limit 10
select * from test limit 1, 10 (default order by courseId)

It makes me confused...
And what about a more complex query?