Hi all, I am recently working on this issue: https://issues.apache.org/jira/browse/IOTDB-305, which is about resolving the problem while users want to query something like below as the issue reporter Lei Rui said:
select * from root.sg.d1,root.sg.d2 where s1=1 <device separate>(a demo conception) / select * from root.sg.* where s1=1 <device separate>(a demo conception) There is no specific sql that could satisfy this kind of query requirement. The only one which is similar to this concept is using the “group by device” statement. However, it also cannot return the appropriate result the users need as what Lei Rui mentioned in the issue. Now, I plan to edit the implement logic of the “group by device” statement. The original implement method, which is like using the “and” statement to form the condition part of the sql as mentioned in this issue, cannot well suited for regular users’ requirements. In conclusion, the original function of the “group by device” will be abandoned, and it will be replaced by the one which mentioned in this issue to satisfy users query. I’m not sure whether this is OK for you guys or the project. So if you got any advice, please welcome to discuss with me. Best regards, Jack Tsai