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 <[email protected]> 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
