You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "SeanGaluzzi (via GitHub)" <gi...@apache.org> on 2024/01/15 15:37:29 UTC

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

SeanGaluzzi opened a new issue, #11903:
URL: https://github.com/apache/iotdb/issues/11903

   ### 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!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Query error, An error occured within the plugin [iotdb]

Posted by "SeanGaluzzi (via GitHub)" <gi...@apache.org>.
SeanGaluzzi commented on issue #11903:
URL: https://github.com/apache/iotdb/issues/11903#issuecomment-1893336466

   @HTHou I've come across some queries that function well using the "align by device" method with both the LAST_VALUE and DISTINCT IoTDB functions.
   
   ## DISTINCT FUNCTION
       
   ![DISTINCT](https://github.com/apache/iotdb/assets/126893672/2a1a8114-b561-4b8f-85ab-8078d090eaea)
   
   ## and it also returns a timestamp
   
   ![immagine (9)](https://github.com/apache/iotdb/assets/126893672/f5f96b46-8db1-4e4d-a80d-11e31b27d44b)
   
   ## LAST_VALUE FUNCTION
   
   ![LAST_VALUE](https://github.com/apache/iotdb/assets/126893672/75ad4a10-b80e-400c-b8ec-77836a751171)
   
   ![image](https://github.com/apache/iotdb/assets/126893672/b63aee8c-1f61-4de4-9e2e-297b3c5a0aeb)
   
   I suspect that Grafana appends a dummy timestamp (1970-01-01 01:00:00) to compensate for the fact that IoTDB doesn't always return a timestamp. However, as shown before some times it returns an error which is really difficult to debug without a proper message. In my opinion, this inconsistency is a bug since the functionality should ideally work consistently, either every time or never. It might be worth investigating further to ensure reliable behavior.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Query error, An error occured within the plugin [iotdb]

Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #11903:
URL: https://github.com/apache/iotdb/issues/11903#issuecomment-1893000767

   ![image](https://github.com/apache/iotdb/assets/19721744/69fb51e7-51e2-4521-a265-04f490bc20af)
   you can see it


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Query error, An error occured within the plugin [iotdb]

Posted by "SeanGaluzzi (via GitHub)" <gi...@apache.org>.
SeanGaluzzi commented on issue #11903:
URL: https://github.com/apache/iotdb/issues/11903#issuecomment-1959031360

   any updates?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] Query error, An error occured within the plugin [iotdb]

Posted by "HTHou (via GitHub)" <gi...@apache.org>.
HTHou commented on issue #11903:
URL: https://github.com/apache/iotdb/issues/11903#issuecomment-1892985293

   Hi, Grafana Plugin doesn't support aggregate with align by device due to the ResultSet missing time column. It is not a bug.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org