This is an automated email from the ASF dual-hosted git repository.
critas pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new 688f423e Modify multi device downsampling alignment query (#763)
688f423e is described below
commit 688f423eddc9c8f15e9525205f04efade55628d0
Author: W1y1r <[email protected]>
AuthorDate: Thu May 29 15:37:14 2025 +0800
Modify multi device downsampling alignment query (#763)
---
.../Master/Table/Basic-Concept/Query-Data.md | 24 ++++++++++-----------
.../latest-Table/Basic-Concept/Query-Data.md | 25 +++++++++++-----------
.../Master/Table/Basic-Concept/Query-Data.md | 24 ++++++++++-----------
.../latest-Table/Basic-Concept/Query-Data.md | 24 ++++++++++-----------
4 files changed, 49 insertions(+), 48 deletions(-)
diff --git a/src/UserGuide/Master/Table/Basic-Concept/Query-Data.md
b/src/UserGuide/Master/Table/Basic-Concept/Query-Data.md
index d096be94..22ec4c07 100644
--- a/src/UserGuide/Master/Table/Basic-Concept/Query-Data.md
+++ b/src/UserGuide/Master/Table/Basic-Concept/Query-Data.md
@@ -326,11 +326,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS b_time,
**Example: Aligning multiple sequences by integer time:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -338,14 +338,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) B
- ON A.a_time=B.b_time
+ USING (time)
```
**Result:**
@@ -368,11 +368,11 @@ IoTDB> SELECT A.a_time AS TIME,
**Example:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -380,14 +380,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) B
- ON A.a_time=B.b_time
+ USING (time)
```
**Result:**
@@ -486,11 +486,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS c_time,
**Example: Aligning multiple sequences by the higher sampling frequency:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
c_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -498,14 +498,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS c_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS c_value
FROM table3
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) C
- ON A.a_time=C.c_time
+ USING (time)
```
**Result:**
diff --git a/src/UserGuide/latest-Table/Basic-Concept/Query-Data.md
b/src/UserGuide/latest-Table/Basic-Concept/Query-Data.md
index d096be94..b3018d2f 100644
--- a/src/UserGuide/latest-Table/Basic-Concept/Query-Data.md
+++ b/src/UserGuide/latest-Table/Basic-Concept/Query-Data.md
@@ -139,6 +139,7 @@ IoTDB> SELECT time, temperature, humidity
Total line number = 7
It costs 0.106s
```
+
**Example 3:Multi device time aligned query**
```SQL
@@ -326,11 +327,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS b_time,
**Example: Aligning multiple sequences by integer time:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -338,14 +339,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) B
- ON A.a_time=B.b_time
+ USING (time)
```
**Result:**
@@ -368,11 +369,11 @@ IoTDB> SELECT A.a_time AS TIME,
**Example:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -380,14 +381,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) B
- ON A.a_time=B.b_time
+ USING (time)
```
**Result:**
@@ -486,11 +487,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS c_time,
**Example: Aligning multiple sequences by the higher sampling frequency:**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
c_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -498,14 +499,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS c_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS c_value
FROM table3
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) C
- ON A.a_time=C.c_time
+ USING (time)
```
**Result:**
diff --git a/src/zh/UserGuide/Master/Table/Basic-Concept/Query-Data.md
b/src/zh/UserGuide/Master/Table/Basic-Concept/Query-Data.md
index 6dd453e1..811f816d 100644
--- a/src/zh/UserGuide/Master/Table/Basic-Concept/Query-Data.md
+++ b/src/zh/UserGuide/Master/Table/Basic-Concept/Query-Data.md
@@ -329,11 +329,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS b_time,
**示例：按整点将多个序列进行时间对齐：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -341,14 +341,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) B
- ON A.a_time=B.b_time
+ USING (time)
```
**结果:**
@@ -371,11 +371,11 @@ IoTDB> SELECT A.a_time AS TIME,
**示例：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -383,14 +383,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) B
- ON A.a_time=B.b_time
+ USING (time)
```
**结果:**
@@ -489,11 +489,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS c_time,
**示例：按照高采样频率进行对齐：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
c_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -501,14 +501,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS c_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS c_value
FROM table3
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) C
- ON A.a_time=C.c_time
+ USING (time)
```
**结果：**
diff --git a/src/zh/UserGuide/latest-Table/Basic-Concept/Query-Data.md
b/src/zh/UserGuide/latest-Table/Basic-Concept/Query-Data.md
index 6dd453e1..811f816d 100644
--- a/src/zh/UserGuide/latest-Table/Basic-Concept/Query-Data.md
+++ b/src/zh/UserGuide/latest-Table/Basic-Concept/Query-Data.md
@@ -329,11 +329,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS b_time,
**示例：按整点将多个序列进行时间对齐：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -341,14 +341,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) B
- ON A.a_time=B.b_time
+ USING (time)
```
**结果:**
@@ -371,11 +371,11 @@ IoTDB> SELECT A.a_time AS TIME,
**示例：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
b_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -383,14 +383,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS b_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS b_value
FROM table2
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1) B
- ON A.a_time=B.b_time
+ USING (time)
```
**结果:**
@@ -489,11 +489,11 @@ IoTDB> SELECT date_bin_gapfill(1s, TIME) AS c_time,
**示例：按照高采样频率进行对齐：**
```SQL
-IoTDB> SELECT A.a_time AS TIME,
+IoTDB> SELECT time,
a_value,
c_value
FROM
- (SELECT date_bin_gapfill(1s, TIME) AS a_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(temperature) AS a_value
FROM table1
WHERE device_id = 'd1'
@@ -501,14 +501,14 @@ IoTDB> SELECT A.a_time AS TIME,
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) A
JOIN
- (SELECT date_bin_gapfill(1s, TIME) AS c_time,
+ (SELECT date_bin_gapfill(1s, TIME) AS time,
first(humidity) AS c_value
FROM table3
WHERE device_id = 'd1'
AND TIME >= 2025-05-13 00:00:00.000
AND TIME <= 2025-05-13 00:00:07.000
GROUP BY 1 FILL METHOD PREVIOUS) C
- ON A.a_time=C.c_time
+ USING (time)
```
**结果：**
