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