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