Skip to content

Discrepancy in Count Query Results Between Grafana-Plugins and IoTDB CLI #11711

@SeanGaluzzi

Description

@SeanGaluzzi

Search before asking

  • I searched in the issues and found nothing similar.

Version

  • IoTDB 1.2.2 Standalone
  • IoTDB Grafana Plugin 1.0 (Grafana interface)
  • Grafana 10.2.2

Describe the bug and provide the minimal reproduce step

Problem Description

When executing a SELECT COUNT(DISTINCT()) query, there's an observed inconsistency in the returned count value between Grafana-Plugins and the IoTDB CLI. While the IoTDB CLI returns the expected and accurate count, the Grafana-Plugins display an incorrect count number.

IoTDB CLI Result (Correct Count)

IoTDB CLI Result
IoTDB CLI Query

Grafana Explore Query (Incorrect Count)

Grafana Explore Query
Grafana Explore Result

Steps to Reproduce

  1. Execute the SELECT COUNT(DISTINCT()) query using IoTDB CLI.
  2. Execute the same query using Grafana-Plugins within the Grafana Explore interface.
  3. Compare the returned count values.

What did you expect to see?

Expected Behavior

The count value returned by Grafana-Plugins should align with the count value retrieved using IoTDB CLI for the same COUNT(DISTINCT()) query.

What did you see instead?

Actual Behavior

During the execution of the SELECT COUNT(DISTINCT()) query using Grafana-Plugins, the returned count value deviates from the expected count. Specifically, the count value displayed in Grafana-Plugins is 0, whereas the accurate count obtained through IoTDB CLI is 2.

Anything else?

The blurried part of the path are just for obscure sensitive data.

Are you willing to submit a PR?

  • I'm willing to submit a PR!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions