Help Center/ GeminiDB/ GeminiDB Influx API/ FAQs/ Product Consulting/ What Do I Do If Error "select *" query without time range is not allowed Is Reported?
Updated on 2023-09-06 GMT+08:00

What Do I Do If Error "select *" query without time range is not allowed Is Reported?

When you execute a query statement like SELECT* and give no constraints on the time range, error "select *" query without time range is not allowed will be reported. To resolve this problem, you need to rectify the query statement and specify time range constraints.

Example:

  • 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'