You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "zhaoxiuting (JIRA)" <ji...@apache.org> on 2019/05/24 09:31:00 UTC
[jira] [Created] (IOTDB-101) This is an example of SQL in user
manual. Why use sum function and mean function to process Boolean data???
zhaoxiuting created IOTDB-101:
---------------------------------
Summary: This is an example of SQL in user manual. Why use sum function and mean function to process Boolean data???
Key: IOTDB-101
URL: https://issues.apache.org/jira/browse/IOTDB-101
Project: Apache IoTDB
Issue Type: Bug
Reporter: zhaoxiuting
Attachments: image-2019-05-24-17-28-23-691.png
Step1：The first example of SQL in user manual is SELECT SUM(status), SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24.
The second example of SQL in user manual is SELECT MEAN(status), MEAN(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
Step2:
!image-2019-05-24-17-28-23-691.png!
Exception:It is suggested to modify the example SQL statement in the user manual.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
Re: [jira] [Created] (IOTDB-101) This is an example of SQL in user
manual. Why use sum function and mean function to process Boolean data???
Posted by 李天安 <lt...@mails.tsinghua.edu.cn>.
Hi，
Thanks for your report, it’s our carelessness when writing user doc. I have pull a pr to fix it. Pr link is :https://github.com/apache/incubator-iotdb/pull/182 <https://github.com/apache/incubator-iotdb/pull/182>
Best Regards,
—————————————————
Tianan Li
School of Software, Tsinghua University
> 在 2019年5月24日，下午5:31，zhaoxiuting (JIRA) <ji...@apache.org> 写道：
>
> zhaoxiuting created IOTDB-101:
> ---------------------------------
>
> Summary: This is an example of SQL in user manual. Why use sum function and mean function to process Boolean data???
> Key: IOTDB-101
> URL: https://issues.apache.org/jira/browse/IOTDB-101
> Project: Apache IoTDB
> Issue Type: Bug
> Reporter: zhaoxiuting
> Attachments: image-2019-05-24-17-28-23-691.png
>
> Step1：The first example of SQL in user manual is SELECT SUM(status), SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24.
>
> The second example of SQL in user manual is SELECT MEAN(status), MEAN(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
>
> Step2:
>
> !image-2019-05-24-17-28-23-691.png!
>
> Exception:It is suggested to modify the example SQL statement in the user manual.
>
>
>
>
>
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)