文档首页/ 云数据库 GeminiDB/ GeminiDB Influx接口/ 常见问题/ 产品咨询/ 如何处理报错"select *" query without time range is not allowed
更新时间:2023-04-11 GMT+08:00

如何处理报错"select *" query without time range is not allowed

当执行形如select *且未做时间范围约束的查询语句时,错误"select *" query without time range is not allowed就会发生。需要修正查询语句,确保select * 查询语句有时间范围约束。

示例:

  • select * from measurement where time > '2023-01-19T12:00:00Z' and time <= '2023-01-19T13:00:00Z'
  • select * from measurement where time = '2023-01-19T12:30:00Z'