influxdata / influxdata/influxdb
now() not working on bind_params
Nobody has claimed this yet.
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
Hi, I am trying to implement bind params on my DataFrameClient query.
The following code returns an error:
params = {"start": "1h",
"stop": "now()"}
query = """
SELECT * FROM alerts
WHERE
time >= $start - $end
GROUP BY
time(1m)
"""
data = client.query(query, bind_params=params)
Error is as follows:
influxdb.exceptions.InfluxDBClientError: invalid operation: time and *influxql.BinaryExpr are not compatible
If I replace "1h" and "now()" in params with timestamps then the code compiles fine, like so:
params = {"start": "2020-02-21",
"stop": "2020-02-22"}
query = """
SELECT * FROM alerts
WHERE
time >= $start - $end
GROUP BY
time(1m)
"""
data = client.query(query, bind_params=params)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the DataFrameClient.query entry point and reproduce the reported bind_params query using "1h" and "now()". Trace how those parameters are handled and compare the failing expression with the timestamp-based case; done means the reported query no longer raises the time and BinaryExpr incompatibility error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100