You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by Eric Pai <er...@hotmail.com> on 2021/12/13 09:19:29 UTC
New feature - The ability of nesting expressions in an aggregation query
Dear all,
A new feature, the ability of nesting expressions outside aggregation functions, has been finished in master branch. Now we can query like this:
* Nested arbitrary expressions outside aggregation queries: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1;
* Nested arbitrary expressions in a GROUP BY query: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1 GROUP BY([0, 9000), 1s);
Next, I will move forward to implement the new feature under GROUP BY LEVEL and GROUP BY FILL query.
For a brief introduction and example, please reference the user documents in https://iotdb.apache.org/UserGuide/Master/IoTDB-SQL-Language/DML-Data-Manipulation-Language.html#aggregate-query
JIRA: https://issues.apache.org/jira/browse/IOTDB-2091
Thanks
Re: New feature - The ability of nesting expressions in an aggregation query
Posted by Trevor Hart <tr...@ope.nz>.
Thank you so much! Ive been after this for a while now!
Very excited.
Thanks
Trevor Hart
Ope Limited
w: http://www.ope.nz/
m: +64212728039
---- On Mon, 13 Dec 2021 22:19:29 +1300 Eric Pai <er...@hotmail.com> wrote ----
Dear all,
A new feature, the ability of nesting expressions outside aggregation functions, has been finished in master branch. Now we can query like this:
* Nested arbitrary expressions outside aggregation queries: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1;
* Nested arbitrary expressions in a GROUP BY query: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1 GROUP BY([0, 9000), 1s);
Next, I will move forward to implement the new feature under GROUP BY LEVEL and GROUP BY FILL query.
For a brief introduction and example, please reference the user documents in https://iotdb.apache.org/UserGuide/Master/IoTDB-SQL-Language/DML-Data-Manipulation-Language.html#aggregate-query
JIRA: https://issues.apache.org/jira/browse/IOTDB-2091
Thanks
Re:New feature - The ability of nesting expressions in an aggregation query
Posted by Steve Su <st...@qq.com.INVALID>.
Hi,
This is definitely an exciting feature! I love both the implementation and the functionality.
Looking forward to your further contributions: D
Cheers!
Steve Su
------------------ Original ------------------
From: "dev" <er...@hotmail.com>;
Date: Mon, Dec 13, 2021 05:19 PM
To: "dev@iotdb.apache.org"<de...@iotdb.apache.org>;
Subject: New feature - The ability of nesting expressions in an aggregation query
Dear all,
A new feature, the ability of nesting expressions outside aggregation functions, has been finished in master branch. Now we can query like this:
* Nested arbitrary expressions outside aggregation queries: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1;
* Nested arbitrary expressions in a GROUP BY query: select sum(s1) + sum(s2), -sum(s3), sum(s4) , sin(sum(s4) + cos(avg(s4)) + 1, sin(cos(sum(s5))) from root.sg.d1 GROUP BY([0, 9000), 1s);
Next, I will move forward to implement the new feature under GROUP BY LEVEL and GROUP BY FILL query.
For a brief introduction and example, please reference the user documents in https://iotdb.apache.org/UserGuide/Master/IoTDB-SQL-Language/DML-Data-Manipulation-Language.html#aggregate-query
JIRA: https://issues.apache.org/jira/browse/IOTDB-2091
Thanks