This message was deleted.

I believe this is as per design and you should follow the suggestion documented in guide: https://druid.apache.org/docs/latest/querying/scan-query.html#time-ordering

Thanks, but I didn't get it, i have 13 segments but the error is saying 51 segments per time chunk and today i got another error saying 563 segments ,on the same table

Generally the segment count is picked from the metadata table, please check in the metadata table druid-segments and druid-pending segments table. May be delete the unused segments and retry.

okay thanks, how to check in the metadata.? can you just give a brief .?

Login to your metadata database, describe the table and see the columns present and accordingly you can form your query to check. something like: select dataSource, used, count(*) from druid_segments group by dataSource, used ; used=0 means segments are unused and can be deleted.

ohk, thanks a lot.!