文档首页/
云数据库 GeminiDB/
GeminiDB Influx接口/
常见问题/
产品咨询/
如何处理报错"select *" query without time range is not allowed
更新时间:2023-03-02 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'
父主题: 产品咨询