Re: support grammar 'HAVING' in IoTDB

2022-06-29 Thread Yuan Tian
Hi, Good catch, in previous `without null any/all`, any stands for `and`(your choice 1); all stands for `or`(your choice 2); I think in our having clause, we can keep consistent with where clause. In our where clause, if you write select s1 from root.sg.* where s1 > 1, we will write it as select

Re: support grammar 'HAVING' in IoTDB

2022-06-29 Thread Eric Pai
This is really a good feature! Unlike relational database query, the 'column' name in IoTDB is a string concatenated by the prefix path in FROM clause and the suffix path in SELECT clause. In some cases maybe there are more than 1 output columns. If so, does one simple HAVING clause still work

support grammar 'HAVING' in IoTDB

2022-06-29 Thread 18110526...@163.com
Hello everyone, We want to support having clause in IoTDB. 1.Background Replace grammar ‘without null any/all()’ to help users easier to understand and use. 2.Specification 2.1Current query grammar selectStatement : TRACING? selectClause intoClause? fromClause whereClause? specialClause?