influxdb-python icon indicating copy to clipboard operation
influxdb-python copied to clipboard

bug: bind_params cause InfluxDBClientError: expected field argument

Open CunjunYin opened this issue 3 years ago • 1 comments

  • **InfluxDB version:1.24.0
  • **InfluxDB-python version: 5.3.1
  • **Python version: 3.8.5
  • **Operating system version: Ubuntu 20.04

sample query client.query(query='SELECT mean( $var ) FROM "TABLE" WHERE time > $peroid GROUP BY time(10m) fill(0);', bind_params ={"var": name, "peroid":time })

ERROR: InfluxDBClientError: expected field argument in mean()

when replace $var with name everything works fine client.query(query='SELECT mean( "NAME" ) FROM "TABLE" WHERE time > $peroid GROUP BY time(10m) fill(0);', bind_params ={"var": name, "peroid":time })

CunjunYin avatar Jan 06 '22 01:01 CunjunYin

bind_params is (AFAIK) only supported in the WHERE-clause, not in the SELECT. You might have to add specific field-validation instead of using bind_params for that.

DrakezulsMinimalism avatar Jan 27 '22 08:01 DrakezulsMinimalism