[Fiware-tech-help] QuantumLeap REST API support for TimescaleDB

[Federico Michele Facca]

Dear Taz,
I replied you in FIWARE JIRA, but probably the reply never went through the
mailing list. I am not sure how the integration works between the two. So,
sorry if this reply in the ml comes so late.

While TimescaleDB support on queries was introduced in QL version 0.8.0
<https://github.com/orchestracities/ngsi-timeseries-api/blob/master/RELEASE_NOTES.md#080>
in
Feb 2021 (and lately tested also in production at high rates - 300
input/sec), you may have found a bug.

Still with the information provided it is hard to say and reproduce the
issue, and it could very likely be the problem is related to configuration
or usage, rather than a bug.
I recommend the you to provide a full trace of the test (how he configured
ql and timescale, which data he sent, ect) and open a ticket on our
official channel:
https://github.com/orchestracities/ngsi-timeseries-api/issues

Best,
Federico

Hi
> For several reasons, I opted to use TimescaleDB over CrateDB for our
> FIWARE implementation, but I have only just found out that it's not
> possible to retrieve historical data through the QuantumLeap REST API.
> I can retrieve a list of endpoints with:
> $ curl http://localhost:8668/v2/
> { "attributes_url": "/v2/attrs", "entities_url": "/v2/entities",
> "notify_url": "/v2/notify", "subscriptions_url": "/v2/subscriptions",
> "types_url": "/v2/types" }
> but disappointingly no results from any other requests, eg:
> $ curl http://localhost:8668/v2/entities/urn:ngsi-ld:Entity:0001
> { "description": "No records were found for such query.", "error": "Not
> Found" }
> and even just an entity list is empty:
> $ curl http://localhost:8668/v2/entities
> { "description": "No records were found for such query.", "error": "Not
> Found" }
> I then spotted this "At the moment, QuantumLeap implement experimental
> querying of data through the QuantumLeap REST API. This means that while
> REST API on top of CrateDB have been tested in production, this is not the
> case for Timescale" in the docs
> https://quantumleap.readthedocs.io/en/latest/.
> So my questions are:
> 1. Is there a roadmap as to when TimescaleDB is going to be supported by
> the QuantumLeap REST API?
> 2. Would it help expedite things if we were to support your development by
> doing some beta testing along the way?
> We really are interested in using the QuantumLeap API for retrieving
> historical data.
> Kind regards
> Taz
> Chalmers University of Technology
> <http://www.chalmers.se>




*Dr. FEDERICO MICHELE FACCA*
*CTO, Head of Martel Lab*
+41 788075838
*MARTEL INNOVATE* <https://www.martel-innovate.com/> - INNOVATION, WE MAKE
IT HAPPEN
Click *HERE* to download Martel reports and white papers!
<https://www.martel-innovate.com/premium-content/>
Follow us on *TWITTER* <https://twitter.com/Martel_Innovate>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20220312/e13ac557/attachment.html>