micomahesh1982 commented on issue #16030: URL: https://github.com/apache/druid/issues/16030#issuecomment-1984977645
Thank you for your email however I’m not sure how to dynamically delete the ALL granular segments. Thanks, Regards, Mahesha S Cell:8015127140 On Thu, Mar 7, 2024 at 6:59 PM Abhishek Radhakrishnan < ***@***.***> wrote: > Ah, I think I see what's happening - you have an ALL granularity segment > that spans -146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z. > In the kill task payload noted above, you have "interval": > "1000-01-01T00:00:00.000Z/2999-12-31T00:00:00.000Z". The kill interval > doesn't cover the ALL granularity eternity interval, so the kill task won't > delete the unused eternity segment. > > In the kill task modal, when you click "Delete unused segments (issue kill > task)", you can provide the interval: > -146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z, and that > should delete the eternity segment. Then you should see that the datasource > is completely gone. > > Also, as a side note, the sys.segments table only shows used segments. > Currently, the only way to view unused segments is directly in the metadata > store: SELECT * FROM druid_segments WHERE datasource = 'temp1' AND used = > false;. > > Let us know if that helps @micomahesh1982 > <https://github.com/micomahesh1982>. Thanks! > > — > Reply to this email directly, view it on GitHub > <https://github.com/apache/druid/issues/16030#issuecomment-1984959260>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AZEDLGCTSYE2G5U2OVNNYL3YXESQXAVCNFSM6AAAAABEDGFAK2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOBUHE2TSMRWGA> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> > -- 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: commits-unsubscr...@druid.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org