Skip to content

Client cannot parse query results from InfluxDB 1.10.0 since the annotations are missing in the csv. #366

Closed as not planned
@ulf-melin-sveasolar

Description

@ulf-melin-sveasolar

Steps to reproduce:

  1. Using a client object: client = InfluxDBClientFactory.CreateV1(Configuration.Endpoint, Configuration.Username,
    Configuration.Password.ToCharArray(), Configuration.Database, RetentionPolicy);
  2. Query something like: from(bucket: "staging") |> range(start: -111h) |> filter(fn: (r) => r._measurement == "meter_values" and r._field == "sequence") |> filter(fn: (r) => r.chargerId == "southpark") |> max() |> limit(n:1)

Expected behavior:
I get a table with a record containing the _value I queried for.

In raw format, with annotations

#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,long,string,string,string,string,string,string,string,string,string,string,string
#group,false,false,true,true,false,false,true,true,true,true,true,true,true,true,true,true,true
#default,_result,,,,,,,,,,,,,,,,
,result,table,_start,_stop,_time,_value,_field,_measurement,chargerId,connectorId,context,locationId,measurand,productId,source,transactionId,unit
,,0,2022-08-02T18:46:34.4187654Z,2022-09-13T10:46:34.4187654Z,2022-09-13T10:43:31Z,101,sequence,meter_values,ulfsw,1,SamplePeriodic,hemma,EnergyActiveImportRegister,wallboxproduct,Outlet,5,KWh

Actual behavior:
Throws an exception:
InfluxDB.Client.Core.Flux.Exceptions.FluxCsvParserException: Unable to parse CSV response. FluxTable definition was not found.

In raw format, the annotations are missing:

,result,table,_start,_stop,_time,_value,_field,_measurement,chargerId,context,locationId,measurand,productId,source,unit
,_result,0,2022-09-08T18:39:25.800511841Z,2022-09-13T09:39:25.800511841Z,2022-09-10T14:05:09Z,521766,sequence,meter_values,southpark,SampleClock,17746a46-7275-4e03-87cb-e77d680b20e4,PowerActiveImport,fb08e075-dfb7-4821-97d1-2bc14e0f1a67,Outlet,KW

Specifications:

  • Client Version: 4.5.0
  • InfluxDB Version: 1.10.0 (Cloud)
  • Platform: .Net 6.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    wontfixThis will not be worked on

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions