influxdata / influxdata/influxdb

SHOW MEASUREMENTS doesn't support time in WHERE clause

Open
#17,672 0 comments 0 reactions 0 assignees View on GitHub
area/documentation
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

When running query

`SHOW MEASUREMENTS WITH MEASUREMENT=~/^mymsmt.*/ WHERE time>now()-1h`

I am getting error

'SHOW MEASUREMENTS doesn't support time in WHERE clause'

Documentation says that time filter is supported by SHOW MEASUREMENTS: [schema_exploration/#filter-meta-queries-by-time](https://docs.influxdata.com/influxdb/v1.7/query_language/schema_exploration/#filter-meta-queries-by-time)

> To filter other meta data, replace SHOW TAG KEYS with SHOW TAG VALUES, SHOW SERIES, SHOW MEASUREMENTS, SHOW FIELD KEYS, and so on.

It also mentions SHOW FIELD KEYS which doesn't even support WHERE clause!
This is inconsistency between implementation and documentation.

(I would prefer to have this implemented, as I was expecting it to exist and now seem to have to query each measurement for series in time range.)

InfluxDB v 1.7.10

Thank you very much.
Igor

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the SHOW MEASUREMENTS query with the time predicate and compare its behavior with the schema exploration documentation linked in the issue. Trace the schema meta-query handling to determine the supported WHERE clauses; done means the documented time filter works consistently, or the documentation accurately reflects the implementation.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.