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 2020/10/26 08:10:15 UTC

[GitHub] [iotdb] Alima777 commented on issue #1843: 降频聚合分析select count('iotDB关键字') align by device后结果集出现问题

Alima777 commented on issue #1843:
URL: https://github.com/apache/iotdb/issues/1843#issuecomment-716384826


   Hi,
   
   由于**非 Align by device 查询**不支持在结果集中显示常量列，所以用单引号包裹查询没有问题。但是 Align by device 为了支持更加类似关系表结构的输出方式，是支持常量列的，即**将单引号包裹的字符串作为常量而非测点进行输出**，所以您给出的查询结果是符合预期的。
   
   ![image](https://user-images.githubusercontent.com/34242296/97148152-9a422180-17a5-11eb-8510-cfc4eb832d9e.png)
   
   我这边直接使用 level 查询是没问题的，您可以尝试把单引号去掉查询。


----------------------------------------------------------------
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.

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