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" <[email protected]>;
Date: Mon, Dec 13, 2021 05:19 PM
To: "[email protected]"<[email protected]>;
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

Reply via email to