apache / apache/iotdb

[Bug] Query error, An error occured within the plugin

Open
#11,903 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/iotdb/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 LAST_VALUE(*) align by device query using grafana IoTDB plugin the query return an error. While the IoTDB CLI returns the expected and accurate results

# Grafana Explore Query
![Grafana_Query_Blurred](https://github.com/apache/iotdb/assets/126893672/b319b36d-9e55-48d0-8f73-8631578d4df3)

## also tried without the * on the SELECT Statement:

![Grafana_Query_AvoidingStar](https://github.com/apache/iotdb/assets/126893672/39dee605-32c8-4ed7-9ad0-3ae3aea5a948)

# IoTDB Cli
![IoTDB_Query_Blurried](https://github.com/apache/iotdb/assets/126893672/8fd54b2a-6e43-43b9-96a9-7a2324ef9268)

### What did you expect to see?

## Expected Behavior
The same table that IoTDB Cli return using the same syntax:

![IoTDB_Query_Blurried](https://github.com/apache/iotdb/assets/126893672/c92206bb-abcb-4c86-a2d5-8c3f4d0f0e6b)

### What did you see instead?

## Actual Behavior
Using this syntax on Grafana with the IoTDB plugin return "Query error, An error occured within the plugin"

### Anything else?

Also tried using DISTINCT Statment but nothing changed

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!

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the SELECT LAST_VALUE(*) align by device query through the IoTDB Grafana Plugin and compare it with the successful IoTDB CLI result. No source file, test, or stack trace is named; done means the Grafana query returns the same expected table instead of the plugin error.

Written by the indexing model from the issue text.

Assessment

Tech stack
grafana, java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 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.