You are viewing a plain text version of this content. The canonical link for it is here.

Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/11/26 07:01:03 UTC

[GitHub] [iotdb] CloudsYy opened a new issue #4475: 需求：union all 多时间序列查询

CloudsYy opened a new issue #4475:
URL: https://github.com/apache/iotdb/issues/4475


   **Is your feature request related to a problem? Please describe.**
   比如：
   我现在要查一个大的网关设备，下面连着两个子设备，子设备下面有很多测点(1.风速、1.温度、2.湿度)，这两个设备分别上传的数据时间不一样，我想查出的他们的历史的数据，然后带有时间，我查就会出现这样的情况，就像这样
   ![afb61d1113831bbd81088f5544735a7](https://user-images.githubusercontent.com/31236828/143538097-14f513b1-718c-4088-9ec4-31fcafa16547.png)
   ![4cd19c19b2d2773e7b4e2f06620f5c5](https://user-images.githubusercontent.com/31236828/143538108-97f8e396-8b90-423d-ba80-f1148380286d.png)
   ![e7cfc0f382fc85bb471e7f4a348fa58](https://user-images.githubusercontent.com/31236828/143538115-e7668cb5-6b8e-423a-845b-f516f4d4daad.png)
   
   **Describe the solution you'd like**
   我希望能够通过类似mysql 中 union all 多表查询，返回一个结果集，比如我可以这样查
   select * from root.device.1 slimit 2 align by device union all select * from root.device.2 slimit 1 align by device
   
   **Describe alternatives you've considered**
   然后返回结果集可以是这样子的：
   root.device.1 -> time,wind_speed,temperature
   root.device.2 -> time,humidity


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [iotdb] github-actions[bot] commented on issue #4475: 需求：union all 多时间序列查询

Posted by GitBox <gi...@apache.org>.

github-actions[bot] commented on issue #4475:
URL: https://github.com/apache/iotdb/issues/4475#issuecomment-979738435


   Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org