search

apache / druid

Apache Druid: a high performance real-time analytics database.
https://druid.apache.org/
Apache License 2.0
13.46k stars 3.7k forks source link

how to query data from deep storage through SQL #16747

Open youFireFly opened 3 months ago

youFireFly commented 3 months ago

I am able to query data from June 30th through SQL, and my Druid data retention policy is set to one month. There are segments from April stored in OBS (Object Storage Service). I would like to restore these segments into Druid so that they can be queried via SQL. In other words, I want to be able to query data from deep storage through SQL

ArvinZheng commented 3 months ago

Hi @youFireFly , have you gone through https://druid.apache.org/docs/latest/querying/query-deep-storage/ yet?

youFireFly commented 3 months ago

Hi @youFireFly , have you gone through https://druid.apache.org/docs/latest/querying/query-deep-storage/ yet?

First of all, I want to say thank you. I have read the Edit retention rules: json described in the article, but I did not find it on the ui page. I only found Edit retention rules, but there was no json edit box. Is it because of the version problem image