[
https://issues.apache.org/jira/browse/IOTDB-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17582803#comment-17582803
]
QiangShaowei commented on IOTDB-4203:
-------------------------------------
[email protected]:22260> select * from root.ln.**
+-----------------------------+-----------------------------+------------------------+
|
Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status|
+-----------------------------+-----------------------------+------------------------+
|1970-01-01T08:00:00.100+08:00| null|
true|
|1970-01-01T08:00:00.200+08:00| 20.71|
false|
|2022-08-22T14:22:30.244+08:00| null|
true|
|2022-08-22T14:43:04.782+08:00| null|
true|
+-----------------------------+-----------------------------+------------------------+
Total line number = 4
It costs 0.076s
[email protected]:22260> select temperature from root.ln.** align by device;
+-----------------------------+-----------------+-----------+
| Time| Device|temperature|
+-----------------------------+-----------------+-----------+
|1970-01-01T08:00:00.200+08:00|root.ln.wf01.wt01| 20.71|
+-----------------------------+-----------------+-----------+
Total line number = 1
It costs 0.032s
{color:#FF0000}[email protected]:22260> select temperature from root.ln.**
where root.ln.wf01.wt01.temperature > 10 align by device;{color}
{color:#FF0000}Msg: 416: ALIGN BY DEVICE: the suffix paths can only be
measurement or one-level wildcard{color}
{color:#FF0000}[email protected]:22260{color}>
> after upgrade IOTDB, Align by device has error
> ----------------------------------------------
>
> Key: IOTDB-4203
> URL: https://issues.apache.org/jira/browse/IOTDB-4203
> Project: Apache IoTDB
> Issue Type: Bug
> Reporter: QiangShaowei
> Priority: Minor
>
> After upgrate IoTDB to 0.14, a sql with TS status and align by device don't
> support
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
