Is there any way data can be sorted desc while loading the data in druid ? The reason for this is, I have to eliminate order by clause in my query

In SQL order of data returned is not deterministic without an explicit order by clause In Druid native query it may be deterministic for specific query types (eg timeseries) but I don’t know for sure. My assumption is that you will still have to specify ordering, but may be performant.