Tags are set to PointValues.fields when query with time() function

[bianbian]

Specifications

• Client Version: com.influxdb:influxdb3-java:0.5.1
• InfluxDB Version: [InfluxDB Cloud Serverless] Storage Engine Version 3
• Platform: macOS 14.0

We have following schema:

Measurement: energy
Tags: component, site_id
Fields: amount

Steps to reproduce:

1. Build InfluxQL with time() function
2. Query using influxDBClient.queryPoints(query, QueryOptions.INFLUX_QL)

Code sample to reproduce problem

String influxQL = "select time, first(amount) as amount, component, site_id from energy where site_id = 'test-251' group by time(15s)";

try (Stream<PointValues> points = influxDBClient.queryPoints(influxQL, QueryOptions.INFLUX_QL)) {
    return points;
}

Expected behavior

Measurement is set to PointValues.name
Tag: component, site_id are set to PointValues.tags
Fields: amount is set to PointValues.fields
time is set to PointValues.time

Actual behavior

Measurement is set to PointValues.name
Tags: component, site_id are set to PointValues.fields, tags are set to wrong place
Fields: amount is set to PointValues.fields
time is set to PointValues.time

Additional info

No response

[bednar]

Hello @bianbian,

Thank you for using our client and taking the time to report the issue you've encountered.

After a preliminary investigation, it appears that the issue stems from incorrect metadata reporting by the InfluxDB server. To help you continue your work without interruption, we suggest using a simplified query as a temporary solution. Here's an adjusted query that should work for your needs:

select time, amount as amount, component, site_id from energy where site_id = 'test-251'

This query modification sidesteps the problem by explicitly structuring the data selection, hopefully mitigating the issue at hand.

Rest assured, I will be contacting our server team to look into this matter and find a more permanent resolution. I aim to keep you updated with our progress and will reach out to you as soon as we have a clearer understanding or a fix for the issue.

Regards.

[bianbian]

Hi Bednar,

Thanks for your investigation and prompt reply.
Actually, we are heavy on the time() function. So it's better have a solution on it.

Looking forward for your future result with your server team.
Best regards.

[brerenat]

@bianbian @bednar I think with an update to influx cloud the tags are now being returned in the tags property instead of the fields property now. At least this is what we've observed while debugging an issue where our tags are suddenly missing 😭

[bednar]

Hi @brerenat, could you be a bit more specific about that tags are returned in the tag property?

[bednar]

@bianbian, the latest version of InfluxDB Serverless correctly propagates column types. Could you please test your queries with the latest version of the client?

Thanks!