This code whether only limit operations are supported and offset operations are not supported？

[zhuyuncheng]

🌹🌹

[imay]

We support both limit and offset. When there is an order by clause, offset will effect. However if there is no order by clause, data is not ordered, and offset is useless, so we ignore offset.

[zhuyuncheng]

We support both limit and offset. When there is an order by clause, offset will effect. However if there is no order by clause, data is not ordered, and offset is useless, so we ignore offset.

SHOW LOAD FROM xx ORDER BY CreateTime DESC LIMIT 3,2 This query offset is not supported.

[zhuyuncheng]

https://github.com/apache/incubator-doris/blob/master/fe/src/main/java/org/apache/doris/analysis/ShowLoadStmt.java#L259 @imay Is offset discarded directly in ShowLoadStmt?

[imay]

@zhuyuncheng
I think you are right. Currently, we don't support offset in SHOW LOAD statement.

And can you give us a PR to support it?

[zhuyuncheng]

Let me try. @imay