influxdata / influxdata/influxdb

now() not working on bind_params

Open
#20,791 0 comments 0 reactions 0 assignees View on GitHub

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.