This is an automated email from the ASF dual-hosted git repository. hui pushed a commit to branch lmh/docUpdate in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 251491955dacd885a56bcec093aedda40ebb231b Author: Minghui Liu <[email protected]> AuthorDate: Wed Nov 2 16:45:02 2022 +0800 update Pagination --- docs/UserGuide/Query-Data/Pagination.md | 35 ------------------------------ docs/zh/UserGuide/Query-Data/Pagination.md | 32 --------------------------- 2 files changed, 67 deletions(-) diff --git a/docs/UserGuide/Query-Data/Pagination.md b/docs/UserGuide/Query-Data/Pagination.md index 3992f1f8a7..9bb61ec14b 100644 --- a/docs/UserGuide/Query-Data/Pagination.md +++ b/docs/UserGuide/Query-Data/Pagination.md @@ -142,18 +142,6 @@ Total line number = 4 It costs 0.016s ``` -It is worth noting that because the current FILL clause can only fill in the missing value of timeseries at a certain time point, that is to say, the execution result of FILL clause is exactly one line, so LIMIT and OFFSET are not expected to be used in combination with FILL clause, otherwise errors will be prompted. For example, executing the following SQL statement: - -```sql -select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(previous, 1m) limit 10 -``` - -The SQL statement will not be executed and the corresponding error prompt is given as follows: - -``` -Msg: 401: line 1:107 mismatched input 'limit' expecting {<EOF>, ';'} -``` - ## Column Control over Query Results By using SLIMIT and SOFFSET clauses, users can control the query results in a column-related manner. We will demonstrate how to use SLIMIT and SOFFSET clauses through the following examples. @@ -240,29 +228,6 @@ Total line number = 7 It costs 0.000s ``` -* Example 4: SLIMIT clause combined with FILL clause - -The SQL statement is: - -```sql -select * from root.sgcc.wf03.wt01 where time = 2017-11-01T16:35:00 fill(previous, 1m) slimit 1 soffset 1 -``` -which means: - -The selected device is ln group wf01 plant wt01 device; the selected timeseries is the second column under this device, i.e., the temperature. - -The result is shown below: - -``` -+-----------------------------+--------------------------+ -| Time|root.sgcc.wf03.wt01.status| -+-----------------------------+--------------------------+ -|2017-11-01T16:35:00.000+08:00| true| -+-----------------------------+--------------------------+ -Total line number = 1 -It costs 0.007s -``` - ## Row and Column Control over Query Results In addition to row or column control over query results, IoTDB allows users to control both rows and columns of query results. Here is a complete example with both LIMIT clauses and SLIMIT clauses. diff --git a/docs/zh/UserGuide/Query-Data/Pagination.md b/docs/zh/UserGuide/Query-Data/Pagination.md index 6b05da57e6..06da5bba3e 100644 --- a/docs/zh/UserGuide/Query-Data/Pagination.md +++ b/docs/zh/UserGuide/Query-Data/Pagination.md @@ -146,18 +146,6 @@ Total line number = 4 It costs 0.016s ``` -值得注意的是，由于当前的 FILL 子句只能在某个时间点填充时间序列的缺失值，也就是说，FILL 子句的执行结果恰好是一行，因此 LIMIT 和 OFFSE 不能与 FILL 子句结合使用，否则将提示错误。 例如，执行以下 SQL 语句： - -```sql -select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(previous, 1m) limit 10 -``` - -错误提示如下： - -``` -Msg: 401: Error occured while parsing SQL to physical plan: line 1:101 mismatched input 'limit' expecting {<EOF>, ';'} -``` - ## 按列分页 通过使用 `SLIMIT` 和 `SOFFSET` 子句，用户可以与列相关的方式控制查询结果。 我们将通过以下示例演示如何使用 `SLIMIT` 和 `SOFFSET` 子句。 @@ -246,26 +234,6 @@ Total line number = 7 It costs 0.000s ``` -- **示例 4：** `SLIMIT` 子句与 `FILL` 子句结合 - -SQL 语句： - -```sql -select * from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(previous, 1m) slimit 1 soffset 1 -``` - -含义： - -``` -+-----------------------------+--------------------------+ -| Time|root.sgcc.wf03.wt01.status| -+-----------------------------+--------------------------+ -|2017-11-01T16:35:00.000+08:00| true| -+-----------------------------+--------------------------+ -Total line number = 1 -It costs 0.007s -``` - ## 行和列混合分页 除了对查询结果进行行或列控制之外，IoTDB 还允许用户控制查询结果的行和列。 这是同时包含 `LIMIT` 子句和 `SLIMIT` 子句的完整示例。
